Excel’s Name box is a powerful tool for an ordinary dropdown. To find it, look to the left of the Formula bar. Usually, it displays the reference for the current cell as shown in Figure A.

To create a search field in a spreadsheet, you must first activate the Developer tools menu. To do this, go to Options > ...

Why You Should Always Name Ranges in Excel . You might be familiar with bookmarks in Microsoft Word, which are invisible way-points in specified locations of a document that you can jump to ...

How to Find Cells With Strikethrough in Excel. For a business leader, Microsoft Excel 2010 can be an invaluable tool for monitoring inventory, recording customer information or keeping track of ...

Check the "Headings" box in the ribbon's "Show" group. Click any cell. Excel highlights the relevant column heading and row heading in amber, and the cell reference appears in the Name Box.

Open the Excel spreadsheet to find the chart. Select the chart. Right-click on it and choose the Select Data option.; Select the data series from the Legend Entries box.; Click the Edit button ...

Unfortunately, you won’t find the “edit this cell” command listed in Excel’s keyboard customization section, so there’s no apparent way to change the shortcut.