Skip to content
Settings Icon in Boxes

Excel Workbook Settings

Have you ever pulled out your Excel workbook and just felt overwhelmed with all of the different settings and tabs and buttons you have to choose from? I know I have, and it can be pretty overwhelming.

The good news is, you don’t have to feel overwhelmed any longer. Of course, there are plenty of different settings and options to choose from, but you don’t need to use them all to create an effective spreadsheet. In fact, you only need to know a small handful to be successful.

I’m guessing that out of the small handful of options and settings I would recommend, you might already know most of them. Nonetheless, today I’d like to share a few with you that you may not have thought of utilizing before. After all, a few more tools in your toolbox can go a really long way in the end.

Setting No. 1 – Toggle Gridlines Off

Toggle Gridlines Excel Setting

One of the most obvious characteristics of spreadsheets are the gridlines. These thin gray lines are what make a spreadsheet look like a spreadsheet.

However, you don’t always need them to build an effective spreadsheet.

Sometimes, as much as they help, gridlines can get in the way. They can make a spreadsheet feel crowded or too busy. And they can distract you or your audience from what really matters – the data and information within the spreadsheet itself.

Highlighting the important information in a spreadsheet

Plus, if you really do need to structure your spreadsheet by adding in some lines in certain places, you can use borders instead of grid lines.

This can actually be a much better solution in the long run.

Why? Because you can highlight and set the focus on where you really want it to be. This is much better than littering the screen with unnecessary lines that don’t serve a purpose in the first place.

Setting No. 2 – Page Views

Did you know that you can change the view of your spreadsheet? Instead of the traditional view, you can take a look at the Page Break View or the Page Layout View instead.

Excel Workbook Views Settings

Although these views are not the best when it comes to most of the work you will do with your spreadsheet, there are certain times when these views come in handy.

For instance, if you ever plan on printing out some of your spreadsheet work, the Page Break View can be a nifty tool to capitalize on. With this view, you can better organize your functions, formulas, and data so that you know what information will be printed on which page.

Excel Workbook Printing Layout

Plus, if you need even more control or specificity on how your document will look when you print it, you can use the Page Layout View instead. This view makes it much easier to get all the details just right so that when you finally do print your workbook pages, they come out just as you need them to.

Setting No. 3 – Freeze Panes

This is a nifty setting to capitalize on. If you ever find yourself wanting to view one part of a spreadsheet while you look at another part of the spreadsheet at the same time, then this setting will work wonders.

The Freeze Panes option allows you to freeze some cells in place while you can scroll through the other cells which are not “Frozen.”

Excel Freeze Panes Setting

This can come in handy when you want to keep certain numbers or headings in view while drilling down into the data underneath. There are times when you just don’t want to scroll through everything.

Freeze the important stuff and scroll through the rest.

Setting No. 4 – Protect the Workbook

Who are we protecting the workbook from? I suppose we could protect it so that none of our sneaky family members can steal our Excel formulas.

After all, we worked so hard to create and write them in the first place!

In reality however, the most important person to protect our workbooks from is…ourselves.

More often than I’d like to admit, I’ve spent way too much time constructing a worksheet only to accidentally delete an important part of it. This is where workbook protection comes into play.

You can protect each sheet that exists within your workbook, and you don’t need to set a password to do it either.

Excel Spreadsheet Protection Setting

The main reason you might want to protect your workbook is so that you don’t accidentally delete or destroy the hard work you put in to make it fully functional.

What’s more, you can unprotect it at any time to make a quick change or two with ease. Just remember to protect your hard work so you don’t fall victim to your own accidental blunders.

Setting No. 5 – Spell Check

Yes. You can absolutely spell check your spreadsheet.

Of course sometimes this isn’t a good idea because your spreadsheet contains crazy acronyms or fun data labels.

However, there are certainly times when a quick spell check would come in handy.

All you’ve got to do is press the spell check button, and you can take a quick look at all the words on your worksheet. You can ignore the ones that don’t matter, and correct the mistakes that were accidental.

Excel Spell Check Setting

Just because you’re using a spreadsheet doesn’t mean you have to lose out on spelling. You just get to pick and choose a little more easily.

So whether you are changing the view or adding in some protection, a few small settings can go a long way. It’s not one big event that makes a spreadsheet spectacular. It’s all the details that go in to making it a true digital masterpiece.

This Post Has 0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top