G Guest Nov 12, 2003 #1 Can I hide A B C D column names and 1 2 3 4 rows so I can only see my workspace
D davidbrowne17 Nov 12, 2003 #2 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
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 Nov 12, 2003 #3 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 Click to expand... workspace
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 Click to expand... workspace
T Ture Magnusson Nov 12, 2003 #4 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 Click to expand... workspace
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 Click to expand... workspace
S Stephen Bye Nov 12, 2003 #5 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 Click to expand... workspace
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 Click to expand... workspace
