You can also click Page Layout on the status bar to display this view.By default, the page numbers will display on every page when you insert page numbers, however, you can customize page numbers only on certain page. Excel displays the worksheet in Page Layout view. On the Insert tab, in the Text group, click Header & Footer.Method 3: Print Row Numbers Using the ROW() FunctionMethod 1: Print Row Numbers Using the Page Setup Dialog BoxThe Page Setup dialog box lets you adjust all your print and layout settings from a single place. Method 2: Print Row Numbers Using the Page Layout Tab Rest the pointer on the page break line until the pointer changes to a , and then drag the page break line to a new location. On the View tab, click Page Break Preview. Please see the steps below for details: Step 1: Click the 'Insert' tab from the ribbon On the Page Layout tab, click Breaks, and then click Insert Page Break.Just below these setting options, you will see a link that says ‘Page Setup’. On the left-hand side, you will see a list of options (drop-down menus) under Settings. This will bring you to Print Preview mode Press CTRL+P (if you’re on a Mac, press Cmd+P), or navigate to File->Print. Make sure your worksheet is ready for printing. It doesn’t give you the option to print either one.Here’s how you can print both row numbers and column headers using the Page Setup dialog box: Click OK to close the Page Setup dialog box. Make sure the checkbox next to ‘ Row and Column headings’ is checked. Under the Print section, you will find four checkboxes. Click on the Sheet tab in the dialog box. This will open the Page Setup dialog box.
![]() This comes under the Page Layout tab of your Excel window.Method 2: Print Row Numbers Using the Page Layout TabYou can also get Excel to print row numbers directly from the Page Layout tab itself. For example, you can open it using the Dialog Box Launcher (a small tilted arrow) for the Page Setup group. If everything is alright, click the Print button to start printing.Note: There are other ways to get to the Page Setup dialog box. You should be able to now see the row numbers and column letters in the print preview. ![]() Just like method 1, you cannot set it to print just the row numbers. You can now go ahead and check the print preview by pressing the shortcut CTRL+P on the keyboard (Cmd+P if you’re on a Mac).Note: This method lets you include both row numbers and column headers in your printout. This will make sure your printout contains the row and column headings for each cell. Insert an extra column to the left of the first column of your sheet (by right-clicking on the first column header and clicking insert from the popup menu that appears). However, there is a way around this, and that is by using the ROW() function.The ROW function is a built-in function in Excel that returns the row number for a particular cell.When you enter just the ROW function without any parameters in the parentheses, then it returns the row number for the cell that it is entered into.If instead, you include a cell reference into the parentheses, then it returns the row number for that particular cell reference.Similarly, if you put just =ROW() in cell A1, it will also return 1 and if you put it in row A6, it will return 6.Now let us see how you can use the ROW() function to print row numbers in your sheet: Method 3: Print Row Numbers Using the ROW() FunctionThe first two methods are great if you are alright with getting columns headers along with row numbers in the printout.If you want just the row numbers, not the column headers, then there’s, unfortunately, no menu option for this in Excel. Dauntless strong vs weak dmg weaponsFormat the new column (A) to appear in your desired format. You now have row numbers for all data. This will copy the formula to all the rows containing data. Drag down the fill handle (located at the bottom right corner) of this cell till the last row of your data. ![]()
0 Comments
Leave a Reply. |
AuthorKen ArchivesCategories |