Is there a quick way to show selected columns (not using hide)

[Anhlyss]

I am trying to schedule Teacher conferences at our school. I have each
teacher in a column and need to show only the columns that I am scheduling
for each family. I don't want to use the "Hide" command, because I would
have to hide more columns than I need to see (there are 16 teachers, and I
would need to show 2 to 5 at a time). Is there a way to select the columns I
want to see, and show only them? I guess this would be the opposite of "Hide"

 

[מיכ×ל (מיקי) ×בידן]

To my opinion the quickest way will be with VBA Code.
* The first Macro will hide ALL the worksheet columns EXCEPT those you have
selected.
* You may select several - even non adjacent columns - by holding the CTRL
key
pressed while clicking on the column(s) name.
* The second Macro Un-Hide ALL columns.
------------------------------------------------------
Sub Hide_All_Columns_Except_Selected()
Cells.EntireColumn.Hidden = True
Selection.EntireColumn.Hidden = False
[A1].Select
End Sub

 

[Gord Dibben]

To not see columns you MUST hide them.

To see hidden columns you MUST unhide them.

You could use use Custom Views to create multiple Views that you could
toggle through.


Gord Dibben MS Excel MVP

 

[anhlyss]

Thanks. I will try this when I get back to work on Monday and let you know
if it works.

To my opinion the quickest way will be with VBA Code.
* The first Macro will hide ALL the worksheet columns EXCEPT those you have
selected.
* You may select several - even non adjacent columns - by holding the CTRL
key
pressed while clicking on the column(s) name.
* The second Macro Un-Hide ALL columns.
------------------------------------------------------
Sub Hide_All_Columns_Except_Selected()
Cells.EntireColumn.Hidden = True
Selection.EntireColumn.Hidden = False
[A1].Select
End Sub
-----------------------
Sub Unhide_all_Columns()
Cells.EntireColumn.Hidden = False
End Sub
-----------------------
Micky

I am trying to schedule Teacher conferences at our school. I have each
teacher in a column and need to show only the columns that I am scheduling
for each family. I don't want to use the "Hide" command, because I would
have to hide more columns than I need to see (there are 16 teachers, and I
would need to show 2 to 5 at a time). Is there a way to select the columns I
want to see, and show only them? I guess this would be the opposite of "Hide"

 

[Anhlyss]

Tried it this morning - works great! Exactly what I was looking for. You
have saved me hours of work!

To my opinion the quickest way will be with VBA Code.
* The first Macro will hide ALL the worksheet columns EXCEPT those you have
selected.
* You may select several - even non adjacent columns - by holding the CTRL
key
pressed while clicking on the column(s) name.
* The second Macro Un-Hide ALL columns.
------------------------------------------------------
Sub Hide_All_Columns_Except_Selected()
Cells.EntireColumn.Hidden = True
Selection.EntireColumn.Hidden = False
[A1].Select
End Sub
-----------------------
Sub Unhide_all_Columns()
Cells.EntireColumn.Hidden = False
End Sub
-----------------------
Micky

I am trying to schedule Teacher conferences at our school. I have each
teacher in a column and need to show only the columns that I am scheduling
for each family. I don't want to use the "Hide" command, because I would
have to hide more columns than I need to see (there are 16 teachers, and I
would need to show 2 to 5 at a time). Is there a way to select the columns I
want to see, and show only them? I guess this would be the opposite of "Hide"