SOLVED
Home

Custom View on Excel Document

%3CLINGO-SUB%20id%3D%22lingo-sub-357331%22%20slang%3D%22en-US%22%3ECustom%20View%20on%20Excel%20Document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-357331%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20set%20up%20an%20excel%20document%20so%20it%20only%20shows%20the%20columns%20that%20have%20information%20in%20it%3F%26nbsp%3B%20Please%20see%20the%20attached%20screen%20shot.%26nbsp%3B%20I%20only%20want%20it%20to%20show%20the%20one%20page%2C%20not%20the%20other%20pages%20beside%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-357331%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-357916%22%20slang%3D%22en-US%22%3ERe%3A%20Custom%20View%20on%20Excel%20Document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-357916%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20Wyn%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20worked.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%20I%20am%20on%20a%20Mac.%20The%20commands%20you%20gave%20is%20what%20the%20Microsoft%26nbsp%3Bhelp%20gave%20too%2C%20but%20I%20think%20it%20must%20be%20wrong%20for%20the%20mac.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-357912%22%20slang%3D%22en-US%22%3ERe%3A%20Custom%20View%20on%20Excel%20Document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-357912%22%20slang%3D%22en-US%22%3EAh%2C%20are%20you%20on%20a%20Mac%3F%3CBR%20%2F%3E%3CBR%20%2F%3EI'm%20not%20sure%20what%20the%20keyboard%20short%20cut%20is%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20you%20go%20to%20the%20name%20box%20(just%20above%20column%20A)%20and%20type%20J%20%3A%20XFD%20it%20should%20highlight%20them%20all%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-357909%22%20slang%3D%22en-US%22%3ERe%3A%20Custom%20View%20on%20Excel%20Document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-357909%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Wyn%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20suggestion.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20what%20you%20suggested%20and%20it%20only%20selects%20the%20next%20column%20as%20opposed%20to%20all%20the%20columns%20to%20the%20right.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-357475%22%20slang%3D%22en-US%22%3ERe%3A%20Custom%20View%20on%20Excel%20Document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-357475%22%20slang%3D%22en-US%22%3EHi%20Eva%3CBR%20%2F%3E%3CBR%20%2F%3EI'm%20not%20sure%20if%20you%20read%20the%20question%20or%20looked%20at%20the%20screenshot%20but%20I%20don't%20quite%20see%20how%20your%20suggestion%20fits%20%3F%20Could%20you%20expand%20a%20bit%20on%20your%20thinking%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-357474%22%20slang%3D%22en-US%22%3ERe%3A%20Custom%20View%20on%20Excel%20Document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-357474%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F291846%22%20target%3D%22_blank%22%3E%40Aussiejt%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFirstly%20make%20sure%20you%20have%20clicked%20the%20icon%20in%20the%20bottom%20right%20to%20get%20the%20correct%20view%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20200px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F84533iB0992F91121DA9C5%2Fimage-size%2Fsmall%3Fv%3D1.0%26amp%3Bpx%3D200%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThen%20you%20can%20Click%20the%20first%20column%20you%20want%20to%20hide%20and%20hold%20down%20Ctrl%20and%20Shift%20and%20press%20the%20Right%20Arrow%20key%20-%20this%20will%20highlight%20all%20columns%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERight%20click%20on%20one%20of%20the%20column%20letters%20and%20choose%20Hide%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-357464%22%20slang%3D%22en-US%22%3ERe%3A%20Custom%20View%20on%20Excel%20Document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-357464%22%20slang%3D%22en-US%22%3EHi!%20If%20you%20have%20OneDrive%2C%20try%20it%20with%20ms%20Forms%20and%20with%20your%20excel%20List%20Source%20which%20collects%20relevant%20information.%20So%20you%20could%20create%20different%20forms%20with%20ms%20forms%20to%20different%20Szenarios.%20Greets%2C%20Eva%3C%2FLINGO-BODY%3E
Aussiejt
Occasional Contributor

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.

6 Replies
Hi! If you have OneDrive, try it with ms Forms and with your excel List Source which collects relevant information. So you could create different forms with ms forms to different Szenarios. Greets, Eva

Hi @Aussiejt 

 

Firstly make sure you have clicked the icon in the bottom right to get the correct view

 

image.png

 

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

 

Hi Eva

I'm not sure if you read the question or looked at the screenshot but I don't quite see how your suggestion fits ? Could you expand a bit on your thinking?

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.

Solution
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

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies