Recent Posts

How to Wrap Text in Excel and When to Use it

The "Wrap Text" feature allows you to display cell contents on multiple lines within a single cell instead of having the text overflow...

How to Find and Replace Values in Excel

Find and Replace allows you to find specific information across large workbooks and make sweeping changes if necessary. Contents: 1....

How to Link Workbooks in Excel

When working with multiple Excel workbooks, you'll often find yourself needing to reference numbers from one workbook in a separate...

How to Enable the Developer Tab in Excel

The Developer tab in Excel is hidden by default, but offers some very important functions and built in features that every Excel Expert...

Multi-Sheet References & Formulas - 3-D References in Excel

A 3-D reference is a reference to a range of cells across multiple worksheets in a workbook. For example, if you have a workbook with...

How to Quickly Copy Worksheets in Excel

Often times you'll want to create copies of existing worksheets to tweak or use as a template elsewhere in your workbook. There are a few...

How to Change Text and Font Color in Excel

Changing text color can highlight specific areas on your worksheet that may otherwise go unnoticed. Specific problems, important...

How to Use the Format Painter in Excel

The Format Painter tool will help you quickly copy the formatting from anywhere in your workbook, saving you the time and hassle of...

How to Remove Duplicates in Excel

Sometimes it is necessary to remove duplicate items from a column or duplicate rows out of an entire table. Removing duplicates will help...

How to Freeze Rows and Columns in Excel

Often times when scrolling through data in Excel, you want to keep the top few rows visible so you can easily see the column headers...

How to Hide and Unhide Sheets in Excel

Often, you won't want every worksheet in your workbook to be able to easily be viewed by everyone. Hiding and unhiding sheets will let you p

How to Zoom in Excel - 5 Methods

When working in Excel, it can sometimes be difficult to get an overview of an entire worksheet, especially if you're working on a smaller...

What is Paste Special in Excel? Everything You Need to Know

Paste special allows you to copy any cell or range of cells, and paste specific characteristics from those cells, it is also one of the...

Excel's Secret Formula: =DATEDIF( )

An easy way to find the number of days, months, or years between two dates.

How to Perform Mathematical Operations Using Paste

How to add, subtract, multiply, and divide any size range without the need to create extra columns. All with paste.