Sat 06 Jun 2015

Tips & Tricks 94 - Select Big Range Very Easily

By |Saturday, June 06th, 2015|Categories: Tips and Tricks|Tags: , , , , , |0 Comments

You have a need to select A1 to A10. This is a very easy job to do. Suppose, you need to select A1 to A10000. Now, it becomes more cumbersome. Suppose you need to select E23 to AB4325. It is all the more cumbersome job for you.

Approach 1 - Put the range in Name Box and Press Enter

1

Approach 2

1. Press F5 (or CTRL+G)
2. Specify the range in Reference:
3. OK and you range is selected.

11

Sat 26 Jul 2014

Tips & Tricks 35 - Highlight Cells which are different from first Column Cells in a Range (And for Row Cells also)

By |Saturday, July 26th, 2014|Categories: Tips and Tricks|Tags: , , , |0 Comments

Let's say you are having data as given below and you want to highlight all the cells in columns after first column where cell values are different.

Confused???

B1 is not different from A1 where C1 is different from A1, hence C1 will be highlighted.
In row 2 both B2 and C2 will highlighted and so on.

1

Approach

1. Select the required range. In above case, select A1:C8.

2. ALT+EGSW and Enter (ALT+EGS opens Go to Special and W selects "Row Difference")

And you will have your results.

1

ALT+EGS to disply

Note - For ROW CELLS, select Column Difference i.e. ALT+EGSM and you get following results (I have changed data set to illustrate the concept. Here comparison is done with first row for following rows -

1