Usually we think about Excel saving us time by performing lengthy or repetitive calculations for us. But sorting is another great time saving feature. It can do simple sorting with just two clicks or more complex multilevel sorting with an easy to use tool. You can sort your whole worksheet or just selected cells. In [...]
Archive for category General Tips
Today’s tip is about how you can discover some of Excel’s power on your own. Built into Excel are many helpful tools called functions. Functions are shortcuts that make it easier for you to accomplish things that would otherwise require long, complex formulas. For example, the best known function is Sum. You’ve probably used it [...]
You probably know that you can hide columns or rows in an Excel spreadsheet simply by selecting one or more rows or columns (for simplicity, I’ll only talk about rows, but everything here applies to columns also), then right-clicking and choosing Hide. You can unhide them by selecting a range of rows that includes the [...]
This last installment on Excel’s Fill command explains how you can use it to distribute a long string of text evenly over multiple rows.
Last month we talked about how to use Excel’s Autofill feature to automatically fill in a series of words (like days of the week) or numbers. In order for the feature to work Excel needs to be able to recognize the series. So this month I want to show you how you can create your [...]
Excel’s Fill command lets you fill an adjacent group of cells with the same text or numbers, or with text or numbers that form a series. In its simplest form it’s like a faster version of copy and paste. For example, enter a name in cell A1, then highlight cells A1 through A5 and press [...]
Nobody likes to see #DIV/0!, Excel’s divide by zero error, on their spreadsheet. But there is no option to suppress it and sometimes your data makes the error inevitable. Fortunately you can use the IF function to hide or replace the divide by zero error message.
Using the Split feature allows you look at different parts of an Excel worksheet at the same time.
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.
Freeze Panes lets you keep row and columns headings visible as you scroll through a large spreadsheet.