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

3 Replies

  • 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