How to Repeat Excel Spreadsheet Column Headings at Top of Page Show
Use this feature if you would like a title row (or rows) to print at the top of every page of your data in Excel. Note:
Note: Keywords: header, formatting, excel Share This Post
Today I'd like to tell you about a small but important feature tucked away in Excel 2016 and its previous versions. In this article you'll learn how to make header rows and column headers print on each page. If you often have to print large and complex Excel worksheets, I am sure that you face this problem as often as I do. I can easily scroll up and down through the document without losing sight of the column titles because I have the header row frozen. However, when I print the document, the top row is printed only on the first page. If you are sick and tired of turning the printouts back and forth to see what kind of data is in each column or row, feel free to find out the solution to the issue in this article. Repeat Excel header rows on every pageYour Excel document turns out to be long and you need to print it. You go to the print preview and find out that only the first page has the column titles at the top. Take it easy! You can specify the Page Setup settings to repeat the top row on every printed page.
There you go! Now you know exactly what the columns mean on every page. Get a header column on every printoutWhen your worksheet is too wide, you'll have the header column on the left only on the first printed page. If you want to make your document more readable, follow the steps below to print the column with row titles on the left side of every page.
Now you don't have to turn the pages back and forth to find what the values in each row mean. Print row numbers and column lettersExcel normally refers to worksheet columns as letters (A, B, C) and to rows as numbers (1, 2, 3). These letters and numbers are called row and column headings. As opposed to row and column titles that are printed only on the first page by default, the headings are not printed at all. If you want to see these letters and numbers on your printouts, do the following:
Does it look as you desired now? :) The Print Titles command can really simplify your life. Having header rows and columns printed on every page allows you to understand the information in the document more easily. You won't lose your way in the printouts if there are row and column titles on each page. Try it out and you can only benefit from it! You may also be interested inHow do I print columns and Rows on every page in Excel?Print row or column titles on every page. 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 get my Excel spreadsheet to print on one page?Shrink a worksheet to fit on one page. Click Page Layout. ... . Select the Page tab in the Page Setup dialog box.. Select Fit to under Scaling.. To fit your document to print on one page, choose 1 page(s) wide by 1 tall in the Fit to boxes. ... . Press OK at the bottom of the Page Setup dialog box.. What will you click if you want to print all the columns on one page?Change the Scaling (Fit All Rows/Columns in One Page). Click the File tab.. Click on Print (or use the keyboard shortcut – Control + P). In the Print window, click on the Scaling option (it's the last option on the left). Click on any one of the options: Fit Sheet on One Page. Fir All Columns on One Page.. How do you guarantee all columns will print?Fit All Columns on One Page. On the Ribbon, click the File tab, then click Print.. In the Settings section, click the arrow at the right of No Scaling.. Click on Fit All Columns on One Page.. |