AutoFill & Row Selection in Excel

July 26, 2010 at 09:19:25
Specs: Windows XP, 512
Dear friends i am having two msexcel files as below in column A and Column B:

file 1
12
45
56
36
58
98
....... (like this in 5500 rows)
File 2
98
58
36
55
88
99
77
33
21
46
39
......... (Like this in 62000 rows)

Iam using the formula
=ISNUMBER(MATCH(A1,C:C,0))
But my problem is i want to write this formula in row B1 and i have to drag the same to all 62000 rows , which is very difficult.
Now pl tell me how i have to write the same formula in single stroke without dragging technique.

PL also tell me
1. How to select row1 to row 5000 in single stroke, without dragging, ( in a file of 15000 rows)
2. HOw to select row 251 to 1000 without dragging technique, but with single command.

Pl guide me

Rao



See More: AutoFill & Row Selection in Excel

Report •


#1
July 26, 2010 at 10:28:42
To quickly autofill the formula into B1:B62000, try this:

1 - Press the F5 key.

2 - Enter B1:B62000

3 - Press Enter

4 - Input =ISNUMBER(MATCH(A1,C:C,0)) into B1

5 - Press Ctrl-Enter


To quickly select a large number of rows:

1 - Press F5

2 - Enter 251:500

3 - Press Enter


Report •
Related Solutions


Ask Question