Editing a Range

  • Thread starter Thread starter BJ NuStar
  • Start date Start date
B

BJ NuStar

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?
 
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 ....
 
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
 
Back
Top