Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Expand and Shrink Rows and columns to hide information.
I have a spreadsheet with rows 1 & 2 and columns numbered 1 & 2. In column 1
I have the ability to click a plus sign (+) to expand information in hidden rows. Along the top I also have the ability to click a plus (+) sign in column 1 to expand hidden columns. It appears that column 2 denotes those rows to be hidden by a "." Ok how do I set this up? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Expand and Shrink Rows and columns to hide information.
DataGroup and Outline
Gord Dibben MS Excel MVP On Tue, 5 Jan 2010 07:29:02 -0800, jf1847 wrote: I have a spreadsheet with rows 1 & 2 and columns numbered 1 & 2. In column 1 I have the ability to click a plus sign (+) to expand information in hidden rows. Along the top I also have the ability to click a plus (+) sign in column 1 to expand hidden columns. It appears that column 2 denotes those rows to be hidden by a "." Ok how do I set this up? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Expand and Shrink Rows and columns to hide information.
On Wednesday, January 6, 2010 5:09:55 AM UTC+11, Gord Dibben wrote:
DataGroup and Outline Gord Dibben MS Excel MVP On Tue, 5 Jan 2010 07:29:02 -0800, jf1847 wrote: I have a spreadsheet with rows 1 & 2 and columns numbered 1 & 2. In column 1 I have the ability to click a plus sign (+) to expand information in hidden rows. Along the top I also have the ability to click a plus (+) sign in column 1 to expand hidden columns. It appears that column 2 denotes those rows to be hidden by a "." Ok how do I set this up? Hi Can you tell me if this is possioble in Gogole Spreadsheets? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I expand & shrink columns? | Excel Discussion (Misc queries) | |||
Header Row with Option to Shrink/Expand Rows Beneath | Excel Worksheet Functions | |||
How do I add the + and - signs to hide and expand rows/columns? | Excel Discussion (Misc queries) | |||
Is there a way to hide worksheets and/or rows/columns based on information enter into a particular cell of range of cells? | New Users to Excel | |||
Shrink and expand a number of columns/rows | Excel Worksheet Functions |