Zip and Hide arrow keys(+reverse)

  • Thread starter Thread starter Peter Mitchell
  • Start date Start date
P

Peter Mitchell

I have been working on a spreadsheet given to me that can
hide multiple columns and rows by clicking on an arrow key
located in the margins of the sheet.

How can I program this into other spreadsheets I develop
as this does not appear to be a function on standard Excel
2002?. Is there any add in functions offered by microsoft
that allows this function?.

Regards
Peter
 
Sounds like "Group and Outline" found in the Data menu.
Uses plus & minus signs, not arrows.

I generally just use Group & Ungroup via the standard buttons I hav
added to my toolbar. Just select entire Rows or Columns and click th
button (or use menu)
 
Select the rows or columns, click Data>Group and Outline>Group

It only works on contiguous ranges, though.



I have been working on a spreadsheet given to me that can
hide multiple columns and rows by clicking on an arrow key
located in the margins of the sheet.

How can I program this into other spreadsheets I develop
as this does not appear to be a function on standard Excel
2002?. Is there any add in functions offered by microsoft
that allows this function?.

Regards
Peter
Click to expand...

Mike Argy
Custom Office Solutions
and Windows/UNIX applications

Please post on-topic responses to the newsgroup

To e-mail me, remove nospam from the address in the headers
 
Back
Top