MS Excel

[Mikeybude25]

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
.

 

[XL Guru]

Select columns B & C, rightclick and hide.

Print.

Unhide columns B & C using UnDo.

Rgds,
Andy

 

[Mikeybude25]

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

 

[XL Guru]

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]

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

 

[XL Guru]

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

 

[Mikeybude25]

ok thanks for that

had a look on google and found this page

http://www.erlandsendata.no/english/vba/printing/multipleselections.htm

which gives the code for a macro which prints selected cells on 1 page.

Kind of makes you wonder why MS didnt put this option in, in the first place!

Thanks again

Michael

 

[XL Guru]

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