Check the corners of your data set

Ctrl + A and Ctrl + * are common ways to select the data.

The key difference in using Ctrl+A and Ctrl+ * is that in Ctrl+A you are thrown to the last corner of the dataset where as in Ctrl+ * you stay where you are.

I have found that in-spite of this arrogance of Ctrl+A, it is more widely used, probably because of the proximity of keys.

Suppose on huge database you use Ctrl+A and want to come back to original cell, Ctrl+[.] (Ctrl plus period) shortcut comes to your rescue. pressing it repeatedly takes you to the corners of the selected data. It helps you make sure that all the data is selected. Very nifty shortcut, I use it often.



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s