Last month I talked about how you can freeze rows or columns in an Excel workbook so that your headings stay visible on screen.  This month I’ll show you how you can choose rows or columns to appear on every page when you print. This lets you print a report heading and/or column/row headings on […]

Freeze Panes lets you keep row and columns headings visible as you scroll through a large spreadsheet.

Learn how to rank list entries in Excel without resorting your data.

See how to easily copy or move tab within or between workbooks.

Tired of looking up information on one spreadsheet just to manually enter it on another? You need to learn about VLOOKUP.

Excel’s Flash Fill is an amazing tool that combines elements of text-to-columns, concatenate, and find & replace. Not only is it powerful but it’s unbelievably simple to use.

Sometimes page breaks fall at inconvenient places in your spreadsheet. But you can do more than just adjust your margins. Excel allows you to insert and even move page breaks. I’ll show you two methods for controlling page breaks in your Excel workbooks. First we’ll cover the old-school method. It’s simple but effective. Just put […]

Many times on a project you have the right data, but in the wrong format. In this tip I’ll show you how you can break apart a single column of data into two or more columns in Excel using the Text To Columns feature.

In the general sense, a table is just data that you have arranged into columns and rows. But in Excel, when you use the Format As Table button to define an area on your spreadsheet as an Excel table, there are several things you’ll be able to take advantage of that make entering and working […]

While there are several ways to compare lists in Excel and highlight differences, an option in the Go To feature provides a really quick and simple method.