Excel 2010 Styles and Themes – Excel Fashion statements
Free Microsoft Office Tutorials
Microsoft Excel 2010: Formatting the worksheet with Excel 2010 Styles and Themes .
The formatting of your document can mean the difference between success and failure for your document. There is a fantastic array of tools available to us for formatting in Microsoft Excel 2010.
Watch this short video tutorial for formatting with Excel 2010 styles and themes
Most of our formatting tools appear under the Home tab.
Here you can bold, underline, italicise, increase font size, change font and background colours and much more.
The button in the bottom right hand corner of the font section opens up the Format Cells dialog box.
This is a multi-tab box for Number/Alignment/Font/Border/Fill and Protection.
The section named Styles on the home tab provide a range of built in formats that can be applied to you worksheet cells. You can easily create custom formats for your specific needs. Click on Create New Cell Style, give your style a name and set the options in the dialog box. Hover your mouse pointer over these options and view a preview before you commit to the formatting of the cell or range.
An extremely powerful feature of Microsoft Office is Themes. You can locate Themes on the Page Layout tab of the ribbon. Themes appear across the Office suite. A theme created in Microsoft Access will be available in Microsoft Excel, PowerPoint and Word. Again hover over a theme and see a preview of the changes.
You can create custom themes and store them for later use.
You can customise the Colours Fonts and Effects for a theme and the palettes and styles will change accordingly.
Your selected theme and all of the styles and pallet colours are also represented in your tables. You can change a range to a table from the Styles section and all of these options will appear in that table. If you convert the table back to a range it will retain the formatting from the theme.
The options are endless with Excel 2010 Styles and Themes.
From Office 2007 onward when Microsoft changed the Office suite from a binary format to an XML format the formatting options became enormous.
Online PC Learning is committed to providing free office tutorials