HOW DO I SHOW ONLY THE CELLS USED IN THE WORKSHEET INSTEAD OF THE.

D

DanW

When I write a worksheet, can I get excel to only show the cells used in the
worksheet instead of the whole horizontal and vertical lines of unused cells?
 
M

Mike Rogers

DanW

The easiest way is to "Hide" them.
Select the first row you want to hide, press "Shift then ctrl then the right
arrow. This should select all columns to the right of you project. Right
click and select "Hide" (or goto>format>cloumn>hide)

Do the same thing with the rows but of course make the proper adjustments in
the instructions.

Mike Rogers
 
M

Mike Rogers

DanW

Boy !!!! I made that difficult!!! Select the first COLUMN you want to hide.
then I think you can figure it out from there!! Sorry....<bg>

Mike Rogers
 
Top