How do I drag a formula so 1 variable changes and 1 stays on a cel

K

keithpt

I want to make a formula that when dragged will have one variable that will
change as it comes down the page and one that will stay constantly refering
to a given cell.
 
F

Fred Smith

You want an absolute address. Precede the cell you want to stay constant
with a $ sign. That tells Excel not to change it. Or, if you want, F4 will
do it for you.
 

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

VBA word change keys 0
Merging from an Excel file with graphics 1
New computer, how do i move outlook 365 ENTIRELY? 0
Working on birthday "book" for my wife and having layout/editing trouble 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
how can we make one constant number to be act as variable 3
Dragging down Formulas 7
Format column widths from one table to a separate table on same page 1

Top