XL 2007 Display Question

D

Dana DeLouis

Hi. When I select an area (say A1:C5) in Excel 2007, the name box only
displays A1.
The name box in prior versions would show the selection (ie A1:C5).
I find this to be a problem when the selection is larger.

Is this a problem for others, or just me? I don't see any options for this
either.
Thanks.
 
B

Bob Phillips

Dana,

The name box has only ever shown the activecell for me, so maybe it is a
setting somewhere.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
J

Jon Peltier

The name box only shows the active cell. You could type "a1:c3" into the
name box, and Excel will select it for you, then change the name box back to
A1.

- Jon
 
B

Bernard Liengme

Hi Dana,
In XL2003 and in XL2007 as I select a range the name box shows something
like 12R × 5C (12 rows by 5 columns) but as soon as I release the mouse
button the name box displays only the active cell (not a range)

Have you a site were we can view your other 115 loss of productivity items?
So far I am happy with XL2007. A few things took time to find but most are
'in your face' as MS intended.

best wishes
 
J

Jon Peltier

Bernard -

I feel like I have to do much more mouse clicking in Excel 2007 than before.
The button I want isn't on a commandbar that's always visible, it's on a
ribbon tab which I first have to click, then click on the button. Two clicks
for one. The dialogs to format shapes and chart elements have many more tabs
than before, most of which are sparsely populated. I can't get to all axes
in one dialog (Chart menu > Chart Options > Axes tab), I have to deal with
them one at a time using the item on the tab. When I format the scale of a
chart axis, clicking the Fixed radio button does not select the number in
the related box, I have to make an extra effort to select it. I can't click
in the box with the number until I've already activated Fixed. What causes
many more mouse clicks is that the behavior of Undo (Ctrl+Y) is erratic, and
the behavior of Repeat Last Action is practically nonexistent when charts
are involved. This causes a major productivity loss.

The lack of easy and quick customization causes delays. I used to be able to
make a throwaway floating commandbar with two or three buttons, float it
near where I was working, then delete it when I didn't need it any more. The
QAT is stuck at the top of the screen. I used to be able to tear off a
formatting menu so I would only need one click to format a shape, but now I
need to make repeated trips to the ribbon.

Some things I can't even do in 2007. I can't independently format X and Y
error bars on the same series. I can't format a series by selecting its
legend key in the legend. I can't plot an XY series on the X axis of an
existing line chart. I can't record a macro while I work with shapes, and
the recorder only captures some of the actions when working with charts.

Have I gotten to 115 yet? Maybe not, but I'm not out to trash 2007. I
actually kind of like it, but it doesn't feel ready for real work yet. I
know they're planning improvements for SP1, and I'm hoping they'll get to
some of my issues.

- Jon
 
Top