| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hide show question | New Users to Excel | |||
| Want to Hide columns in spreadsheet but NOT hide data in chart. | Charts and Charting in Excel | |||
| Another Hide Columns Question | Excel Discussion (Misc queries) | |||
| Hide/Unhide columns using button on top over relevant columns | Excel Discussion (Misc queries) | |||
| Hide Rows / Columns - complex question | Excel Worksheet Functions | |||
Linear Mode
