Archive for category General Tips

Switching Between Open Excel Workbooks

You may already be familiar with using Alt+Tab to switch between open windows. But the more windows you have open the less efficient that becomes. If you’re working in Excel and you want jump to another Excel workbook that’s already open you can bypass all the other programs that are running and just switch between […]

Hide Divide By Zero Errors in Excel Using IF

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.

Use the Split Button to Divide an Excel Worksheet Into 2 or More Viewing Panes

Using the Split feature allows you look at different parts of an Excel worksheet at the same time.

Change the Case of Text in Excel

Text copied or imported onto a spreadsheet may not be capitalized the way you want. Or if several different people work on the same spreadsheet you may get some people typing in all caps while others use normal capitalization. Excel doesn’t have a Change Case button like Word does, but you don’t have to copy your text to Word to change case and copy it back. Excel has three functions, UPPER, LOWER, and PROPER that you can use to change the case of text.

Use EXACT() to Compare Cells in Excel

Have you ever been frustrated staring at two lists trying to find the differences between them? Well if you have those lists in Excel it’s a simple job. If both lists are numbers you don’t even need to know any special functions, just subtract the number in one column from the number in the other […]

Add Numbers in Excel When They Meet Multiple Conditions using SUMIFS().

Have you ever wanted to add up only certain numbers within a list? Maybe it was sales over a certain dollar amount. Or you you have a list of payments and you want to know the total of all payments with a payment type of “Check”. If you only have one criteria for selecting the […]

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.