By default, Microsoft Excel's cells are named by their column-row references, like A1 or B2. However, you can assign a more specific name to a cell or range of cells to improve navigation, make ...

In this case, Excel will search for "Tablet" within the lookup range (A2:A5) and return the corresponding price from the result range (B2:B5). Note that the LOOKUP function performs an approximate ...

However, your Excel 2013 spreadsheet might also use named ranges that never change unless you manually adjust them. Changing these ranges apply to all formulas that use the named range. Changing ...

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

Open your spreadsheet in Microsoft Excel. Click the cell where you wish the total sum to appear. Type "=SUM(range1,range2,range3)" into the cell and replace "range#" with a range of data.