Easy! How scroll down to end of big sheet

D

dewsbury

Hi,
I really should know this but...

Say I have a sheet with 10,000 rows. I want to copy a formula from B2
to B10,000. How do I do this without having to scroll thru' 10,000
rows. I know there is a quicker way. i.e. I want to copy to each
row in one (or two!) key strokes.

All help appreciated.
 
R

Ron de Bruin

Hi

If you have Data in A1:A10000 then double click on the right down corner of the formula cell B2

If there is no data in A then
Copy B2 (ctrl-C)
F5
Enter B3:B10000
OK
Ctrl-V
 
D

David McRitchie

If you do not have contiguous data all the way, you can go to the bottom
and then go up to where your data is, see macros and the toolbar buttons
I created to go with them. That one would be the button with the down arrow.
Macros, some of the short macros used with Toolbar buttons on this page (#macros)
http://www.mvps.org/dmcritchie/excel/toolbars.htm#macros
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Ron de Bruin said:
Hi

If you have Data in A1:A10000 then double click on the right down corner of the formula cell B2

If there is no data in A then
Copy B2 (ctrl-C)
F5
Enter B3:B10000
OK
Ctrl-V
Click to expand...
 
Top