Excel Tips and Tricks

Clicking on the sheet name on the bottom of the window is the most straightforward way of tab navigation in Excel, but there's more! Some of the other methods we're going to take a look at here can be especially helpful when dealing with a large number of worksheets....

Do the Excel grildine color not match the look-and-feel of your application, or are you just bored of the classic gray colors? Even though you can use border coloring to change those colors, there is an even better way to do this without applying a formatting to all...

The headings in Excel are essentially the screen guides that make working with cells or ranges easier. By default, row and column headings in Excel don't show in printed documents. If you want to print them anyways, Excel has an option which allows including row and...

The grid structure is an important feature that helps distinguish between sections, and build an interface easily when using spreadsheets. They are the guide in this structure that makes each cell distinct from other. If you want the gridlines that appear on...

Excel comparison operators can compare two values and return a logical (Boolean) value. You can use the return logical value in other functions like IF, or features, like Conditional Formatting, that require a logical value input. In this guide, we are going to show...

Finding the number of work hours between two dates can be a little more challenging due to the fact that you must also consider holidays and weekends. After finding the number of business days, you can easily multiply this number by daily work hours (i.e. 8 hours) to...

Reference types can be used in Excel to determine how Excel will treat a specific target reference. By default, all references are relative references, and this means that all subsequent actions will be relative to the position of that reference. To switch into an...