If you don’t know how to make a copy of a sheet in Excel, you simply right-click the tab you’d like to copy and select the Move or Copy menu. To get Solver to work, you need to provide it with ...

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.

Microsoft Advertising Intelligence (MAI), the Excel add-on for keyword research and optimization, is getting an upgrade — jumping all the way from version 5.6 to version 8.