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.

Cell (reference): A cell is an Excel box that is distinguished by the gridlines, and each cell edge is a row or column line. Each cell contains its own data and has its own reference.

By default, cell references in Microsoft Excel are relative. Remember that a cell reference is basically a cell address, like how you get to the cell (e.g., A2).

Excel will automatically adjust the cell references in the INDIRECT functions, allowing the drop-down lists to function independently in each row.

Press Ctrl+C. Press Esc. Select the destination cell, F3, and press Ctrl+V. As you can see in the data set to the right in Figure A, both expressions reference the same cells, B3 and C3.

Now, let’s create a dropdown on another sheet named Dropdown and reference Animals_List : Create a second sheet and name it Dropdown (strictly speaking, it isn’t necessary to name this new sheet).

For deeper dives, check out my earlier articles on creating relational tables and creating relational databases. How to create an Excel table 1. First, enter the field names in the columns across ...