Force change

  • Thread starter Thread starter MrJim005
  • Start date Start date
M

MrJim005

When copying formulas, the $ sign stops excel from changing to the next
column letter. Is there a symbol to force excel to change to the next
letter?



Thank You
 
When editing the cell....if you remove any of the dollar signs that will
"unlock" that part of the reference.

For more information search Excel Help for "range reference"
and read the topic: About cell and range references"

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
You must log in or register to reply here.

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

(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
Paste Values and Source Formatting Shortcut 3
Copying a formula to a range 2
How to type each letter of the alphabet automatically in a specific color in Word? 0
Excel Help to copy information from one row at a time to another sheet 1
Hope you can help 4
why won't text-to-columns work here? 6
Vlookups using 2 Values 2

Back
Top