From the course: Excel 2010 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Coordinating a look using themes

Coordinating a look using themes - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

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, this is where we're…

Contents