Question: Hide Columns - not the ususal way
 

I just received an Excel file from a client and it has two small boxes in the very top right hand corner of the spreadsheet (above row 1 and to the left of column A). When I click on one of the arrows, it either hides or unhides columns in the spreadsheet. How can I do this with other spreadsheets? I am family with how to hide and unhide rows/columns using the Format menu, but I am intrigued by this new approach.

thanks in advance for your help

EggHeadCafe - Software Developer Portal of Choice
..NET Generics - Sorting List By Class Properties
http://www.eggheadcafe.com/tutorials...sorting-l.aspx

Question: Hide Columns - not the ususal way
 

Hi
Select the range you want to hide then goto DataGroup and Outline Group
HTH
John

"p s" wrote in message ...
I just received an Excel file from a client and it has two small boxes in the
very top right hand corner of the spreadsheet (above row 1 and to the left of
column A). When I click on one of the arrows, it either hides or unhides
columns in the spreadsheet. How can I do this with other spreadsheets? I am
family with how to hide and unhide rows/columns using the Format menu, but I am
intrigued by this new approach.

thanks in advance for your help

EggHeadCafe - Software Developer Portal of Choice
.NET Generics - Sorting List By Class Properties
http://www.eggheadcafe.com/tutorials...sorting-l.aspx

Columns
 

Excellent! Thank you



John wrote:

HiSelect the range you want to hide then goto DataGroup and Outline
21-Oct-09

Hi
Select the range you want to hide then goto DataGroup and Outline Group
HTH
John

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
Design Pattern Interview Questions Part 3
http://www.eggheadcafe.com/tutorials...interview.aspx

Columns
 

You're welcome,
ps.. You can also group rows. Press F1 (Help) and type 'Group and Outline'
check Outline also.
Regards
John
"p s" wrote in message ...
Excellent! Thank you



John wrote:

HiSelect the range you want to hide then goto DataGroup and Outline
21-Oct-09

Hi
Select the range you want to hide then goto DataGroup and Outline Group
HTH
John

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
Design Pattern Interview Questions Part 3
http://www.eggheadcafe.com/tutorials...interview.aspx