How to Coordinate a Look With Themes in Excel 2010


show more Coordinating a look using themes provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training show less
please wait ...

Coordinating a look using themes

Let's say you have a worksheet like this that contains rows, columns of numbers, maybe some drawings and a chart, and you want a quick way to format everything all at once, so that it looks consistent and unified. Maybe looking like other documents that you have created in Word or PowerPoint for example. Using a theme you can apply consistent and professionally designed formatting to all the parts of your worksheet. Now keep something in mind though. What themes cannot do is they can't read your mind. So you have to give this worksheet a bit of a headstart by indicating where you want the formatting applied and here's how we will do it.

Click anywhere inside this number area, and we're going to format this as a table. Don't worry too much about that. Over here in the Home tab we want to go here under Styles, click Format as Table. Choose anything here. It doesn't really matter because we're going to change it in a bit. What this is simply doing is saying okay...

Coordinating a look using themes
Video duration: 3m 22s 6h 21m Beginner

Viewers:

Coordinating a look using themes provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...