i have 2000 cell from e1 until e4000

[mgm90210M]

i have 2000 cell from e1 until e4000
and i want to highlight all of Tham

i take me a lot of time to scroll down to highlight all of tham

do you have another idea


like to highlight e1 and than jump to e4000 and the scroll will do automatic

 

[Andrew Poulsom]

Did you try selecting E1 the pressing Shift+End+Down Arrow?

 

[mgm90210M]

ok
thanks it work


can i apply a formula to another cell in this method ?

what i do now i scroll down 300 cell to apply all Tham the function
and it take me a awile

 

[mgm90210M]

i mean for row

and i have a excel mac

but advise in excel windows will be good too


thanks