- Start here
- Additional services
- About Endsight
If you have ever printed an Excel spreadsheet, you probably are aware of how tricky it can be to get your document to come out exactly how you want. Lucky for you, we have some tips to help you print out your next Excel spreadsheet to the exact specifications you desire. It's actually pretty easy once you get the hang of it.
If you would like an alert when the latest video debuts, you can subscribe to our YouTube Channel.
Congratulations! You are already 80% there, but if you would like to fine-tune margins, or add a title, and page numbers before printing, proceed to steps 4 & 5.
As much as I would like to explain how to fine tune your print job, it is very difficult to explain without showing. The video explains it MUCH better than I can in writing. Find this at the two-minute mark.
Have you ever needed to print a large excel data sheet and had trouble with the formatting?
In this Quick Tip, we will learn how to add headers and footers, find appropriate scaling, and how to use the Print Titles function so your row and column headings appear on every page instead of making sure you don’t get any pages that look like this.
Whenever printing a worksheet it’s always best to set your print area first.
If I were to zoom out with the zoom slider, we’d see an area that I don’t want to be printed. I only want to print this data here. So let’s zoom back to 40% and highlight all the data that we want Excel to print.
Then go to Page Layout tab under the Page Setup section and click Print Area … Set Print Area. So now just this area of our spreadsheet will be printed.
And let’s zoom back in. To lock our headings for printing, in the same Page Setup section click on Print Titles.
We are looking at these two boxes here. Rows to repeat at top and columns to repeat at left.
You can type in the lock code here or use these buttons. Or you can simply put your cursor in the Rows box then drag-click the first two rows two represent the entire row heading. And then select the Columns box and click anywhere on the column heading.
Let’s see what this data looks like. We can use one of these two buttons to get to the Print page or we can go to the tab and select Print.
We can go down here to click through the various pages and see that our column and row headings stay fixed, allowing us to see what this data is representing.
And just eyeing this here, I’d like to change the Orientation from Portrait to Landscape. And let’s see if I can get this whole excel worksheet onto 4 pages.
Click on this Page Setup shortcut.; Change this to Fit 2 pages wide by 2 pages tall. Click Okay.
And there we have it. Our document is ready for printing with all the row and column headings locked.
Now you know how to lock row and column headings when you are viewing data on a computer monitor in Excel or viewing data on pages of a large worksheet.