| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Editing multiple cells with one action????
I have created many IF statements running down the page. To fill down the page I added $ to the cell that I wanted to remain constant but now I want to fil across so I have to change the $ to a different cell 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 cells and just make the change in one which will change all of the highlighted cells. Please help, thanks. = ) -- Pedros ------------------------------------------------------------------------ Pedros's Profile: http://www.excelforum.com/member.php...o&userid=28202 View this thread: http://www.excelforum.com/showthread...hreadid=478107 |
|
#2
|
|||
|
|||
|
Editing multiple cells with one action????
It appears that you would put the cursor on the first cell with the formula
and use "Find and Replace". "Pedros" wrote: I have created many IF statements running down the page. To fill down the page I added $ to the cell that I wanted to remain constant but now I want to fil across so I have to change the $ to a different cell 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 cells and just make the change in one which will change all of the highlighted cells. Please help, thanks. = ) -- Pedros ------------------------------------------------------------------------ Pedros's Profile: http://www.excelforum.com/member.php...o&userid=28202 View this thread: http://www.excelforum.com/showthread...hreadid=478107 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| stopping pasted text deliminate across multiple cells | Excel Discussion (Misc queries) | |||
| Formula to delete blank cells across multiple columns? | Excel Worksheet Functions | |||
| Entering same data into multiple cells | Excel Discussion (Misc queries) | |||
| How do I center data across multiple cells in excel without mergi. | Excel Discussion (Misc queries) | |||
| background formatting across multiple cells | Excel Discussion (Misc queries) | |||
Linear Mode
