How do I print only certain columns on one page in Excel?
Printing Selected Rows Or Columns On Every Page of an Excel Worksheet
Last month I talked about how you can freeze rows or columns in an Excel workbook so that your headings stay visible on screen. This month I’ll show you how you can choose rows or columns to appear on every page when you print. This lets you print a report heading and/or column/row headings on each page without having to actually place them throughout your worksheet. This is all you have to do:
Here are a couple of additional details. The rows (or columns) to repeat have to be adjacent, for example you can’t select rows 1 and 3, but not 2. Also, you only select entire rows (or columns) to repeat.
The rows you selected don’t have to be at the top of your worksheet – i.e. row 1. Let’s say you have a report heading in rows 1 through 3 and column headings in rows 4 and 5. If you select rows 4 and 5 as “Rows to repeat at top” page 1 will still print as it appears on screen but beginning with page 2, only rows 4 and 5 (not 1-3) will appear at the top of each printed page.
To take that example to the extreme, if you selected row 500 at “Rows to repeat at top” it would not begin repeating until the page after the page that row 500 naturally prints on.
The same principle applies to “Columns to repeat at left”.
This entry was posted on August 30, 2018, 11:30 am and is filed under All, General Tips. You can follow any responses to this entry through RSS 2.0. Both comments and pings are currently closed.
There are times when you need to print out data from Excel. But often times you don’t need to print out the entire report which wastes paper, ink, and time.
There will be many times when you need to print out Excel spreadsheets at the office or home office. But oftentimes, you really don’t need to print out the entire report, which wastes paper, ink, and time. Here’s how to print out only the specific areas of the spreadsheet that you need.
Note: For this article, I am using Excel in Office 2013, but the principle is the same in other versions of Excel, too. The controls are just located in different areas on the Ribbon and toolbars.
Print Select Areas of Excel Spreadsheets
Start by opening the Excel spreadsheet you need, hold down the Ctrl key and highlight the area of the document you want to print out.
After selecting the area you want to print out, go to Page layout > Print Area > Set Print Area.
You won’t really notice anything happen to the document at that point, but next, while still under the Page Layout tab, click Print Titles.
Next, select the Sheet tab in the Page Setup windows that appears. From here, type in the Columns and Rows that you want to repeat (if any), then click on Print Preview. This allows you to include any headers or labels associated with the data.
Now you will get a view of the area you’re printing out. And you can select the printer you want to use and adjust print settings. You can get deep into the printer settings. You can tweak the preview area and manually type in more cells if you want to include them.
If you get too deep into adjusting print areas, they will stay until you clear them out. From the ribbon under Page Layout, click Print Area > Clear Print Area.
This is a great way to save printer ink and paper, as well as time for you and your colleagues. Nothing is worse than someone printing out 500 pages when you need the printer to get one simple page.
Also, remember you don’t need to waste time and ink printing out entire web pages either. If you only want to print out specific info from an article, read our article: How to print only selected text from a webpage.
How do I print only certain columns in sheets?
How to print selected cells in Google Sheets.
Open the Sheets document you wish to print. ... .
Highlight the cells you want to print..
Hit Ctrl + P on a PC, or Command + P on a Mac, or go to File, then select Print at the very bottom of the list. ... .
In Print options, choose "selected cells.".
How do I print selected area in Excel on one page?
Fit to one page.
Click Page Layout. Click the small Dialog Box Launcher on the bottom right. ... .
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..
How do I print selected fields in Excel?
Change a selected print area.
On the worksheet, click and drag to select the cells you want to print..
Select File > Print > Print..
To print only the selected area, in Print Options, select Current Selection..
If the print preview shows what you want printed, select Print..
How do I print certain rows and columns in Excel?
On the Ribbon, click the Page Layout tab. In the Sheet Options group, under Headings, select the Print check box. , and then under Print, select the Row and column headings check box . To print the worksheet, press CTRL+P to open the Print dialog box, and then click OK.