advanced.excel - Customizing Toolbars

The UK's most regular instructor-led training courses.
Training information: advanced.excel · Excel course · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Customizing Toolbars

Craig has attended:
Excel Advanced course

by - delegate Craig [2 posts] (2006 Nov 10 Fri, 08:48) Reply

Question from the Excel Intermediate course:

I liked being able to have icons/toolbars down the left hand side in Excel.

Is it only possible to have toolbars (groups of icons) on the left hand side and not specific individual icons that I would want?

Many thanks

Craig

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 8 Tue	Bloomsbury	0	FULL
2003/XP	2008 Jul 8 Tue	Bayswater	1	book now	£195	£205
2003/XP	2008 Jul 9 Wed	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Jul 15 Tue	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Jul 15 Tue	Tooting	0	FULL
2007	2008 Jul 16 Wed	Bloomsbury	7	book now	£202	£224
Full Schedule: See all 160 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Customizing Toolbars

by - trainer Meenesh [9 posts] (2006 Nov 10 Fri, 08:55) Edited on 2006 Nov 29 Wed, 11:42 Reply

No you would have to have a tool bar running down the left side. You could always create your own tool bar and then add the icon(s)required and then put that on the left side (but you will see the whole left section greyed out, indicating a tool bar)

· Do You Really Need Excel VBA Training?
· How to Create Better Excel Spreadsheets: Part Three
· How to Create Better Excel Spreadsheets: Part One
· Excel Macros for the Non-Programmer
· Microsoft Excel Training: Not Just for Newbies Anymore

Excel tip:

Change the Print button so it brings up the Print dialogue box

If you want to bring up the Print dialogue box to check your print settings when you hit the Print button, do the following:

1. Right-click on the toolbar that displays the Print button.

2. Select Customise.

3. Click on the Print button on the toolbar to select it, then hold the left mouse button down and drag the button towards the screen below. The button should come off the toolbar.

4. In the Customise dialogue box on your screen, select the Commands tab.

5. Select File from the Categories list, and then locate the Print... icon (looks like the normal Print button, but the word Print has three dots following it).

6. Click on the Print... icon to select it, then use your left mouse to drag and drop the icon onto the toolbar at the top of the screen.

7. Close the Customise dialogue box.

View all Excel hints and tips