Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
549 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
Using Styles in Microsoft Excel Part one of a two-part series of blogs |
---|
Constantly formatting cells in the same way can be one of the most tedious and time-consuming tasks in Excel. This blog teaches you how to use styles so that you can quickly apply consistent formatting across a range of cells.
|
Formatting worksheets can be one of the most tedious tasks in Excel, particularly if you're forced to replicate your organisation's standard colours and font schemes. Using styles is a fantastic way to save masses of time when formatting a worksheet as you can apply a whole range of formatting options to cells with a couple of clicks of the mouse.
A style is simply a collection of formatting options, such as font size, cell colour and border style settings, saved with a sensible name and which can be applied to cells quickly.
You can see a video tutorial covering how to use styles in Excel workbooks by clicking here, or a full range of Excel training courses and resources here.
Every new workbook that you create contains a number of existing styles which you might find useful. To see which styles you have available, from the ribbon choose: Home -> Cell Styles
This option might appear minimised like this if your screen is quite small.
For bigger screens you should see something like this:
For normal screens you'll see a list of styles.
Notice that the Normal style is applied to cells by default. We'll use this to our advantage later.
To apply an existing style you simply need to select a cell or cells and then select one of the styles from the list.
Select the cells you want to apply the style to.
Here we're going to apply a heading style to the selected cells.
From the ribbon or toolbar select the style you want to apply to the selected cells.
Here we're applying the Heading 2 style in Excel 2010.
The selected cells should now be formatted according to the options contained within the style.
This style makes the font larger, blue and bold, and adds a blue bottom border to each cell.
If you have the Style list on a toolbar in Excel 2003 you can press ALT + ' to access it, and then type in the first letter of the style name you want to apply, or use the arrow keys to scroll through the list. When you've highlighted the style you want, press Enter to apply it to the selected cell.
You can't technically remove a style from a cell - every cell uses a style. Remember that we earlier pointed out that each cell uses the Normal style by default? To remove the formatting applied by a style you can simply set the cells back to using the Normal style.
Apply the Normal style to remove the formatting applied by other styles.
Using existing styles is fine as long as you're happy with the limited choices that you have. It's more likely that you'll want to create your own custom styles, perhaps to fit in with a corporate colour scheme. Read the next part of this blog series to find out how to do this.
Parts of this blog |
---|
|
Some other pages relevant to the above blogs include:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.