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?
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.
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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
