Archive for category General Tips

Excel Watch Windows

A watch window lets you monitor cells from different parts of a spreadsheet all in one spot.

Printing Selected Rows Or Columns On Every Page of an Excel Worksheet

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 […]

Keep Row and Column Headings Visible in Excel With Freeze Panes

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

Ranking List Entries in Excel

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

Copy or Move Tabs in an Excel Workbook

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

Automatically Look Up Data in Excel using VLOOKUP

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

Excel Flash Fill – The Data Entry Shortcut You’ve Been Looking For

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.

Forcing Page Breaks in Excel

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 […]

How to Split One Column into Multiple Columns In Excel

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.

Taking Advantage of Tables in Excel

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 […]