Excel 2007 - Can you assist?

I

Ithink 4 Me

Few questions for you all, after I upgraded I noticed a lot of changes and I
wondered:

How can you collapse the icons on the toolbars, so that it's just lists of
commands?

How can you save the last font and size in the drop down list, so that you
do not have to keep reselecting it when entering and/or reentering data into
a cell. (Perhaps, you have to format the entire sheet ahead of time.)

How can you add the Print Preview icon button and/or command to the "Home"
ribbon, so you don't have to go through 3 menus to review the appearance of a
sheet.

Thanks
 
P

Patrick Schmid [MVP]

Office 2007 is pretty restrictive in what it lets you do with
customizing the Ribbon.
Read http://pschmid.net/blog/2006/10/18/68 to get an overview of what
and how you can customize what is possible. This should answer most of
your questions. If not, just post back.
If you are not satisfied with what Office 2007 offers itself, you could
look into RibbonX, the Ribbon customization technology, or into my
RibbonCustomizer add-in.
For RibbonX, see http://pschmid.net/office2007/ribbonx
For my add-in, see the link below my name.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed
 
Top