Excel Tips and Tricks
Enhancing Gridline Colors: How to Make Gridlines Darker/Brighter in Excel
If the default gridline colors in Excel don't match your application's aesthetic or feel repetitive, you can easily customize them to better suit your preferences. While manually adjusting each cell's border color is an option, it can be time-consuming and cumbersome....
How to print header row in Excel and repeat on every page
If your worksheet contains multiple pages, you will see header rows or columns only printed in the first page by default. In this article, we are going to show you how to print header row in Excel to repeat on every printed page in Excel 2016, Excel 2013, Excel 2010...
How to print gridlines in Excel
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
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...
How to insert today's date in Excel
Using the current time and/or date in Excel can help keep track of activities or add timestamps to your work easily. In Excel, there are a few ways for inserting the current date and time in a cell. In this article, we are going to show you how to insert Excel today's...
Find the Work Hours between Two Dates for a Business Day Calculator
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...
Excel Nested IF Alternative: The CHOOSE Function
A popular use case for the IF function is creating nested formulas that can check for various criteria. However, nested IF statements can get pretty complicated and cumbersome when dealing with several conditions. In this article, we’re going to show you how to use...
How to perform reverse lookup with CHOOSE function
Lookup functions are widely used in Excel models. However, one of the most popular lookup functions, VLOOKUP, can only search the left-most column in the search area. This function will fall short if you need to search in the middle of a table and return values from...
How to create a dynamic drop down list Excel using the UNIQUE and FILTER functions
A dynamic drop down (also known as a dependent drop down) is a term for drop downs with a dynamic list. The list items of a dynamic drop down get updated according to another input which is usually another drop down as well. A common example is to have lots of items...