MS Excel

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Mikeybude25

Thread Starter
Joined
Feb 13, 2004
Messages
42
I have got a spread sheet and i want to print say column A
and D so i select column A hold down CTRL and highlight
column D i then go to print, however it prints it out on
seperate pages, is there anyway to print it on 1 page.

Thanks Michael
.
 
Joined
Aug 30, 2003
Messages
2,702
Select columns B & C, rightclick and hide.

Print.

Unhide columns B & C using UnDo.

Rgds,
Andy
 

Mikeybude25

Thread Starter
Joined
Feb 13, 2004
Messages
42
XL Guru said:
Select columns B & C, rightclick and hide.

Print.

Unhide columns B & C using UnDo.

Rgds,
Andy
Yeah thats what ive been doing but its a bit of a pain in the A$$ when i have a lot of different columns/rows that i wanted printed. Any other suggestions?

Thanks

Michael
 
Joined
Aug 30, 2003
Messages
2,702
If the "pain in the A$$" is that you have to not print B&C today, & then again tomorrow, etc., etc. ; consider defining custom views (via the View menu).

Might also help that you can select column D, click on a border then drag it over B&C while holding down SHIFT to slot it between A&B.

Rgds,
Andy
 

Mikeybude25

Thread Starter
Joined
Feb 13, 2004
Messages
42
So basicly there is no way to select the cells i want, put a tick in some obscure box in some hidden options and have it print on 1 page?

Thanks

Michael
 
Joined
Aug 30, 2003
Messages
2,702
Not to the best of my knowledge.

You could write some code, but this would just automate the Hide -- Set Print Area -- Unhide steps.

Rgds,
Andy
 
Joined
Aug 30, 2003
Messages
2,702
Yeah, something like that. It's pretty verbose and for selected ranges ; if you're purely hiding columns &/or rows, you might find

Sub Show_All()
ActiveWindow.SelectedSheets.PrintOut Copies:=1, _
Collate:=True
Cells.Select
Selection.EntireColumn.Hidden = False
Selection.EntireRow.Hidden = False
End Sub

vaguely useful for the printing/resetting.

Rgds,
Andy
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top