Editing multiple cells with one action????

  • Thread starter Thread starter Pedros
  • Start date Start date
P

Pedros

I have created many IF statements running down the page. To fill dow
the page I added $ to the cell that I wanted to remain constant but no
I want to fil across so I have to change the $ to a different cel
reference in the IF statement.

To avoid changing each individual IF statement (there are quite a few
I was wondering if there was a way I could highlight all of the cell
and just make the change in one which will change all of th
highlighted cells.

Please help, thanks. =
 
It appears that you would put the cursor on the first cell with the formula
and use "Find and Replace".
 
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

Excel Typed text appears in wrong cell 0
Text in Cell Formatting 5
Need to highlight cells in special order 0
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
multiple cells highlight instead of one 2
Selecting multiple cells, I can't see the cells highlighted 1
Excel 2007 highlights multiple cells when trying to select one. 5
If statement with dates 0

Back
Top