Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Editing a Range
I am totally frustrated with this latest version of Office. It is
unbelievably user-unfriendly. Right now I am trying to figure out how to edit a Range Name (what appears in the Name Box) for an Excel spreadsheet. I want to change the area (cells) that is included, but I cannot for the life of me find the answer. As I recall in the previous version of Excel, I would go to Insert, Name, Define and then be able to specify the range of cells to be included. Where the heck is it now? And why is it so difficult to find it through Excel Help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Editing a Range
My first impressions were like yours ... '07 was completely user-
unfriendly. However, after several months of using it day in & day out, I actually like it much better ... organized much more intuitively, I think. In any event, click on the 'Formulas' heading ... the Ribbon will change to options useful when working with formulas. Right in the middle of the Ribbon will be a series of 4 options, the largest of which (icon wise) will be 'Name Manager'. You may need to make your Excel window larger, as the Ribbon will adjust itself to the size of the window (ie, larger window = larger icons). Click on Name Manager and a pop-up will appear listing all currently defined names. Click once on the Name you'd like to modify ... in the 'Refers To' box (bottom of pop-up window), adjust the range to what you'd like it to be and then hit 'Close'. That's it .... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Editing a Range
On Ribbon, open the Formulas tab and locate the Defined Names group (near
centre); on this use the Defined Names tool I bet someone who knows Excel 2007 would have a hell of a time finding it in Excel 2003! best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "BJ NuStar" wrote in message ... I am totally frustrated with this latest version of Office. It is unbelievably user-unfriendly. Right now I am trying to figure out how to edit a Range Name (what appears in the Name Box) for an Excel spreadsheet. I want to change the area (cells) that is included, but I cannot for the life of me find the answer. As I recall in the previous version of Excel, I would go to Insert, Name, Define and then be able to specify the range of cells to be included. Where the heck is it now? And why is it so difficult to find it through Excel Help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Chart Data Range editing | Charts and Charting in Excel | |||
EDITING | Excel Discussion (Misc queries) | |||
problems editing data range | Excel Discussion (Misc queries) | |||
EDITING A RANGE FOR FILTERATION | Excel Discussion (Misc queries) | |||
Editing the name box | New Users to Excel |