From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Format workbook defaults

Format workbook defaults - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Format workbook defaults

“

- [Instructor] We all have a way that we like to work. Our font, our colors, whatever we need to get our work done. In this video, we wanted to change our default so that the workbook when it always opens, it will have the dark gray theme, 14 point font, and it starts with five worksheets. Okay? Pause the video, change those defaults, then come back and I'll show ya how it's done. Okay, you're back, let's do it. We're going to go to File, Options. Okay, let's look at what we need. We want 14 point font. Start with five worksheets. Five, good. And then we want the dark gray theme. Go down here, OK. And then Excel will need to restart but notice the gray has already changed. OK. We're going to close. I'm going to hit Save. Now let's open a blank workbook. Boom.

Contents