An Excel 2007 spreadsheet may contain very large quantities of data. Individual sections may be unimportant. For example, a sheet that lists your company's sales figures may include last year's ...

Learn how to switch between Excel worksheets using keyboard shortcuts, Watch Window, Activate Sheet, Name Box. Go To dialog box, Hyperlinks. VBA Macro.

Create a second sheet and name it Dropdown (strictly speaking, it isn’t necessary to name this new sheet). Select a cell — I selected B2. Click the Data tab.