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.

The new user interface in the latest version of Microsoft Excel changes all the rules. Here's how to find your way around and get the most out of Excel 2007.

All details in this article are correct as of 30 June 2025. Accessibility to some of the latest Excel features depends on ...

However, Microsoft Excel grants you the convenient option in Chart Tools to move this chart to a new sheet, which also enlarges it for easier viewing. Click anywhere on the chart. This opens the ...

Learn to use the best new features in Excel for Microsoft 365 in Windows. Topics Spotlight: AI-ready data centers; ... then click the New button in the Sheet View area at the far left.

Load Microsoft Excel. Click the "File" or "Office" button (it varies according to your version of Excel) on the main menu. Select "New" from the list of options, which brings up a dialog box.

In this post, we will show you how to pull data from another sheet in Excel. While copying and pasting data is simple, pulling data from one sheet to another offers significant advantages in Excel.