SOLVED
Home

Excel Worksheets and templates

%3CLINGO-SUB%20id%3D%22lingo-sub-1200896%22%20slang%3D%22en-US%22%3EExcel%20Worksheets%20and%20templates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1200896%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20hide%20or%20delete%20or%20remove%20the%20columns%20to%20the%20right%20of%20those%20I%3CFONT%3E'%3C%2FFONT%3Em%20working%20in%20on%20an%20Excel%20worksheet%20or%20template%20(the%20colums%20that%20are%20not%20part%20of%20my%20worksheet)%3F%26nbsp%3B%20All%20of%20that%20extra%20white%20space%20is%20driving%20my%20eyeballs%20nuts%2C%20but%20having%20to%20resize%20the%20window%20every%20time%20I%20open%20it%20is%20not%20time%20effective%20(seconds%20add%20up%20when%20you're%20paid%20on%20production%2C%20rather%20than%20hourly).%26nbsp%3B%20Thanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1200896%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1200910%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Worksheets%20and%20templates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1200910%22%20slang%3D%22en-US%22%3EYou%20can%20highlight%20all%20the%20first%20column%20you%20don't%20want%20to%20see%20and%20press%20Ctrl%20right%20arrow%20to%20select%20the%20rest%2C%20then%20right%20click%20hide.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1200939%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Worksheets%20and%20templates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1200939%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F544433%22%20target%3D%22_blank%22%3E%40Savia%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F564175%22%20target%3D%22_blank%22%3E%40Christine_R%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20would%20be%20Ctrl%20%2B%26nbsp%3B%3CSTRONG%3EShift%3C%2FSTRONG%3E%20%2B%20Right%20Arrow%20for%20columns%20to%20right%20or%26nbsp%3BCtrl%20%2B%26nbsp%3B%3CSTRONG%3EShift%3C%2FSTRONG%3E%20%2B%20Down%20Arrow%26nbsp%3Bfor%20rows%20below%20working%20space.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1200971%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Worksheets%20and%20templates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1200971%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3BOoops%2C%20of%20course%20you%20are%20correct.%26nbsp%3B%20It's%20funny%2C%20you%20get%20so%20used%20to%20typing%20things%20sometimes%20you%20don't%20even%20think%20about%20what%20you're%20typing.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1201000%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Worksheets%20and%20templates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1201000%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F544433%22%20target%3D%22_blank%22%3E%40Savia%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHappens%20more%20than%20I'd%20like%20to%20admit!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1201081%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Worksheets%20and%20templates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1201081%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%20folks!%26nbsp%3B%20I%20had%20actually%20started%20out%20doing%20the%20CTRL%20%2B%20the%20right%20arrow%2C%20and%20I%20was%20losing%20patience%20-%20thus%2C%20my%20question%20out%20here%2C%20LOL!%26nbsp%3B%20I%20appreciate%20the%20input%20from%20both%20of%20you%20(so%20do%20my%20eyeballs!)%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20again%20and%20have%20a%20fantastic%20day!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1201103%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Worksheets%20and%20templates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1201103%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F564175%22%20target%3D%22_blank%22%3E%40Christine_R%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGlad%20to%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Is there a way to hide or delete or remove the columns to the right of those I'm working in on an Excel worksheet or template (the colums that are not part of my worksheet)?  All of that extra white space is driving my eyeballs nuts, but having to resize the window every time I open it is not time effective (seconds add up when you're paid on production, rather than hourly).  Thanks in advance!

6 Replies
Highlighted
You can highlight all the first column you don't want to see and press Ctrl right arrow to select the rest, then right click hide.
Highlighted
Solution

@Savia @Christine_R 

 

That would be Ctrl + Shift + Right Arrow for columns to right or Ctrl + Shift + Down Arrow for rows below working space.

Highlighted

@PReagan Ooops, of course you are correct.  It's funny, you get so used to typing things sometimes you don't even think about what you're typing.

Highlighted

@Savia 

 

Happens more than I'd like to admit!

Highlighted

@PReagan 

 

Thanks, folks!  I had actually started out doing the CTRL + the right arrow, and I was losing patience - thus, my question out here, LOL!  I appreciate the input from both of you (so do my eyeballs!)  

 

Thanks again and have a fantastic day!

Highlighted

@Christine_R 

 

Glad to help!

Related Conversations
Openen en opslaan WORD en EXCEL
Turke100 in Excel on
0 Replies
historical stock data
onassis78 in Excel on
0 Replies
Excel cell formatting
snojoe10 in Excel on
1 Replies
Corrector automático
jorgf2047 in Excel on
0 Replies
Problem when opening Excel
LarryC1940 in Excel on
0 Replies