A row-by-row formatting rule is as easy to apply as a column-by-column in Microsoft Excel, but you might not get the results you thought you would.

If you want to link multiple cells from another worksheet, you can use an array function, which lets you link a range of cells using one formula.

There are two other methods to use the Row function. Method one is to click the fx button on the top left of the Excel worksheet. An Insert Function dialog box will appear.

Excel macros let you automate repetitive tasks for substantial time savings. Here’s how to put them to work for you.

If your subtotaling rows are lost in a sea of worksheet data, use this simple conditional formatting technique to make those rows easy to spot.

Excel can send alerts based on spreadsheet data, but you'll need to write a macro to do it. We'll show you how.