Click on the tab of the worksheet you want to copy. Then hold down the Shift or Ctrl key and click on the tab of the worksheet where you want the settings and click on File, Page Setup and OK . Bonus : It will do more than copy all the basic print settings; it also will copy header and footer settings.
– Click the sheet.
– On the Page Layout tab, in the Page Setup group, click Page Setup.
– Under Print Titles, click in Rows to repeat at top or Columns to repeat at left and select the column or row that contains the titles you want to repeat.
– Click OK.
– On the File menu, click Print.
What is the use of print title?
Excel 2013’s Print Titles feature enables you to print particular row and column headings on each page of the report. Print titles are important in multipage reports where the columns and rows of related data spill over to other pages that no longer show the row and column headings on the first page.
Why can’t I use print titles in Excel?
On the Page Layout tab, in the Page Setup group, click Print Titles. 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.
How do I enable print titles in Excel 2016?
– Click the sheet.
– On the Page Layout tab, in the Page Setup group, click Page Setup.
– Under Print Titles, click in Rows to repeat at top or Columns to repeat at left and select the column or row that contains the titles you want to repeat.
– Click OK.
– On the File menu, click Print.
How do I enable print in Excel?
On the PAGE LAYOUT tab, in the Sheet Options group, check the Print box under Gridlines. Click FILE > Print. You can also press Ctrl+P.
Why can I not select print titles in Excel?
On the Page Layout tab, in the Page Setup group, click Print Titles. 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.
How do I turn on headings in Excel?
– Go to the Insert tab > Text group and click the Header & Footer button. .
– Now, you can type text, insert a picture, add a preset header or specific elements in any of the three Header boxes at the top of the page. .
– When finished, click anywhere in the worksheet to leave the header area.
Why does excel not print rows and column headings?
Print Row and Column Headings Click the “Page Layout” tab, if it’s not already the active tab. In the “Sheet Options” section, select the “Print” check box under “Headings” so there is a check mark in the box.
Why can’t I print my Excel spreadsheet?
If your Excel spreadsheet isn’t printing properly, clearing or setting a print area can often help. . To do this from the Page Layout Ribbon, click the Print Area icon and select Clear Print Area.
How do I print a title in Excel?
– On the Page Layout tab, in the Page Setup group, click Print Titles. The Page Setup dialog box appears.
– To repeat row 1 at the top of each printed page, click in the corresponding box and select row 1.
– Click OK. .
– On the File tab, click Print for a print preview.
Where is print titles in Excel?
– On the Page Layout tab, in the Page Setup group, click Print Titles. The Page Setup dialog box appears.
– To repeat row 1 at the top of each printed page, click in the corresponding box and select row 1.
– Click OK. .
– On the File tab, click Print for a print preview.
Why is Page Setup greyed out in Excel?
It could be that someone has protected that aspect of the sheet. Go to the Review tab and look in the Protect Sheet icon to see if this is the case. Sometimes, things on the Ribbon are grayed out because Excel is “thinking”.
How do you reset page setup in Excel?
– Click the worksheet that you want to modify.
– On the View tab, in the Workbook Views group, click Page Break Preview. .
– On the Page Layout tab, in the Page Setup group, click Breaks.
– Click Reset All Page Breaks.
How do I get the header back to normal in Excel?
To close the header and footer, you must switch from Page Layout view to Normal view. On the View tab, in the Workbook Views group, click Normal. on the status bar.
How do I repeat print titles in Excel?
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.
How do I unlock print titles in Excel?
On the Page Layout tab, in the Page Setup group, click Print Titles. 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.
Last Review : 11 days ago.
Don’t forget to share this post !
References