QAT (Quick Access Toolbar) - How to make it bigger or expand it to show a more complete document loc

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

Hi All,

I have added the 'document location' to my QAT, but it is so short
(narrow) that hardly anything shows up.

How do you expand the QAT itself or the 'Document Location' to make it
wider and show more of the full path / URL?

Thanks,
--

Alan.

The views expressed are my own, and not those of my employer or anyone
else associated with me.

My current valid email address is:

(e-mail address removed)

This is valid as is. It is not munged, or altered at all.

It will be valid for AT LEAST one month from the date of this post.

If you are trying to contact me after that time,
it MAY still be valid, but may also have been
deactivated due to spam. If so, and you want
to contact me by email, try searching for a
more recent post by me to find my current
email address.

The following is a (probably!) totally unique
and meaningless string of characters that you
can use to find posts by me in a search engine:

ewygchvboocno43vb674b6nq46tvb
 
Hi All,

I have added the 'document location' to my QAT, but it is so short
(narrow) that hardly anything shows up.

How do you expand the QAT itself or the 'Document Location' to make it
wider and show more of the full path / URL?

Thanks,
Click to expand...
From what little I know of the QAT, you have no control over its size,
location (other than above/below ribbon) or size of individual items.
 
Tushar Mehta said:
From what little I know of the QAT, you have no control over its
size,
location (other than above/below ribbon) or size of individual
items.
Click to expand...

Stymied again!

Thanks Tushar.

I jumped into using Excel 2007 early this time (I was previously using
Excel 9 (2000) so I skipped Excel 10 and Excel 11), but I have to say
that, in my opinion, the 'ribbon' is a big mistake. It is really no
different than the old menu system, except that it is harder to see
all the options (no longer being in a nice list that you can run down)
and it takes up much more space with the pretty pictures.

My impression is that Excel 2007 has been aimed entirely at beginners.

Anyhow, thanks for your reply.
--

Alan.

The views expressed are my own, and not those of my employer or anyone
else associated with me.

My current valid email address is:

(e-mail address removed)

This is valid as is. It is not munged, or altered at all.

It will be valid for AT LEAST one month from the date of this post.

If you are trying to contact me after that time,
it MAY still be valid, but may also have been
deactivated due to spam. If so, and you want
to contact me by email, try searching for a
more recent post by me to find my current
email address.

The following is a (probably!) totally unique
and meaningless string of characters that you
can use to find posts by me in a search engine:

ewygchvboocno43vb674b6nq46tvb
 
Stymied again!

Thanks Tushar.

I jumped into using Excel 2007 early this time (I was previously using
Excel 9 (2000) so I skipped Excel 10 and Excel 11), but I have to say
that, in my opinion, the 'ribbon' is a big mistake. It is really no
different than the old menu system, except that it is harder to see
all the options (no longer being in a nice list that you can run down)
and it takes up much more space with the pretty pictures.

My impression is that Excel 2007 has been aimed entirely at beginners.

Anyhow, thanks for your reply.
Click to expand...
Yes, you've hit the "highlights" of the Ribbon. {grin} Of course, there
are a few benefits that hopefully will become more apparent over time.
 
Yes, but consider that most users of spreadsheets are beginners who
don't want to look for things in menus. Spreadsheet designers have
the capability to put functionality needed right in front of end
users, in the simplest scenarios without any programming (and no
security warnings). So perhaps it's aimed at beginners, but it's also
developer-friendly.

I, too, am somewhat disappointed in the limited functionality of QAT.
 
Do you have any factual evidence for this claim?

"Yes, but consider that most users of spreadsheets are beginners who
don't want to look for things in menus"
 
Peo Sjoblom said:
Do you have any factual evidence for this claim?

"Yes, but consider that most users of spreadsheets are beginners who
don't want to look for things in menus"
Click to expand...

Doesn't seem unreasonable if *Office* users are also taken as the
population of [potential] Excel users. If so, I'd be willing classify
95% of Excel 'users' as rank novices.

OTOH, if the population were narrowed to those who use Excel on a
daily basis, the distribution between novice, learning, intermediate,
advanced and expert would be more bell shaped, though I'd still expect
it to be skewed towards more inexperienced users.
 
"Yes, but consider that most users of spreadsheets are beginners who
don't want to look for things in menus"
Click to expand...

Doesn't seem unreasonable if *Office* users are also taken as the
population of [potential] Excel users. If so, I'd be willing classify
95% of Excel 'users' as rank novices.

OTOH, if the population were narrowed to those who use Excel on a
daily basis, the distribution between novice, learning, intermediate,
advanced and expert would be more bell shaped, though I'd still expect
it to be skewed towards more inexperienced users.
Click to expand...


True, but that still leaves us with the claim that novice users would prefer
the ribbon vis-à-vis menus?


Peo
 
Peo Sjoblom said:
True, but that still leaves us with the claim that novice users
would prefer the ribbon vis-à-vis menus?
Click to expand...

The ribbon IS a menu, just one with two and only two states: collapsed
so that only the tabs appear or expanded so that the sections
underneath the tab appear for the selected tab. In contrast, the
'Classic Menu' has many different states when various menus or
submenus are selected along with an unselected state which takes up
less screen real estate than even the collapsed ribbon.

At this point I can hear the ribbon partisans claiming that I'm not
factoring in toolbars. The 'average user' has several of them visible.
They're right. Even I have several visible by default, HOWEVER, I have
only a modified Standard toolbar (including an entry named Tool&bars,
which gives me keyboard access to all of 'em) that docks just
underneath the 'Classic menu' ALONG WITH the Formula Auditing toolbar.
I use others, but I call them up AS NEEDED (i.e., AS **I** NEED THEM),
then dismiss them when *I* no longer need them. I have most of the
others display floating when I call them up, but Drawing, Forms and
Controls Toolbox display docked to the RIGHT SIDE of my Excel
application window, WHERE I WANT THEM.

The QAT is a pathetic alternative to 'Classic' toolbars that would
only make sense to the warped mind of a few perverse Microsoft
employees who are unlikely to use Excel on a daily basis but assume
they're far better qualified to judge how people who do should use
Excel. While I grant an argument could be made that the ribbon is a
better menu than the 'Classic menu', only a Microsoft shill would try
to claim that the combination of the ribbon and the QAT are in any way
better toolbars than 'Classic' toolbars were.

The likelihood is I'll eventually have to use a beribboned version of
Excel some day at work, but I'll stick to earlier versions and
OpenOffice at home.
 
Back
Top