+ on top of columns & next to rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that has + on top of the columns and next to the rows.
when you click on the + it hides or unhides the row/columns. there are also
numbers at the very top left hand corner that when clicked on hides or
unhided all of the corresponding rows/columns. I would like to do this to
other spreadsheets. Can someone please let me know how this is done? Thanks
in advance.
 
Look up "Outline" in the HELP files.

It's the same format as when you use subtotals.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have a spreadsheet that has + on top of the columns and next to the rows.
when you click on the + it hides or unhides the row/columns. there are also
numbers at the very top left hand corner that when clicked on hides or
unhided all of the corresponding rows/columns. I would like to do this to
other spreadsheets. Can someone please let me know how this is done?
Thanks
in advance.
 
It is called Outline.

You can access it from Data>Group and Outline menu.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Similar Threads

Cannot unhide the hidden rows in my spreadsheet 3
Displaying column and row names 3
Excel 2007 - Hide & Unhide Columns/Rows 8
One-click hiding/unhiding of many non-adjacent columns/rows? 4
Hide columns but not the top rows 8
Freeze multiple rows/columns in Excel 2007 11
Unhide columns and rows 2
hide, unhide column or row after protect worksheet 4

Back
Top