Microsoft Office Development and Consultancy

Excel

This tab provides commands from various places including Page Setup, Tools > Options and AutoShapes.

Themes

Themes - Drop-Down. Changes the overall look and feel of your workbook including colours, fonts and effects. The drop-down contains the commands: Built-in, More Themes on Microsoft Office Online, Browse for Themes and Save Current Theme. The built-in themes are: Office, Apex, Aspect, Civic, Concourse, Equity, Flow, Foundry, Median, Metro, Module, Opulent, Oriel, Origin, Paper, Solstice, Technic, Trek, Urban and Verve. Tooltip indicates the current theme. The default theme is "Office".

Colors - Drop-Down. Displays a list of all the available colours and lets you change the colour component of the active theme. The drop-down contains the commands: Built-in and Create New Theme Colors.

Fonts - Drop-Down. Displays a list of all the available fonts and lets you change the font component of the active theme. The drop-down contains the commands: Built-in and Create New Theme Fonts.

Effects - Drop-Down. Displays a list of all the available effects and lets you change the effect component of the active theme. The drop-down contains the commands: Office, Apex, Aspect, Civic, Concourse, Equity, Flow, Foundry, Median, Metro, Module, Opulent, Oriel, Origin, Paper, Solstice, Technic, Trek, Urban and Verve.

Page Setup

Most of these have been taken from the (File > Page Setup) dialog box.

Margins - Drop-Down. Lets you choose from one of your built-in margin settings or lets you customise your own. The drop-down contains the commands: Normal, Wide, Narrow and Custom Margins.

Orientation - Drop-Down. Lets you switch between Portrait and Landscape. This provides a shortcut to the (Page Setup)(Page tab, Orientation).

Size - Drop-Down. Lets you select from all the different available paper sizes. This provides a shortcut to the (Page Setup)(Page tab, Paper size drop-down).

Print Area - Drop-Down. This drop-down contains the commands: Set Print Area and Clear Print Area.

Breaks - Drop-Down. This drop-down contains the commands: Insert Page Break, Remove Page Break and Reset All Page Breaks.

Background - Displays the "Sheet Background" dialog box.

Print Titles - Displays the (Page Setup)(Sheet tab) dialog box to allow you to enter rows or columns to repeat.

Scale to Fit

Width - Choice of 1 to 9 pages. The combo box contains Automatic, 1 to 9 pages and More Pages. Provides a shortcut to (Page Setup)(Page tab, Scaling).

Height - Choice of 1 to 9 pages. The combo box contains Automatic, 1 to 9 pages and More Pages. Provides a shortcut to (Page Setup)(Page tab, Scaling).

Scale - Changes the page scale in increments of 5%. Provides a shortcut to the (Page Setup)(Page tab, Scaling).

Sheet Options

Gridlines View - Toggles the display of gridlines on the active worksheet. Provides a shortcut to (Page Setup)(Sheet tab, "Gridlines").

Gridlines Print - Toggles whether the gridlines are printed. Provides a shortcut to (Excel Options)(Advanced tab, "Show gridlines").

Headings View - Toggles the displays of row and column headers on the active worksheet. Provides a shortcut to (Excel Options)(Advanced tab, "Show row and column headers").

Headings Print - Toggles whether the row and column headers are printed. Provides a shortcut to (Page Setup)(Sheet tab, "Row and column headings").

Arrange

This whole group also appears on the Drawing Tools - Format tab.

This whole group also appears on the Picture Tools - Format tab.

Bring Forward - (Bring to Front in 2007). Button with Drop-Down. The button brings the selected object forward one level. The drop-down contains the commands: Bring to Front and Bring Forward. Bring to Front will bring the selected object in front of all the other objects.

Send Backward - (Send to Back in 2007). Button with Drop-Down. The button brings the selected object back one level. The drop-down contains the commands: Send to Back and Send Backward. Send to Back will send the selected object to the back of all the other objects.

Selection Pane - (Added in 2007). Drop-Down. Displays the Selection and Visibility pane.

Align - Drop-Down. This drop-down contains the commands: Align Left, Align Center, Align Right, Align Top, Align Middle, Align Bottom, Distribute Horizontally, Distribute Vertically, Snap to Grid, Snap to Shape, View Gridlines.

Align (Word extras) Align to Page, Align to Margin, Align Selected Objects, View Gridlines and Grid Settings.

Align (PowerPoint extras) Align to Slide, Align Selected Objects, View Gridlines and View Settings.

Group - Drop-Down. This drop-down contains the commands: Group, Regroup and Ungroup.

Rotate - Drop-Down. This drop-down contains the commands: Rotate Right 90, Rotate Left 90, Flip Vertical, Flip Horizontal and More Rotation Options.