Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

bolt ons toolbar

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Bolt ons to toolbar in 2010

Bolt ons to toolbar in 2010

ResolvedVersion 2007

Andrew has attended:
Excel Introduction course

Bolt ons to toolbar in 2010

How do I bolt on custom views to my tool bar in 2010?

RE: Bolt ons to toolbar in 2010

Hi Andrew, not 100% sure I understand the question but this is what I think you mean.

1) to add commands to to the quick access toolbar you click the black arrow at the right end of the bar and select "more commands", then select the command you want to click "add". Another way is to simply right click on a command on your ribbon and add it to your toolbar.

2) you can also customise your ribbon but going to excel options and "customise ribbon".

does that help?

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Wed 1 Feb 2012: Automatically marked as resolved.

Excel tip:

New Normal Worksheet

Do you want all your worksheets to confirm to a certain look? Then change the Defaults!!!
1. Press Shift+F11 to create a new worksheet
2. Press Ctrl+A to select (higlight) all cells, Press Ctrl+1, make any formatting changes then click OK.
3. Press F12 (Function 12 key) click in the Save As Type, drop down, then select Template (*.xlt)
4. Click in the Save in drop-down, then find the folder; c:_program files_microsoft office_office_start. (For the underscores shown use backslash)
Name your templete sheet.xlt, then press Enter.
Sheet.xlt is used when you insert a new worksheet (Shift+F11)

Note: These changes are permanent changes on your PC.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.