Keyboard Shortcut to Copy Down a Range

Graemea

Board Regular
Joined
Oct 30, 2015
Messages
65
Hi,


I have data in A2:A1000 and would like to put a formula in cell B2 and then copy it down from B3 to B1000.


I know that I can use the fill handle and mouse to copy it quickly to B3:B1000.


If I wanted to use the keyboard, is there a shortcut key sequence that I can use to select the range in B3:B1000 rather than using things like Shift+PgDn?


Thanks!
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

JackDanIce

Well-known Member
Joined
Feb 3, 2010
Messages
9,604
Office Version
365
Platform
Windows
If you select a vertical range, e.g. A1:A10 and A1 has a formula or value, press CTRL+D (Windows) and it will fill A2:A10 with same contents as A1

This may also help: http://tinyurl.com/y2py4akr
 

Watch MrExcel Video

Forum statistics

Threads
1,095,479
Messages
5,444,732
Members
405,298
Latest member
fxtrtr17

This Week's Hot Topics

Top