Hiding columns in 'Numbers'

[flyboyy]

When I was using MS Excel, you could hide columns by dragging over other columns.

I can't remember exactly how I did it, but it was very handy and quick.

Where I used it was when I set up my bank accounts. I didn't need to see the old months, so I somehow covered them so that I could see the top of the column with the titles and could drag the current columns to cover over what was old stuff. The data would still be there but just hidden. However I could easily reveal whatever old data I wanted by dragging the separator back to reveal it.

Is there a way to do this in numbers?

 

[lclev]

In Numbers select the column or columns you want to hide then hold down the control key and click. Scroll down the pop up menu and select hide column(s).

Lisa

 

[flyboyy]

Amazing!

Took a few tries till I figured out that it was the very top of the column that had to be selected (A B C D etc) and then right click worked to get the hide option.

My wife and I have been mystified on that one for quite awhile.
Appreciate it!

 

[Alwyn]

For anybody using OpenOffice or LibreOffice Calc the procedure is pretty much the same. I just keep banking as continuous as I never print but the hide facility is extremely useful for accounts, where you may want to do a calculation that doesn't form part of published accounts.