Not print certain cells within a print range

JoeRockhead

New Member
Joined
Jan 22, 2004
Messages
2
I have a print range set from A1:K28. I don't want the contents of F10:I12 to print. What would be the best way to accomplish this? I have the print settings set to B&W so just changing the color to white won't work. TIA
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Cbrine

Well-known Member
Joined
Dec 2, 2003
Messages
3,196
You can setup multiple print ranges in the Page Setup

Print Range= A1:B3,C5:D8

This might do the job.
 

JoeRockhead

New Member
Joined
Jan 22, 2004
Messages
2
Setting up multiple print ranges, prints each range on a seperate page... Unless I'm missing something. Not quite what I'm looking for.
 

Cbrine

Well-known Member
Joined
Dec 2, 2003
Messages
3,196
Sorry Joe,
I've never used it that, just thought it might work. I don't have any other ideas for you.
 

Watch MrExcel Video

Forum statistics

Threads
1,111,910
Messages
5,541,536
Members
410,547
Latest member
htran4
Top