You can select the columns to hide and press Ctrl-0 (that's a zero)
You can unhide by selecting the 2 columns that flank the hidden columns and
pressing Ctrl-Shift-0 (also a zero)
Alternatively, if it's always the same columns you want to hide, you can
select the columns and then use Data-Group and Outline to group them.
You'll see a new bad above your column headers with a button labeled with a
minus sign. Clicking the button will hide the columns & change the button to
a plus sign. Click it again and the columns are displayed
"Grd" wrote:
Hi,
Is there a way to hide and unhide columns easily without using the menus. I
have a large spreadsheet and I would like to navigate it more easily.
Any help appreciated
Thanks
G
|