Dragging a formula in a column

R

RB

I have a formula in a cell that I need to drag down, the spreadsheet itself is very big and dragging it is a pain. Tried double clicking the lower right corner but it wont work because the column to the right of it also has blanks in it. Any suggestions?
 
G

GS

I have a formula in a cell that I need to drag down, the spreadsheet itself
is very big and dragging it is a pain. Tried double clicking the lower right
corner but it wont work because the column to the right of it also has blanks
in it. Any suggestions?
Click to expand...

You could select the first cell containing the formula along with all
the other cells you want to copy the formula to, then press 'F2' to
enter EditMode in the cell containing the formula, then press
'Ctrl+Enter' to put the formula into all the other cells
simultaneously.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 

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

cannot copy in excel by dragging a cell 2
Dragging Down a Formula 4
How to apply a formula to all cells in a column 3
using the =page! feature to transpose a row to column 0
Trouble in Dragging the cell 3
autofill dragging result rather than formula, why? 3
Copying formulas from one cell to another 7
when I drag a formula to other cells the reference is the same 1

Top