Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Ranges
Is there a way that I can edit a range name to include more rows than
originally selected? If not, how do I delete a range name so that I can re-create it with the correct row and column addresses? Thanks so much for your knowledge Joanne |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Ranges
In xl2003, you can use Insert|Name|Define to delete and recreate a named range.
I think in all versions, you can use ctrl-F3 to pop up that same dialog. But maybe you can use a dynamic range name that adjusts according the number of rows and columns used. Debra Dalgleish explains it he http://contextures.com/xlNames01.html#Dynamic Joanne wrote: Is there a way that I can edit a range name to include more rows than originally selected? If not, how do I delete a range name so that I can re-create it with the correct row and column addresses? Thanks so much for your knowledge Joanne -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum the ranges | Excel Worksheet Functions | |||
Sum Ranges | Excel Worksheet Functions | |||
Using Ranges | Excel Discussion (Misc queries) | |||
3D Ranges | Excel Worksheet Functions | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) |