I often repeat formulas in worksheets. I know I can save them as macros and then insert them anytime with a few clicks, but I really don’t like macros. Is there an easy alternative? There is, but I ...

However, when you're creating a spreadsheet in Microsoft Excel, the double-click shortcut can be just as useful. In this guide, I'll share 11 of my favorite double-click Excel tricks. After typing a ...

To tell Excel 2007 to repeat one or more rows or columns, first chose the Page Layout tab in the Ruler, then Print Titles (in Excel 2003, choose File | Page Setup, then Sheet).

Multiplying an entire Excel column by the results of a formula can be a little tricky, especially if the formula is complicated or subject to change. To simplify to process, use an absolute ...

When you want to fill a column in Excel with a given formula or value, you can do it the old fashioned way (select cells or the column header, CTRL+V to paste) or use can do it the much faster way ...

As this formula is copied to the right, the COLUMN function references cells C1, D1, E1, and so on, which equates to columns 3, 4, 5, and so on, respectively. The result is that each time the formula ...

Duplicates in the same column are easy to find by sorting, filtering, and using conditional formatting. When none of those are an option, try this simple formula solution.