If you don’t check this option, Excel will move the sheet and not create a copy. Figure B. Be sure to check the Create A Copy option. Click OK. Figure C. Now you have two identical sheets.

To pull data from another sheet in Excel, you may use one of the following methods depending on your needs: Use Cell References; Use the VLOOKUP function; Use the INDEX and MATCH functions; ...

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.

Excel 2007 Cheat Sheet; PowerPoint 2007 Cheat Sheet; If you’ve spent years getting to know Excel’s old interface, you’ll likely be frustrated at having to learn a whole new interface.

Familiarity. Microsoft Excel launched in 1982 (under the name Multiplan) as a basic, though reliable, spreadsheet software program -- that's steadily evolved to meet its consumers' needs.