ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing hidden rows or columns (https://www.excelbanter.com/excel-discussion-misc-queries/252736-printing-hidden-rows-columns.html)

Ramona

Printing hidden rows or columns
 
Is it possible to print hidden columns? My users have a column they do not
want to see on the screen but want it to print out for hand writing in the
column as there are not computers, laptops, or PDAs available at this time.

Thanks for your time.

Otto Moehrbach[_2_]

Printing hidden rows or columns
 
The only way I know to do this is to have a macro run when you want to
print. The macro would unhide the column, print the range, hide the column
again. All this can be done in the background so the user would never see
that column. Post back if you want to pursue this. HTH Otto

"ramona" wrote in message
...
Is it possible to print hidden columns? My users have a column they do
not
want to see on the screen but want it to print out for hand writing in the
column as there are not computers, laptops, or PDAs available at this
time.

Thanks for your time.



Gord Dibben

Printing hidden rows or columns
 
Check out ViewCustom Views.

One custom view can be the printout view.


Gord Dibben MS Excel MVP

On Thu, 7 Jan 2010 14:08:01 -0800, ramona
wrote:

Is it possible to print hidden columns? My users have a column they do not
want to see on the screen but want it to print out for hand writing in the
column as there are not computers, laptops, or PDAs available at this time.

Thanks for your time.




All times are GMT +1. The time now is 05:23 PM.

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