Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 921
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,510
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hiding then printing a row S S Excel Worksheet Functions 4 August 9th 06 09:56 PM
Hiding rows when printing DHallam Excel Discussion (Misc queries) 1 May 21st 06 11:30 AM
Hiding the 'printing' dialog box matpj Excel Discussion (Misc queries) 3 May 15th 06 08:31 AM
Macro for hiding and printing. Olle Svensson Excel Discussion (Misc queries) 5 April 5th 06 04:21 PM
Hiding rows before printing DaveM Excel Discussion (Misc queries) 3 April 16th 05 11:38 AM


All times are GMT +1. The time now is 03:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"