You can also get Excel to print row numbers directly from the Page Layout tab itself. Method 2: Print Row Numbers Using the Page Layout Tab This comes under the Page Layout tab of your Excel window.
For example, you can open it using the Dialog Box Launcher (a small tilted arrow) for the Page Setup group. Note: There are other ways to get to the Page Setup dialog box.
If everything is alright, click the Print button to start printing. You should be able to now see the row numbers and column letters in the print preview. This will bring you back to the Print Preview mode. 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. 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. Here’s how you can print both row numbers and column headers using the Page Setup dialog box: It doesn’t give you the option to print either one. Unfortunately, you will need to print both row numbers and column headers using this method. So this is a great place from where you can set your printouts to contain row numbers and column letters. 
The Page Setup dialog box lets you adjust all your print and layout settings from a single place. Method 1: Print Row Numbers Using the Page Setup Dialog Box
Method 3: Print Row Numbers Using the ROW() Function. Method 2: Print Row Numbers Using the Page Layout Tab. 
Method 1: Print Row Numbers Using the Page Setup Dialog Box.
0 kommentar(er)
