Feb 26 2019 04:59 PM
How do I set up an excel document so it only shows the columns that have information in it? Please see the attached screen shot. I only want it to show the one page, not the other pages beside it.
Feb 27 2019 12:37 AM
Feb 27 2019 12:52 AM
Hi @Aussiejt
Firstly make sure you have clicked the icon in the bottom right to get the correct view
Then you can Click the first column you want to hide and hold down Ctrl and Shift and press the Right Arrow key - this will highlight all columns
Right click on one of the column letters and choose Hide
Feb 27 2019 12:53 AM
Feb 27 2019 02:18 PM
Hi Wyn
Thanks for your suggestion.
I tried what you suggested and it only selects the next column as opposed to all the columns to the right.
Feb 27 2019 02:24 PM
SolutionFeb 27 2019 02:31 PM
Thanks Wyn
That worked.
Yes I am on a Mac. The commands you gave is what the Microsoft help gave too, but I think it must be wrong for the mac.
Feb 27 2019 02:24 PM
Solution