Forum Discussion

Aussiejt's avatar
Aussiejt
Copper Contributor
Feb 26, 2019
Solved

Custom View on Excel Document

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.
Excel on Mac
  • Wyn Hopkins's avatar
    Wyn Hopkins
    Feb 27, 2019
    Ah, are you on a Mac?

    I'm not sure what the keyboard short cut is

    If you go to the name box (just above column A) and type J : XFD it should highlight them all
Aussiejt's avatar
Aussiejt
Copper Contributor
Feb 27, 2019

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.

Wyn Hopkins's avatar
Wyn Hopkins
MVP
Feb 27, 2019
Ah, are you on a Mac?

I'm not sure what the keyboard short cut is

If you go to the name box (just above column A) and type J : XFD it should highlight them all
  • Aussiejt's avatar
    Aussiejt
    Copper Contributor
    Feb 27, 2019

    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.