Forum Discussion

Lorenzo Kim's avatar
Lorenzo Kim
Bronze Contributor
Jul 12, 2018

hide the leftmost column after DATA>subtotal

Hello... can the leftmost column ([1][2][3]) after DATA>subtotal be hidden? many thanks      
excel
Macros and VBA
Lorenzo Kim's avatar
Lorenzo Kim
Bronze Contributor
Jul 12, 2018

Hi everyone,

I found the solution to hide the leftmost column after subtotal, IT IS:  CTRL + 8   

hope someone out there needs this too...

many thanks

 

Lorenzo Kim's avatar
Lorenzo Kim
Bronze Contributor
Jul 13, 2018
BTW..
the vba for this is:
ActiveWindow.DisplayOutline = False

Resources