ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Add tab with ID to hidden columns in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/92235-add-tab-id-hidden-columns-excel.html)

Buddha_PE

Add tab with ID to hidden columns in Excel
 
When you hide fields, it would be functional to add a tab to identify those
hidden columns. For instance, you could hide and expand "Employee
Information" contained in several columns while working mostly with other
employee data on a daily basis.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Ron Coderre

Add tab with ID to hidden columns in Excel
 
Check Excel Help for "outlining"

I think that covers your suggestion.

***********
Regards,
Ron

XL2002, WinXP


"Buddha_PE" wrote:

When you hide fields, it would be functional to add a tab to identify those
hidden columns. For instance, you could hide and expand "Employee
Information" contained in several columns while working mostly with other
employee data on a daily basis.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc


Dave Peterson

Add tab with ID to hidden columns in Excel
 
You may want to look at selecting columns and then using Data|Group.

You might get close to the effect that you want.

Buddha_PE wrote:

When you hide fields, it would be functional to add a tab to identify those
hidden columns. For instance, you could hide and expand "Employee
Information" contained in several columns while working mostly with other
employee data on a daily basis.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc


--

Dave Peterson

Jim Rech

Add tab with ID to hidden columns in Excel
 
One of the reason MS has given for revamping Excel's UI in Excel 2007 is
that most of the feature users request are already in the product.

--
Jim
"Buddha_PE" wrote in message
...
| When you hide fields, it would be functional to add a tab to identify
those
| hidden columns. For instance, you could hide and expand "Employee
| Information" contained in several columns while working mostly with other
| employee data on a daily basis.
|
| ----------------
| This post is a suggestion for Microsoft, and Microsoft responds to the
| suggestions with the most votes. To vote for this suggestion, click the "I
| Agree" button in the message pane. If you do not see the button, follow
this
| link to open the suggestion in the Microsoft Web-based Newsreader and then
| click "I Agree" in the message pane.
|
|
http://www.microsoft.com/office/comm...lic.excel.misc




All times are GMT +1. The time now is 02:44 PM.

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