Very basic query

K

KiwiBrian

After entering a formula into a cell, say b2, how do I tell excel to copy
the formula right down to b3005?

TIA
Brian Tozer
 
P

Peo Sjoblom

Select B2 again, press F5, type in B3005, hold down shift key and press enter,
press ctrl + d


Regards,

Peo Sjoblom
 
M

Michael

OR
If there is data in all of the associated cells to the formula, just double
click on the little black square in the bottom right of B2

HTH
Michael
 
G

Gord Dibben

D-Click will work only if there is data down to row 3005 in an adjacent
column.

Gord Dibben Excel MVP
 
K

KiwiBrian

Thanks everyone you have helped mightily.
Brian.

Gord Dibben said:
D-Click will work only if there is data down to row 3005 in an adjacent
column.

Gord Dibben Excel MVP
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Small Thick "Bar" Below Last Typed Line ? 0
dragging formulas acros adjacent cells 3
VBA Coding Help for Beginner 0
Formula Response immediately? 0
Simple query 7
Display weeks from a Milestone 0
Excel 07 cell reference formula only showing literal text not value 0
Basic Query 1

Top