#EXCEL HIDE COLUMNS WHEN PRINTING DOWNLOAD#
Make sure to download the sample file for this tutorial so you can see this feature in action. There is displaying of hidden data in the rows and the columns.
![excel hide columns when printing excel hide columns when printing](https://cdn.mos.cms.futurecdn.net/SyS5iKJuJkwG7MzzsAMTdS-970-80.png)
Document formatting for easy viewing and preparing of the printing. When you save and close your document, Excel will remember the option for repeating the titles. Configure the visibility of data by hiding rows and columns. This is a really helpful feature to prepare spreadsheets for printing and it's really easy to implement.
![excel hide columns when printing excel hide columns when printing](https://i.stack.imgur.com/uNHcy.png)
Right-click on the column or row to hide. You can hide those rows or columns so that they do not print. To repeat columns on each page, instead of rows, in Step 2 above, click the button next to the right of where it says Columns to repeat at left: In Step 3, click the column to repeat the rest of the steps are basically the same. Excel 2013: Print Visible Cells Updated: 3/15 Print Visible Cells In Excel 2013, you may have rows or columns on the spreadsheet that you do not want to print when printing the spreadsheet. This is what each page will now look like:
#EXCEL HIDE COLUMNS WHEN PRINTING HOW TO#
![excel hide columns when printing excel hide columns when printing](https://www.jquery-az.com/wp-content/uploads/2019/07/51.1-Excel-hide-column-sel.png)
But when I go to actually print, all of the columns will be printed. Do dont want to print all of the columns - e.g. In the window that opens, make sure you are on the Sheet tab then, click the button to the right of where it says Rows to repeat at top: When I am working on it, I keep most of the columns hidden.Go to the Page Layout tab and click the Print Titles button:.Steps to Print Specific Rows/Columns on Each Page This is a handy little tip that makes reading printed documents much easier. How to repeat specific rows or columns on every printed page so that you know what each column or row means when you are reading through the document.