From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Set up and format a workbook

Set up and format a workbook - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Set up and format a workbook

“

- [Instructor] Before we start working, it's often nice to get our workbook all set up the way we want it. So here's what we need to do with this one. We want eight sheets. They're going to be identical. They are all going to have headers that are going to be bold font, 14 point and underlined. The headers are item, item ID, category and we want category highlighted yellow and we want a count and then over in column F, as you can see in this picture, we want location, address one and address two and finally, for sheets six, seven and eight, make the tabs blue. Pause the video. Open the workbook. Get it formatted. Come back and we'll go through it together. Alright, you're back and we're going to lead off with a really great trick. We need eight sheets. Fine, we'll go to one, two, three, four, five, six, seven, eight. Beautiful. Let's go back to the first. They all need the same headers. Am I going to go…

Contents