Recent Posts

Excel freezing or showing 'Not Responding'? Here's why it happens and the fastest ways to fix it.

Excel crashes can be terrifying. Here's exactly what happens to your unsaved work and how AutoRecover actually works.

Not sure which version of Excel you're running? Here's exactly where to look in under 30 seconds.

Not sure which Excel file format to save as? Here's how to pick the right one for your situation.

Yes, Excel can find duplicates in several ways. Here's how to highlight, count, and remove them fast.

Yes, but not directly. Here's the easiest way to open an Apple Numbers file in Excel without losing your data.

Yes, Excel can solve for x. Learn how to use Goal Seek to back-solve any formula for an unknown variable in just a few clicks.

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

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

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

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

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

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

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

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

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

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

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

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

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