| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
updating formulas with range names
If a range is named after formulas has been created. What is an efficient way to update the formulas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
updating formulas with range names
Find & replace.
Press Ctrl+H, type what range it used to be (e.g. A1:A10), what range is now called (e.g. MyRange) and choose either entire workbook or just sheet, and click replace all. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Brad" wrote: If a range is named after formulas has been created. What is an efficient way to update the formulas? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
updating formulas with range names
Use Find/Replace
Suppose we first enter: =SUM(A1:A100) and later define A1 thru A100 as alpha Just Find A1:A100 and replace with alpha. All the formulas should get updated -- Gary''s Student - gsnu200826 "Brad" wrote: If a range is named after formulas has been created. What is an efficient way to update the formulas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Restoring formulas after deleting range names | Excel Worksheet Functions | |||
| How do you set up range names, name formulas | Excel Worksheet Functions | |||
| Sumif referring to range names formulas not updating | Excel Worksheet Functions | |||
| Why are formulas not updating when changing a value in the range? | Excel Worksheet Functions | |||
| Updating Range Names | Excel Discussion (Misc queries) | |||
Linear Mode
