Mac: Ctrl+Option+Enter; Just use the shortcut whenever you want to insert a line break (and save the Enter key for navigating to the next cell). This might take some getting used to, but can come in handy depending on what you're working on. Insert Feature. Inserting a single logo in Excel is just the tip of the iceberg of what the software can do. The 'Insert' feature supports more than just picture files.
We’ve shown you how to of large spreadsheets in Excel. The same thing can be done in Word for longer documents. It’s a bit different than in Excel, so read on to find out how. RELATED: There are two ways to add “Page X of Y” to a header or footer in Word. The easiest way is to use the Page Number gallery. However, using the Page Number gallery replaces any content you already have in your header or footer.
If you currently have content in your header or footer and you want to add “Page X of Y” to that content, you can use field codes. We’ll show you both methods.
NOTE: When we say to type something in this article and there are quotes around the text, DO NOT type the quotes, unless we specify otherwise. Using the Page Number Gallery To insert “Page X of Y” using the Page Number gallery, click the “Insert” tab.
In the “Header & Footer” section, click “Page Number” and move your mouse over either “Top of Page” or “Bottom of Page” in the drop-down menu. A list of readymade page number styles displays. Scroll down to the “Page X of Y” section and select one of the “Bold Numbers” styles, depending on whether you want your page numbers left-, center-, or right-aligned.
The page number and total number of pages are added to the header or footer. Note that the page numbers are bold. If you don’t want the page numbers to be bold, select the text and click “Bold” in the “Font” section of the “Home” tab. Using Fields If you already have content in your header or footer and want to add “Page X of Y” without replacing that content, you can add page numbers using fields. To do so, open the header or footer and place the cursor where you want to insert “Page X of Y”. Type “Page” and a space.
Click the “Insert” tab. In the “Text” section, click the “Quick Parts” button and select “Field” from the drop-down menu. The “Field” dialog box displays.
In the “Field names” list, scroll down and select “Page”. You can change the format of the page number by selecting an option in the “Format” list, but we’ll accept the default format. The page number of the current page is inserted at the cursor. After the page number, type a space, then “of”, then another space. Click the “Quick Parts” button in the “Text” section of the “Insert” tab again and select “Field” from the drop-down menu. This time, select “NumPages” in the “Field names” list. Accept the default values for “Format” and “Numeric format” and click “OK”.
The page number and total number of pages are inserted at the cursor in your header or footer. Get more information on how to, or in Word.
Have you tried to type an ampersand (&) in a header or footer in Excel and seen it disappear on your printed worksheet? There’s a special trick to typing ampersands in headers and footers in Excel so you don’t lose them. For example, a company with an ampersand in their name–like our fictional “Smith & Jones” law firm–may want to put their name in the header.
However, the ampersand is used in Excel headers and footers as a “marker” that indicates a special formatting code follows. We’ll show you the trick to including an ampersand in your header or footer text. To add a header or footer to your workbook, click the “Page Layout” tab. In the “Page Setup” section, click the “Page Setup” button in the lower-right corner. The “Page Setup” dialog box displays. Click the “Header/Footer” tab. There are ready-made headers and footers available, but we want to create a custom header or footer.
For our example, we’re going to add a header to our workbook, so click “Custom Header”. This procedure works the same way for custom footers. In the Header (or Footer) dialog box, enter the text you want to display in the header or footer. You can enter your text in the Left section, Center section, or Right section, depending on where in the header or footer you want the text to display.
Here’s the trick. When you type your ampersand, type two of them, one right after the other, as shown in the following image. In our case, that means typing “Smith && Jones”. Then, click “OK”. You are returned to the Page Setup dialog box.
Notice that the header text displays in the sample header with one ampersand. Your header or footer will now display one ampersand when you print the worksheet or workbook. In addition to this trick for typing ampersands into headers and footers in Excel, you can also.