ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hiding Data while printing (https://www.excelbanter.com/excel-discussion-misc-queries/151084-hiding-data-while-printing.html)

Jeff

Hiding Data while printing
 
Is there a way to hide data when printing? I have data in columns a thru f,
but when I print I do not want to see the data in columns C or E. This is
for a proposal form I am designing.

Thanks.

OssieMac

Hiding Data while printing
 
Check out hide columns in help.

Regards,

OssieMac

"Jeff" wrote:

Is there a way to hide data when printing? I have data in columns a thru f,
but when I print I do not want to see the data in columns C or E. This is
for a proposal form I am designing.

Thanks.


Gord Dibben

Hiding Data while printing
 
Hide those columns before printing.

Unhide them after printing.

You can use ViewCustom Views to make two views of the sheet.

Pick the view with hidden columns then print.


Gord Dibben MS Excel MVP

On Fri, 20 Jul 2007 13:54:01 -0700, Jeff wrote:

Is there a way to hide data when printing? I have data in columns a thru f,
but when I print I do not want to see the data in columns C or E. This is
for a proposal form I am designing.

Thanks.




All times are GMT +1. The time now is 12:06 AM.

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