Comparing List

Sharing a quick tip on comparing list. Select two list and press Ctrl+fore slash (usually above enter button).

2018-03-15_1157

It highlights the row difference i.e. whenever there are differences in text/numbers in two lists will be highlighted. Similarly column diference can be highlighted with Ctrl + Shift + fore slash

2018-03-15_1205

Advertisements

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.

period1