How to Print the Page Header on Multiple Pages in Excel

Knowing how to print page headers on multiple pages in Excel is an important skill. It is a must-know, especially for people who work on complex Excel worksheets. Sometimes, turning the printouts back and forth to see the page headers becomes tiresome. Often, the top header is usually printed only on the first page; this… Continue reading How to Print the Page Header on Multiple Pages in Excel

Published
Categorized as Outlook

How to use VLOOKUP in Excel

VLOOKUP is an Excel-in-built Excel function.  The V stands for Vertical. Hence the parts stand for Vertical Lookup. It is a tool used in Excel to look up information or data across different Excel columns and extract corresponding information. In short VLOOKUP function allows a user to establish the relationship between the other columns of… Continue reading How to use VLOOKUP in Excel

Published
Categorized as Excel

How to Remove Duplicates in Excel

Duplicates are common mistakes that most people make on their Excel worksheets during data entry. Duplicates in your data can lead to misinterpretation and wrong forecasting of data; they affect data analysis greatly. Removing duplicate entries is quite a simple process in Microsoft Excel. From a given set of data, you can identify in so… Continue reading How to Remove Duplicates in Excel

Published
Categorized as Excel

How to hide excel columns

Microsoft Excel programs have rows and columns which make up cells. There are times you want to hide information in specific columns. Other times you may need to hide columns with data that you currently don’t need or new regions of a worksheet. Hiding columns presents a worksheet that focuses on just the details area,… Continue reading How to hide excel columns

Published
Categorized as Excel

How to create a drop-down list and how to edit a drop-down list in Excel

Working with Excel worksheets can be more efficient and straightforward by using drop-down lists.  These lists allow you to create a list of choices that you can select from a given field.  Therefore, drop-down lists are a great data entry tool when you want a user to select items from a list you have created… Continue reading How to create a drop-down list and how to edit a drop-down list in Excel

Published
Categorized as Excel

How to Hide Excel Formula

For any excel user to become proficient and advanced, they should have detailed and sufficient knowledge when using Excel formulas. Excel formulas can make your computations and daily tasks easier. Sometimes a user can share their worksheet with many users, hence the need to hide formulas instead of displaying them. Hiding formulas in Excel is… Continue reading How to Hide Excel Formula

Published
Categorized as Excel