How to print limited columns in sheet

[S]

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]

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

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]

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

 

[Dave Peterson]

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>