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 - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.