Excel - Shift End and down arrow key

Copper Contributor

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 

4 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

for the advise :) @Riny_van_Eekelen 

@Wyn Hopkins 

 

thanks for the advice :)