ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to print hidden column in excel spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/107971-how-print-hidden-column-excel-spreadsheet.html)

excelbuff

how to print hidden column in excel spreadsheet
 
can any one help me how to print hidden columns while printing a table

Dave Peterson

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

excelbuff

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


TedMi

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


RagDyeR

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




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

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