Home

Excel - Shift End and down arrow key

%3CLINGO-SUB%20id%3D%22lingo-sub-1012420%22%20slang%3D%22en-US%22%3EExcel%20-%20Shift%20End%20and%20down%20arrow%20key%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1012420%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20in%20the%20situation%2C%20that%20when%20i%20choose%20all%20of%20my%20cells%20in%20a%20column%26nbsp%3B%20THEN%20if%20i%20want%20to%20go%20to%20the%20end%20by%20pressing%20arrow%20down%2C%20then%20usually%20I%20coming%20down%20to%20the%20first%20empty%20row.%20now%20how%20ever%20I'm%20only%20being%20send%20one%20step%20down%20from%20my%20stating%20point%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehow%20should%20i%20solve%20this%2C%20i%20am%20working%20on%20a%20mac%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1012420%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1012889%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Shift%20End%20and%20down%20arrow%20key%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1012889%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F459218%22%20target%3D%22_blank%22%3E%40JCPHedin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22cmd%22%20%2B%20%22arrow%20down%22%20does%20the%20trick.%20You%20don't%20need%20to%20select%20all%20cells%20in%20a%20column.%20Just%20select%20any%20cell%20in%20the%20relevant%20column%20and%20it%20will%20jump%20to%20the%20last%20cell%20before%20or%20after%20an%20empty%20cell.%20%22cmd%22%20%2B%20%22arrow%20up%22%20will%20jump%20upwards.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHolding%20Shift%20while%20pressing%20these%20keys%20will%20expand%20your%20selection%20(i.e.%20not%20just%20jump%20to%20next%20cell).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1013015%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Shift%20End%20and%20down%20arrow%20key%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1013015%22%20slang%3D%22en-US%22%3EAlso%20Ctrl%20and%20.%20(period)%20will%20toggle%20between%20the%20top%20and%20bottom%20of%20a%20selected%20column%20or%20between%20the%204%20corners%20of%20a%20highlighted%20range%3C%2FLINGO-BODY%3E
Highlighted
JCPHedin
Occasional Visitor

I'm in the situation, that when i choose all of my cells in a column  THEN if i want to go to the end by pressing arrow down, then usually I coming down to the first empty row. now how ever I'm only being send one step down from my stating point?

 

how should i solve this, i am working on a mac 

2 Replies

@JCPHedin 

"cmd" + "arrow down" does the trick. You don't need to select all cells in a column. Just select any cell in the relevant column and it will jump to the last cell before or after an empty cell. "cmd" + "arrow up" will jump upwards.

 

Holding Shift while pressing these keys will expand your selection (i.e. not just jump to next cell).

Also Ctrl and . (period) will toggle between the top and bottom of a selected column or between the 4 corners of a highlighted range
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies