Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2008

Tip: Looking for answers? Try searching our database.

How to print limited columns in sheet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
S - 24 Apr 2008 15:01 GMT
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


Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.