Excel 2004 Pallet's?

[brianb]

I just purchased a Mac and Office 2004 (with the upgrade), I am used
to excel 2003 in windows and the undocked pallets (i believe thats
what it is called) is driving me crazy. Is there a way to dock it?
Also is there a cheat sheet for some commands in office mac 2004?? I
know tons of shortcuts in the windows version but they do not work in
office mac...

 

[CyberTaz]

Hello & Welcome, Brian -

If you're referring to the Formatting Palette, No, it can't be docked (like
if you're thinking in terms of WinXL's Task Pane). However, it will stay
where you put it & once you adjust the size of your file window the effect
is much the same - I keep mine off to the right with the workbook window
filling the remainder of the screen.

As far as shortcuts, just look that keyword up in Help. Not only will you
find the equivalents, but you'll also find that many of them are the same
once you get the hang of ALT=Option & CTRL=Command. Custom assignments of
keystrokes in the Mac version is also far more widely available.

Good Luck |:>)
Bob Jones
[MVP] Office:Mac

 

[brianb]

Hello & Welcome, Brian -

If you're referring to the Formatting Palette, No, it can't be docked (like
if you're thinking in terms of WinXL's Task Pane). However, it will stay
where you put it & once you adjust the size of your file window the effect
is much the same - I keep mine off to the right with the workbook window
filling the remainder of the screen.

As far as shortcuts, just look that keyword up in Help. Not only will you
find the equivalents, but you'll also find that many of them are the same
once you get the hang of ALT=Option & CTRL=Command. Custom assignments of
keystrokes in the Mac version is also far more widely available.

Good Luck |:>)
Bob Jones
[MVP] Office:Mac



- Show quoted text -

Thank you CyberTaz, I will do that. Just getting adjusted to it....
and of course the "boss" at home is kicking and screaming because its
something new haha

 

[Jim Gordon MVP]

Hi Brian,

Windows versions of Office don't have an equivalent to the formatting
palette.

However, you can create your own dockable toolbars (which you can also do in
Windows Office).

To create a dockable toolbar that has any combination of commands you desire
use View > Toolbars > Customize Toolbars/Menus...

In the dialog box click the NEW button to create a new, empty toolbar. It
will be very small and you might not even notice it on the screen, but it's
there if you look around. Turn it on and off by checking and unchecking its
name in the toolbar list and you might find it easier that way.

Next, click on the COMMANDS tab of the dialog box. Drag any commands you
like to your new toolbar (or any other toolbar or menu for that matter).

You can lots of your own toolbars so that if you want various sets of
commands together you can have that.

Click the OK button when you are done and you now have your own set of
toolbars.

You can even attach customized toolbars to individual workbooks. Just go
back into that dialog box and click the Attach button to attach a copy of
any of your customized toolbars to any given workbook. When you give that
workbook to someone else they will see your customized toolbar when they
open the workbook.

-Jim

Thank you CyberTaz, I will do that. Just getting adjusted to it....
and of course the "boss" at home is kicking and screaming because its
something new haha

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info