ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I set the print area for a worksheet equal to nothing? (https://www.excelbanter.com/excel-discussion-misc-queries/57951-how-can-i-set-print-area-worksheet-equal-nothing.html)

David

How can I set the print area for a worksheet equal to nothing?
 
I want to print an entire file, but nothing on one tab. I dont want to
create a macro or hide the worksheet.

FinRazel

How can I set the print area for a worksheet equal to nothing?
 
Assuming "tab" means "table,"
Highlight the entire table,
Format-Cells-Font-Color-White
This will white-out the whole table, but you'll have to change it back to
see it yourself.
--
Anne Murray


"David" wrote:

I want to print an entire file, but nothing on one tab. I dont want to
create a macro or hide the worksheet.



All times are GMT +1. The time now is 11:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com