How to print header row in Excel and repeat on every page

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

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

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

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...
Excel Nested IF Alternative: The CHOOSE Function

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

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...