Doing this tells Excel to add the June and July cell values to create a total. When people view the Total worksheet, they will see total sales for June and July in the worksheet's B1 cell.

Microsoft Excel displays all cell references by default. When you click on a cell, its column and row references are highlighted in the worksheet's column and row headings.

Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don't want to change the cell references.

Locking cells in a Microsoft Excel spreadsheet is among the most commonly used functions. Here’s a guide on how to lock cells in Excel.

The reference created using the INDIRECT function will stay the same, even if your sheet's structure changes. By default, references in Excel use the A1 reference style, which means that it refers to ...

Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets.

Learn how to create a drop-down list using Data Validation in Excel. Data Validation limits the type of data that can be entered into a cell.

Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.

Create a drop-down list by selecting a range of cells The most common way to create a drop-down list in Excel with multiple selections is by using a range, which relies on using data from other cells.