Microsoft Excel includes the ability to password protect workbooks in a couple of different ways. While the vast majority of spreadsheets usually don’t require the protection of a password, there may be cases where you want to ensure that others can’t gain access to a spreadsheet that contains sensitive information.
Excel allows you to password-protect spreadsheets […]

Excel uses a 10pt Arial font by default, but that doesn’t mean that you have to live with it. Sure you can change the font manually at any time by simple selecting a new font style and size from the Formatting toolbar, but if you want Excel to always use a different font style by […]

Working with Excel and it’s Battleship-like grid coordinates is easy once you get the hang of it, but worksheets can be tough to navigate when loaded with tons of information across scores of rows and columns. For example, you might be using cell H37 as the location of a “total” value, but how intuitive […]

Like most Excel users, you’ve probably experienced a situation where you’ve attempted to print an Excel spreadsheet only to find that your columns extend beyond the “printable” boundaries of the page. In most cases, this becomes obvious when the pages are output - the first page appears, followed by the next, followed by any of […]

I hate to watch people squint at the screen when they use Excel. It’s no secret that we’re all getting older, and that generally speaking, our eyesight isn’t getting any better. Even with a reasonable screen resolution, Excel’s default font and cell sizes can seem tiny. While it may be tempting to start changing font […]

After taking the time to create an Excel spreadsheet laden with formulas that actually work correctly, the last thing you want to have to deal with is some adventurous rogue user messing with your hard work. While the majority of people will leave formulas that they don’t understand alone, others will attempt to tinker with […]

I can’t tell you how many time I’ve watched users struggle to resize all of the columns in an Excel spreadsheet individually, and manually. The need to resize the width of Excel columns is probably one of the most common tasks every Excel user needs to perform - most users do want the information in […]

When you attempt to use the Save or Save As command in Excel to save a newly created file, Excel will automatically assume that you want to save it to your My Documents folder on your local PC. While this is a reasonable default for most users, it can be a pain to have to […]

If you work in Human Resources, then you’ve no doubt spend your fair share of time creating (and changing, and changing again) organizational or “org” diagrams. Rather than fight with a program like Microsoft Word to create your organization charts, I strongly suggest that you take a look at the capabilities built into Excel first. […]

When you add comments to an Excel spreadsheet, you may be annoyed by the fact that your name doesn’t appear as the bolded commenter name by default. This revolves around the configuration of Excel, and the name that was supplied during the original installation process. This is especially true in corporate environments, where IT folks […]