
Print row and column headings - Microsoft Support
By default, Excel doesn't print the column headings (A, B, C, etc.) or row headings (1, 2, 3, etc.) that appear along the borders of the sheet. Follow these steps to print the column and row headings for a …
Print a worksheet or workbook - Microsoft Support
In Excel for the web, when you print a worksheet with hidden rows or columns those hidden rows and columns won't be printed. If you want to include the hidden rows and columns, you'll need to unhide …
Print rows with column headers on top of every page
If a worksheet spans more than one page, you can print row and column headers or labels (also called print titles) on every page. For example, you can repeat the first row of column headers on all pages …
Repeat specific rows or columns on every printed page
In the Columns to repeat at left box, enter the reference of the columns that contain the row labels. For example, if you want to print column labels at the top of every printed page, you could type $1:$1 in …
Set or clear a print area on a worksheet - Microsoft Support
If you print a specific selection on a worksheet frequently, you can define a print area that includes just that selection. A print area is one or more ranges of cells that you designate to print when you don't …
Scale a worksheet - Microsoft Support
If your worksheet has a lot of columns, you can use the Scale to Fit options to reduce the size of the worksheet to better fit the printed page. Follow these steps:
The column width is not the same when printed in Excel
Depending on the fonts you use, column widths and row heights may appear differently when you print or view a worksheet in print preview. This behavior occurs when you use proportionally spaced fonts, …
Fit to one page in Excel - Microsoft Support
By scaling your worksheet for printing, you can make your data fit to one page. You can shrink your Excel document to fit data on a designated number of pages using the Page Setup option in the …
Display numbers as postal codes - Microsoft Support
That's because Excel interprets the column of postal code values as numbers, when what you really need is for them to be stored and formatted as text. To solve this problem, in step 3 of the Text …
Print headings or titles on every page in Excel for Mac
If you want to print a sheet that will have many printed pages, you can set options to print the sheet's headings or titles on every page. Excel automatically provides headings for columns (A, B, C) and …