Surpass Technical Knowledge
Microsoft Office is a suite of apps like Word, Excel, PowerPoint, Access, and more. Developed by Microsoft Corporation.
Change Text Direction: Changing text directions means rotating or flipping text in all directions. If you want to change text in any direction, It does not need to have any meaningful purpose. You can change it anytime, in any direction. Flipp Text: Turning the current text face horizontally or vertically is called flipping text. Rotate…
Many people find it very easy to make a transparent text box or shape in Microsoft Office Word (Transparent Text Box or Shape is often referred to as invisible text box or shape). However most people do not even know where this customization tool is. Making a text box or shape transparent means making the…
Word always lets you insert a new page as often as you want. You can create a section of content, add a new section to the document, or create a new page to continue writing on a different page. To create a new page in Word, follow these 3 steps below: 3 Methods: Keyboard Shortcut…
The menu bar in MS Word is also known as the tab bar. Each menu has a group and each group has tools and commands, a combination of command and tools are called a ribbon. A ribbon locates under the menu bar. You can also hide it. The latest version has 10 menus (11 including…
Select Objects: Objects including shapes, ink, and text areas in a Word document can be selected in many ways. But there is an easy way out that you do not know. The method that is going to be explained in Word is very useful especially when you are working with the objects that are behind…
Vertical Writing: For a short and important piece of information to be highly effective, they need to be published in an attractive manner. Vertical writing is one such utility. Short Vertical Writing in Word or any other app is one of the useful ways to convey meaningful information without confusing the readers. In this post,…
The main requirement of the page number is to indicate where the document readers are. Readers will be able to quickly find the information they need without having to scroll through the entire subject for verification. Page numbers save time and increase content ‘engagement! In this article, you can learn how to add page numbers…
There are many shortcut keys to exit MS Word and other applications. But you need to know how to use them as needed. Let’s see what they are and how to use them! Shortcut Keys to Exit MS Word Other Apps Use any of the following shortcut keys to close Microsoft Office and other active…
Double-Spacing/ Double-Line Spacing: Making text in your Word document a single or double-space is one of the basic text formatting’s you can do. However, the default space between the lines is 1.15. Some people think that single-spaced text looks more professional, while others believe that double-spaced text is easier to read. However, the format of…
Random Text Generator: When we are practising on a word document, we need some text. Typing such text takes time based upon the length. In this way, without wasting your valuable time, MS Word and Online have the great feature to generate random text by using keyboard shortcuts within the seconds. Let’s see what they…
A Table Generator for Word: Generating a table in Microsoft Word is very easy. To generate a table in Word, there is an amazing shortcut key that you do not know. By using the shortcut key, you can easily and quickly generate a table for Word you want. Shortcut Key for Table Generator for Word:…
Word document contents can be downloaded online or shared elsewhere, each containing comments. If you do not need them, you will have to remove them. Otherwise, some of them cause some irritation. However, to remove comments in any way you like, read these 7 methods articles in its entirety. Method 1: Delete Comments Using Review…
Making a picture Watermark in Word is the easiest process. Inserting a picture watermark is the same as inserting a text watermark, with a slight difference. How to Insert Picture Watermark in Word Go to the “Design” tab (2016 and later versions of MS Office) or “Page Layout” tab (2013 and earlier versions of MS…
Most readers do not know that how to remove the watermark in Word. But it is a very easy task. However, it can be deleted in two ways. In this lesson, the Watermark deletion includes “Custom, Draft, Confidential, Do Not Copy, Sample, ASAP, Urgent”, etc. Let’s see how to remove these! Method 1: How to…
Remove a Page Break: Page breaks become an obstacle when we want to start something new that we like on a page. However, removing a page break in a word document is a very easy task. So let’s see how to remove it! Remove a Page Break in a Word Document Firstly, open the page…
Most people do not know that how to remove the header from the second page in a word document. But before doing it, you need to know some of the quicker guides to remove header from the second page. And let’s see what they are. Method 1: Remove the Header from the Second Page in…
The “Save” keyboard shortcut can be used to save the modified additions to a currently open file. The “Save as” keyboard shortcut is used to save the same file as a different file under a current name or under a different name. Save and Save as Keyboard Shortcut for Windows: The save and save as…
Definition of Undo and Redo in Word: What most people don’t know is that undo and redo are usually more advanced and faster than Keyboard shortcuts and general commands. Let’s learn how to use it. What is Undo in Word? Undo means going back one by one work that has been done previously in the document. What…
Paragraph marks are non-printable marks. This is useful for showing invisible characters related to the paragraph. For example, Word-to-word space, paragraph breaks, page breaks, tab spaces, and line breaks. To show or hide paragraph marks, read this post in its entirety. Turn on or off paragraph marks in Word: On the Home tab, in the Paragraph group, click…
A tab stop is a term used to describe the location of a computer and a typewriter. When it comes to the typewriter it is used to stop the carriage movement through the adjustable end stop. Similarly, when it comes to the computers it is used to set the insertion point in the document. You…
Even and odd page section breaks are useful when you want to start a break at the next odd or even page to have something different odd and even pages. The differences can be used for separate printing purposes with or without different page colors, thicknesses, or something else. How do even and odd page…
A Caption in Word: A caption means a short description of the table, equation, photograph, or other illustrations in MS Word. It is used to describe something that can be published in a few words. What is a Caption? The caption means a short description of a Photograph or other illustrations. A Caption to a…
Scale a Document to Legal Paper Size: Any existing word document can be easily scaled to the legal paper size or any other size. The standard size for writing legal documents is 8.5″ x 14″. Legal paper comes in both letter and legal sizes, although the former is more common than the latter. The legal…
It not only bases the values in the range of cells but also fills the color based on the values in each cell. To change cell color based on value in excel Method-1: Change Cell Color Based on Value in Excel Enter different number values in each cell of a range. Select the range of…
Accounting number formats are useful for monetary values that are related to money or currency. To change the numbers or range of cells to accounting format in excel, follow the steps below. Method -1: Apply Accounting Number Format in Excel: Select the number or range of cells that you want to change numbers an accounting…
Add zero before a number: What most people don’t know is that adding zero before a number. It is very easy to add zeros before any number. This is very important for accounting, dialling codes, and so on. Steps to Add Zeros Before a Number in Excel: First, select the range of cells that you…
Many of our subscribers ask a question “Excel is not Recognizing Numbers in Cells”. That is why we are giving you a wonderful solution as per their wish. If Excel does not recognize the cell, it gives a 0 result when using any function, or shows only the function instead of the result when calculating…
To use a total formula in excel, one must know the excel interface and basic knowledge over a cell, cell reference, row, column, range, mathematical operators, and the difference b/w formulas and functions. To return the total in excel, we have many formulas and functions. Total Formula and Function in Excel: To add numbers in…
Create a photo album in PowerPoint for your beautiful and favourite photo collections. To do so, follow the steps below. Steps to create a Photo Album: Go to the Insert Tab Click on the Photo Album in the images group to open a dialogue box In the Photo Album dialogue box, click File/Disk to open…
Hyphenation in MS Word is used to break the last word of any line beyond the edge of the document and correct it by distributing equally to the current line and its bottom line. Doing so will give clear and uniform spacing for the text of the document beautifully. There is no need to justify…
A Draw tab in Word is used to draw different colored inks with Pen, Pencil, and Highlighter with different effects. Adding Draw Tab to the Ribbon If your ribbon doesn’t have a draw tab, then add the draw tab to it. To add “Draw” tab, click “File” menu and select “Options” to launch a dialogue…
Freezing the Upper, Left, or both parts of the Row and Column Headings to keep it visible while the rest of the worksheet scrolls up and down or left and right, called Freeze Panes. Remove freezing the rows, columns, or both is called Unfreeze Panes. In other words: For example, If the data in the…
In fact, in a professional way in Word, you do not have the option to change the page color in Word. However, if you are familiar with Word, you need to come up with an idea on how to add your favorite colors to the background of your favorite pages. If you still do not…
By default, you can’t use the show or hide ink option . To use the ink annotation you need to add the draw tab to the ribbon, or you can use it directly if your computer has touch screen. Ink Annotation in MS-Word, Excel PowerPoint is used to highlight the content or draw something you…
Giving full, partial, or no permission to edit the content of the selected range in a worksheet and protecting the rest of the worksheet completely with a password is called Allow Edit Ranges. If you want to give a password for the entire worksheet and also give a password to a range of your choice…
Break down a sentence, or a line, or a group of words based on the delimiters and fill them into each cell of a column is called Split Text to Columns. Steps to Split Text to Columns in MS Excel: Select text that you want to split text to columns On the Data tab, in…
Data validation is the application of a required restriction to a cell or a cell range. After doing so, if a user enters any restricted value into any cell of data, it will give a reminder-like message without accepting that value. Here, only unrestricted value can be accepted. Getting Started With Data Validation to Range…
Skip Blanks or Skip Blank Cells means, for example, if you copy the cells with and without value in a range called A and apply it to range B which is filled with values, then the values will be overwritten and the blank cells will be skipped. Steps to Skip Blanks or Skip Blank Cells…
Transpose means changing the row data as column data, or vice versa. This option is a part of the paste special in Excel. Steps to Transpose Data: For example, suppose you have the following data which is related to students details. SN First Name Last Name Roll Number Class Section 1 Vadithe Omkar 54 X…
Paste link is copying the range of a workbook’s sheet (with or without text) and linking it to another worksheet of the same workbook or another workbook’s sheet. Doing so will automatically update the content in the pasted range when you update or enter the content in the copied range. Link Range of Cells Between…
There is a difference between count and counta in excel. A function called count counts all the numbers (only numeric data) in a range of the cells or in the selected cells, whereas a function called counta counts all the characters such as numbers, letters, and any other characters in a specified range of the…
Inserting page numbers into a Word document is easy, but adding page numbers from a specific page is a bit tricky. However, in this article, you can follow the simple steps below to insert a page number from a specific page in MS Word. It is very important for us to start the page numbers…
The Header and Footer Tools Design tab is very useful to customize the header and footer you like. To open the header and footer tool design tab, double-click on the top or bottom of any page or go to the Insert tab → click the drop-down arrow of the Header or Footer → select one of the…
Define the Usage of Mail Merge in MS Word The Main Purpose of Mail Merge in MS Office is to send mail to multiple recipients by writing and inserting fields into the document such documents are letters, envelopes, e-mail messages, labels, and documents are called Mail merge (Mailings Tab) that is available in MS Office suits such…
One should learn how to print a word document, Excel Worksheet, and PowerPoint slides, which are familiar to us, but not all advanced printing. If you can learn how to print with all these, you will easily print any document. How to Print a Word Document: To print a document or to open a word…
Bring Forward and Send Backward: Bringing the selected object (Shapes, Picture, etc.) forward to one object or in front of all other objects is called Bring Forward. Similarly, sending the selected object back to one object or all other objects, called Send Backward. Bring Forward: You can bring an object one step forward to another…
The Table of Content is the most important for every soft and hard copy material. It is based on the heading levels of the content in the document and can be added where necessary at any beginning of the same document. Without the table of contents, one cannot easily guess the inner appearance of any…
Align Objects | Distribute Objects in Word, Ppt, & Excel Manually aligning objects is a time-consuming process. But Word, Ppt, Excel has a great feature to align any object, such as a picture, shape, textbox, 3D Models, Icons, etc. with a click. Besides this, you can also easily distribute more objects horizontally or vertically. Important…
Go To in Microsoft Word Go To command is one of the best ways to move forward or backward relative to the location of a page, paragraph, line, section, bookmark, footnote, endnote, field, table, graphic, equation, etc. (To go to a specific location in a word document and the number of items you can move…
Introduction to MS-Word – User Interface to Microsoft Word Microsoft Word is a powerful word processing application software and is part of the MS Office Suite of Applications. Word is used to sort, share, and store data with different formatting such as Real-Time Format (RTF), Unformed, Html Format, Unformulated Unicode Text, Picture Enhanced Meta File…
