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

Copy addition formula of non-consecutive horizontal cells 2
Setting column width in a table with a macro is not working 0
MS Project Import Error Row 1 Column 5 2
Dragging a formula down isn't working - where am I going wrong? 1
Cumulative formula for word table 0
cannot copy in excel by dragging a cell 2
Outlook meeting location auto prompts with a suggestion list - need to disable 0
Text in note pane of "normal" display suddenly much larger 1

Top