Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default how to print hidden column in excel spreadsheet

can any one help me how to print hidden columns while printing a table
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default how to print hidden column in excel spreadsheet

Unhide them, then print, then rehide them.

excelbuff wrote:

can any one help me how to print hidden columns while printing a table


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default how to print hidden column in excel spreadsheet



"Dave Peterson" wrote:

Unhide them, then print, then rehide them.

excelbuff wrote:

can any one help me how to print hidden columns while printing a table


-- without doing everytime hide and rehide is there any otherway to print the hidden columns

Dave Peterson

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 52
Default how to print hidden column in excel spreadsheet

Create a macro that unhides, prints and rehides. Best to assign a name to the
print range and use that as the print source.
--
Ted

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default how to print hidden column in excel spreadsheet

Look into "Custom Views".

You can save various configurations (displays) along with their print
settings, and switch from one to the other with 2 mouse clicks.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"excelbuff" wrote in message
...


"Dave Peterson" wrote:

Unhide them, then print, then rehide them.

excelbuff wrote:

can any one help me how to print hidden columns while printing a table


-- without doing everytime hide and rehide is there any otherway to print
the hidden columns

Dave Peterson


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
Stop excel from dropping the 0 in the beginning of a number? Rosewood Setting up and Configuration of Excel 12 April 4th 23 02:12 PM
sort excel spreadsheet with hyperlink jannkatt Excel Discussion (Misc queries) 0 June 13th 06 01:39 PM
A cell in an excel spreadsheet that does not print but shows in pr aji Excel Discussion (Misc queries) 1 September 5th 05 09:46 PM
How do I show hidden column and row headings in excel? Mildred Excel Discussion (Misc queries) 1 August 19th 05 04:50 PM
getting excel to print text equal to a column LadyDiby Excel Discussion (Misc queries) 0 April 11th 05 09:27 PM


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

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

About Us

"It's about Microsoft Excel"