ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Expand and Shrink Rows and columns to hide information. (https://www.excelbanter.com/excel-discussion-misc-queries/252445-expand-shrink-rows-columns-hide-information.html)

jf1847

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?

Gord Dibben

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?



[email protected]

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?


All times are GMT +1. The time now is 12:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com