Excel Neat Trick – Selecting All The Data In A Table

October 27, 2013 Billy Aung Myint No comments

Perhaps you might know this already , or perhaps not. I don’t care

Lets say you have a table ,

billy 10
mary 22
john 36
cleo 54
alice 82
james 16
gary 17

And you want to select them , you could just use your mouse , but what if the data is so big that you need to scroll down? Here is a neat trick

Press CTRL + SHIFT + RIGHT ARROW

Followed by

Press CTRL + SHIFT + DOWN ARROW

DONE! Neat Heh?

Billy

 

Comments are closed.