If the Print Titles ribbon button is grayed out, check to ensure that you’re not currently editing a cell or an area chart. Also, check to verify that at least one printer is set up in Windows. On the Sheet tab, in the Rows to repeat at top box, type “$1:$1” (as shown in the figure).
Also to know is, why can’t I clear the Print area in Excel?
If your Excel spreadsheet isn’t printing properly, clearing or setting a print area can often help. Sometimes the wrong print area has already been set, in which case you want to clear it. To do this from the Page Layout Ribbon, click the Print Area icon and select Clear Print Area.
Keeping this in view, how do I turn on print titles in Excel?
Print column titles on every page
- Click the sheet.
- On the Layout tab, under Print, click Repeat Titles.
- Under Print titles, click in the Rows to repeat at top box, and then on the sheet, select the row that contains the column titles. …
- Click OK.
- On the File menu, click Print.
How do you AutoFit in Excel?
Change the column width to automatically fit the contents (AutoFit)
- Select the column or columns that you want to change.
- On the Home tab, in the Cells group, click Format.
- Under Cell Size, click AutoFit Column Width.
Why does excel print blank pages?
The answer is that Excel merely prints out the cells shown in print preview mode, and if you’re printing blank pages, you’ve selected too many cells, or kept them too wide and forced Excel to print the range specified.
Why is Excel printing so small?
Method 1 – Manual Page Scaling
Step 1: Open your spreadsheet in Excel 2013. Step 2: Click the Page Layout tab at the top of the window. Step 3: Adjust the values in the Scale to Fit section so that they look like the image below. Width should be Automatic, Height should be Automatic, and Scale should be 100%.
How do I print all text in an Excel cell?
The solution: Select the cells in question and turn on text wrapping (Format>Cells>Alignment>Wrap Text). Now select the row(s) in question and manually set the row height, by right clicking the row number and selecting “Row Height”. Check the height of an adjacent row for a good value.
