I have a workbook with 100 columns, names and numbers. Problem is, only so many are active at any one time. Is there a way that only the active columns are shown or failing that, are moved to the left to form an active block?
I understand I could "hide" the unused colums but that is a long and laborious task unless somebody knows a quicker way to do it.
Much obliged.
Bookmarks