Hiding columns in Excel for Mac

[johnnymackey]

Hi...
I am having trouble hiding a single column when this column includes a
merged couple of cells in a row.

Basicially, I am running an expense report where one column is the
"budget" column and the column immediately next to it is the "actual"
expense column. One row is merged to show that both columns are
representative of a single month for example "April" is merged across
column E and F.

How do I hide the "budget" column and not the actual column while
keeping "April the text headlining either both columns or one column
depending on whether on is hidden?

Thanks

 

[PhilD]

How do I hide the "budget" column and not the actual column while
keeping "April the text headlining either both columns or one column
depending on whether on is hidden?

*Don't* highlight the appropriate column. Click and drag the right
hand edge of the column header [1] as far left as it will go.

[1] If it's column E, say, then I'm refering to the A B C D *E* F G...
at the top of the sheet.

Does this help?

PhilD

 

[JE McGimpsey]

Basicially, I am running an expense report where one column is the
"budget" column and the column immediately next to it is the "actual"
expense column. One row is merged to show that both columns are
representative of a single month for example "April" is merged across
column E and F.

How do I hide the "budget" column and not the actual column while
keeping "April the text headlining either both columns or one column
depending on whether on is hidden?

First, you're seeing one reason that merged cells are the spawn of the
devil and should never be used. There are many others...

Instead, put "April" in E1, select E1:F1, and choose
Format/Cells/Alignment. Choose "Center Across Selection" from the
Horizontal dropdown. (I use this frequently, so I've added a button to a
custom toolbar attached to this macro:

Public Sub CenterAcrossSelection()
On Error Resume Next
Selection.HorizontalAlignment = xlCenterAcrossSelection
On Error GoTo 0
End Sub

However, in your case, that won't solve the problem either. Instead of
Hiding the column, you can use Format/Column/Width, and set it to
something very small, like "0.01".

You can record a macro to make it easier to switch.