Archive for category General Tips

Keep Column Widths When Copying Cells in Excel

When you copy and paste cells on a spreadsheet, do you get tired of having to resize the columns where you pasted the cells?  There are two good ways to copy the column widths along with your data. Copying entire columns is the fastest and easiest way to copy contents and formatting at the same […]

SUM Cells Across Multiple Tabs in Excel

You probably know that you can use the Sum function to add up a range of cells. But did you know that you can specify a range that covers multiple tabs (worksheets) in your Excel workbook? EXAMPLE Let’s say you have a workbook that lists the month’s sales of each of your products. There is […]

Displaying Decimals versus Rounding in Excel

You can use number formats, such as the comma style or currency style, or the increase/decrease decimals buttons to control how many decimals Excel displays. These are convenient and can be very useful, but they can also lead to some embarrassing problems in how your numbers display. For example if you have 1.254 in cell […]

Distributing Text Over Multiple Rows in Excel Using Fill-Justify

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.

Creating Custom Autofill Lists in Excel

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

Using the Fill Command In Excel

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

Creating a Simple In-Cell Bar Chart in Excel using REPT()

Excel has some powerful features for creating graphs and charts, but sometimes they are overkill. Also, most charts give a view of your information that is completely separate from the original data. But if you have a list with numbers in Excel you can use the REPT() function to easily create a bar chart style […]

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.