Turn generic columns into custom visuals by adding floating totals, nesting series, and layering simultaneous data labels.

You can easily hide and unhide columns in Excel by individually revealing hidden columns or using the "Format" option to unhide all hidden cells. Hiding columns is helpful, especially when working in ...

The Freeze feature in Excel allows you to scroll down through hundreds of rows and still see the original headers or field names in row 1, or scroll over hundreds of columns and still see the data ...

Sorts are a simple task in Microsoft Excel if all you need is an ascending or descending sort. Excel is smart enough that it can interpret the data range. Not all sorts are so easy. Fortunately, Excel ...

Excel's basic formulas work fine for simple calculations, but they quickly become cumbersome when you're dealing with complex data analysis. You end up with nested functions that are hard to read, ...

Learn how to easily hide and unhide columns, including the tricky column A, in Excel with this step-by-step guide. Hiding a column tucks data out of sight without interfering with its purpose. You ...

Many small businesses use Microsoft Excel for day-to-day accounting and other spreadsheet tasks. Occasionally, you might find it necessary to copy and paste a column of data from one Excel workbook to ...