A B C D column names and 1 2 3 4

D

davidbrowne17

highlight the ROWS you wish to hide then click on DATA>GOUP AN
OUTLINE>GROUP

This will add a small - sign on the row heading, clicking this wil
then close or open the group.

this can be nested for a number of rows or collums as required.

( if you need to HIDE the same - use the same method but select HID
not GROUP AND OUTLINE)

Dav
 
T

Thomas L. Ickes

Goto Tools/Options. On the View tab, deselect Row & column headers.

That will show only your workspace.


Brendan said:
Can I hide A B C D column names and 1 2 3 4 rows so I can only see my
workspace
 
T

Ture Magnusson

Brendan,

1. Tools - Options
2. Select the "View" tab
3. Uncheck "Row & column headers"
4. Click "OK"

--
Ture Magnusson
Microsoft MVP - Excel
Karlstad, Sweden


Brendan said:
Can I hide A B C D column names and 1 2 3 4 rows so I can only see my
workspace
 
S

Stephen Bye

On the Tools menu, select Options...
Uncheck the 'Row and column headers' checkbox.

Brendan said:
Can I hide A B C D column names and 1 2 3 4 rows so I can only see my
workspace
 

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.

Ask a Question

Top