|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 5th 10, 03:29 PM
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? 
|
| Ads |
|
#2
January 5th 10, 06:09 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Expand and Shrink Rows and columns to hide information.
Data>Group 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
July 2nd 12, 01:48 AM
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:
> Data>Group 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?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Can I expand & shrink columns? | youngsequan | Excel Discussion (Misc queries) | 1 | December 4th 09 11:44 PM |
| Header Row with Option to Shrink/Expand Rows Beneath | kippers | Excel Worksheet Functions | 2 | June 22nd 09 12:50 PM |
| How do I add the + and - signs to hide and expand rows/columns? | Elsa | Excel Discussion (Misc queries) | 2 | November 8th 06 10:07 PM |
| Is there a way to hide worksheets and/or rows/columns based on information enter into a particular cell of range of cells? | Marc | New Users to Excel | 1 | March 10th 06 05:10 PM |
| Shrink and expand a number of columns/rows | balles | Excel Worksheet Functions | 1 | February 17th 06 04:31 PM |
Linear Mode
