Hide 70 columns and print?

A

~Alan

XL2000
Is there away to hide the first 70 columns and still have the hidden columns print?
 I tried to hide the columns but they wont print
 
 
F

Frank Kabel

Hi
you could create a macro which will do the following (you may record
one while doing this manually):
- unhide the columns
- print the sheet
- hide the columns again
 
R

Ragdyer

You could try this.

Scroll your sheet until cell BS1 is the top, left cell in your screen view.
Click in cell BT1, then do:
<Window> <Freeze Panes>

It's now impossible to scroll to the first 70 columns.

However, you can still navigate the selected cell around the entire sheet by
using the name box or <F5>.
This allows the data in these cells to display in the formula bar.

Of course, you could do a <Alt> <V> <F>, and hide the formula bar together
with the name box.
You could also do a <Tools> <Options> <View> tab,
and *uncheck* "Row & Column Headers", and not allow anyone to even know what
columns they were viewing, so that they wouldn't even know that something
was hidden out of sight.
 
Top