Auto hide/Unhide columns
Several years ago I worked on a spreadsheet that had hidden columns. These
columns could be hid or unhid by clicking on something near the column header. This was very nice for very wide spreadsheets that had particular sections that one wanted to view. It was like being able to fold and unfold the sheet to view just specific parts of the sheet, but I didn't have to go to 'tools' 'hide', and it was very visually clear where the hidden areas were. I've never seen this function on anther spreadsheet, and I've never managed to find anything in help that describes what I saw. Anybody have any idea what I am talking about? |
Auto hide/Unhide columns
Hi
Try marking the range of columns you want to group, then Alt+Shift+right arrow. You will then see a - sign above the column headers. Click it and the columns will be hidden, and the sign will change to a + Alt+Shift+left arrow will ungroup them. -- Regards Roger Govier "Vespaguy" wrote in message ... Several years ago I worked on a spreadsheet that had hidden columns. These columns could be hid or unhid by clicking on something near the column header. This was very nice for very wide spreadsheets that had particular sections that one wanted to view. It was like being able to fold and unfold the sheet to view just specific parts of the sheet, but I didn't have to go to 'tools' 'hide', and it was very visually clear where the hidden areas were. I've never seen this function on anther spreadsheet, and I've never managed to find anything in help that describes what I saw. Anybody have any idea what I am talking about? |
Auto hide/Unhide columns
That seems very similar to what I remember. Functionally it seems the same,
although it seems like it looks different. What is this called? I'd like to read anything included in the help files about this. "Roger Govier" wrote: Hi Try marking the range of columns you want to group, then Alt+Shift+right arrow. You will then see a - sign above the column headers. Click it and the columns will be hidden, and the sign will change to a + Alt+Shift+left arrow will ungroup them. -- Regards Roger Govier "Vespaguy" wrote in message ... Several years ago I worked on a spreadsheet that had hidden columns. These columns could be hid or unhid by clicking on something near the column header. This was very nice for very wide spreadsheets that had particular sections that one wanted to view. It was like being able to fold and unfold the sheet to view just specific parts of the sheet, but I didn't have to go to 'tools' 'hide', and it was very visually clear where the hidden areas were. I've never seen this function on anther spreadsheet, and I've never managed to find anything in help that describes what I saw. Anybody have any idea what I am talking about? |
Auto hide/Unhide columns
Hi
You will find in on the menus under DataGroup and Outline In Help menu, just search for Group and Outline and you will see 4 topics listed. -- Regards Roger Govier "Vespaguy" wrote in message ... That seems very similar to what I remember. Functionally it seems the same, although it seems like it looks different. What is this called? I'd like to read anything included in the help files about this. "Roger Govier" wrote: Hi Try marking the range of columns you want to group, then Alt+Shift+right arrow. You will then see a - sign above the column headers. Click it and the columns will be hidden, and the sign will change to a + Alt+Shift+left arrow will ungroup them. -- Regards Roger Govier "Vespaguy" wrote in message ... Several years ago I worked on a spreadsheet that had hidden columns. These columns could be hid or unhid by clicking on something near the column header. This was very nice for very wide spreadsheets that had particular sections that one wanted to view. It was like being able to fold and unfold the sheet to view just specific parts of the sheet, but I didn't have to go to 'tools' 'hide', and it was very visually clear where the hidden areas were. I've never seen this function on anther spreadsheet, and I've never managed to find anything in help that describes what I saw. Anybody have any idea what I am talking about? |
Auto hide/Unhide columns
How do you hide and unhide spreadsheet in a workbook?
"Roger Govier" wrote: Hi Try marking the range of columns you want to group, then Alt+Shift+right arrow. You will then see a - sign above the column headers. Click it and the columns will be hidden, and the sign will change to a + Alt+Shift+left arrow will ungroup them. -- Regards Roger Govier "Vespaguy" wrote in message ... Several years ago I worked on a spreadsheet that had hidden columns. These columns could be hid or unhid by clicking on something near the column header. This was very nice for very wide spreadsheets that had particular sections that one wanted to view. It was like being able to fold and unfold the sheet to view just specific parts of the sheet, but I didn't have to go to 'tools' 'hide', and it was very visually clear where the hidden areas were. I've never seen this function on anther spreadsheet, and I've never managed to find anything in help that describes what I saw. Anybody have any idea what I am talking about? |
Auto hide/Unhide columns
How do you hide/unhide a worksheet in a workbook?
Select the sheet(s) to hide Format|sheet|Hide or format|sheet|unhide Hide and Unhide Spreadsheets in Workbook wrote: How do you hide and unhide spreadsheet in a workbook? "Roger Govier" wrote: Hi Try marking the range of columns you want to group, then Alt+Shift+right arrow. You will then see a - sign above the column headers. Click it and the columns will be hidden, and the sign will change to a + Alt+Shift+left arrow will ungroup them. -- Regards Roger Govier "Vespaguy" wrote in message ... Several years ago I worked on a spreadsheet that had hidden columns. These columns could be hid or unhid by clicking on something near the column header. This was very nice for very wide spreadsheets that had particular sections that one wanted to view. It was like being able to fold and unfold the sheet to view just specific parts of the sheet, but I didn't have to go to 'tools' 'hide', and it was very visually clear where the hidden areas were. I've never seen this function on anther spreadsheet, and I've never managed to find anything in help that describes what I saw. Anybody have any idea what I am talking about? -- Dave Peterson |
All times are GMT +1. The time now is 01:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com