How to print row and cavalcade headers of Excel spreadsheets on every folio
Today I’d like to tell you most a small merely important characteristic tucked away in Excel 2016 and its previous versions. In this commodity you’ll learn how to make header rows and column headers impress on each page.
If you lot ofttimes have to impress large and complex Excel worksheets, I am sure that you face this trouble as oftentimes equally I do. I can hands scroll up and down through the certificate without losing sight of the column titles because I have the header row frozen. However, when I print the certificate, the top row is printed simply on the first page. If you are ill and tired of turning the printouts back and forth to see what kind of data is in each cavalcade or row, feel complimentary to find out the solution to the issue in this commodity.
Echo Excel header rows on every page
Your Excel document turns out to exist long and you demand to print it. You get to the print preview and find out that only the first page has the column titles at the top. Take it easy! You tin can specify the Page Setup settings to repeat the pinnacle row on every printed page.
- Open the worksheet that you’re going to print.
- Switch to the
- Click on
- Make sure that you’re on the
tab of the
Rows to repeat at top
- Click the
adjacent to “Rows to repeat at summit” field.
dialog window is minimized and y’all go back to the worksheet.
You tin find that the cursor changes to the black arrow. Information technology helps to choose an unabridged row with one click.
- Select a row or several rows that you want to print on every folio.
To select several rows, click on the commencement row, printing and hold the mouse button and drag to the last row yous want to select.
button again to return to the
At present your selection displays in the
Rows to repeat at peak
You can skip steps vi-viii and enter the range using the keyboard. However, pay attention to the manner you enter it – yous demand to use the absolute reference (with the dollar sign $). For example, if you want to see the first row on every printed page, the reference should await like this: $ane:$i.
- Click on
to run across the upshot.
There you go! Now you know exactly what the columns mean on every page.
Get a header column on every printout
When your worksheet is too wide, yous’ll accept the header column on the left only on the outset printed page. If you want to make your certificate more readable, follow the steps below to print the cavalcade with row titles on the left side of every folio.
- Open the worksheet that yous desire to impress.
- Go through steps 2-4 every bit described in
Repeat Excel header rows on every folio.
- Click the
button to the correct of the
Columns to echo at left
- Pick a column or columns that you want to meet on every printed page.
push again to cheque if the selected range is displayed in the
Columns to repeat at left
- Press the
button in the
dialog box to look at your document before printing.
Now you don’t accept to turn the pages dorsum and forth to find what the values in each row mean.
Print row numbers and column messages
Excel usually refers to worksheet columns as letters (A, B, C) and to rows as numbers (i, 2, 3). These letters and numbers are chosen row and column headings. As opposed to row and column titles that are printed merely on the outset page past default, the headings are not printed at all. If you desire to come across these letters and numbers on your printouts, practice the following:
- Open the worksheet that you lot want to print with the row and column headings.
- Become to the
group on the
- Check the
In example you withal accept the
window opened on the
tab, just bank check the
Row and cavalcade headings
box in the
section. It also makes the row and column headings visible on every printed page.
- Open the Print Preview pane (FILE -> Print
Ctrl+F2) to bank check the changes.
Does information technology wait equally you desired now? 🙂
The Print Titles command tin can really simplify your life. Having header rows and columns printed on every page allows you to understand the information in the certificate more hands. You won’t lose your way in the printouts if in that location are row and column titles on each page. Try it out and you lot can only do good from it!
You may also exist interested in
58 comments to “How to impress row and column headers of Excel spreadsheets on every page”
Post a comment