This formula subtracts the number in workbook 2 from the number in workbook 1. Replace the workbook title, sheet name and cell to match the information you previously wrote down.

You don’t need to manually re-enter Excel spreadsheet data in another workbook. Learn how to copy a worksheet to another workbook here.

Microsoft Excel’s Name box is a powerful tool for its size. Use it to move around, create range names and even enter functions.

Microsoft designed Excel with a method for naming cell ranges and columns to simplify writing and interpreting formulas. You can apply column names to a single worksheet or increase the scope and ...

Often we need to carry out manipulations in Excel documents and apply them to multiple rows, columns and sheets. To do this manually takes too much time and allows for errors to creep in, so Excel ...

Microsoft Excel's alternative to this time-saving tool is somewhat unimaginatively called "names," accessed through the name box in the top-left corner of your workbook.