I have a page in spreadsheet
Lets say columns a to z
A and B are for stock figures and also M and N are for stock figures
Is there a way to print the sheet A to Z but not have columns A,B,M,N on the
printed sheet.
I am looking for something easy as I have to get one of the office girls to
do this once its set up.
thanks
GB - 24 Apr 2008 15:27 GMT
>I have a page in spreadsheet
>
[quoted text clipped - 8 lines]
>
> thanks
Hold down the ctrl key and highlight the areas you want to print. Click
file... print area .... set print area. Save the spreadsheet and it will
remember those settings.
Gord Dibben - 24 Apr 2008 15:37 GMT
Hide them before printing.
Look at help on Custom Views.
You can set up a Printing View and a regular view.
Switch from one to the other.
Gord Dibben MS Excel MVP
>I have a page in spreadsheet
>
[quoted text clipped - 8 lines]
>
>thanks
Dave Peterson - 24 Apr 2008 21:03 GMT
Another option for the _women_ at work.
You can record a macro when you
Hide the columns that shouldn't print
print the sheet
unhide those columns
Then you can plop a small button from the Forms toolbar on that worksheet.
Assign this recorded macro to it.
Then instead of teaching your coworkers how to hide, print, show, you can tell
them that they can just click the button.
=====
When does the diversity class start for you???
<vbg>
> I have a page in spreadsheet
>
[quoted text clipped - 8 lines]
>
> thanks

Signature
Dave Peterson