Put | search
Click here to view Put news from 60+ newspapers.
Bookmark or Share- Create a drop-down list - Microsoft SupportLock or unlock specific areas of a protected worksheet. You can insert a drop-down list of valid entries (also called a drop-down menu or drop-down box) in Excel to make data entry easier, or to limit entries to certain items that you define.
- Transpose (rotate) data from rows to columns or vice versaIf you have a worksheet with data in columns that you need to rotate to rearrange it in rows, use the Transpose feature. With it, you can quickly switch data from columns to rows, or vice versa.
- Create a Map chart in Excel - Microsoft SupportCreate a Map chart in Excel. Applies To. You can use a map chart to compare values and show categories across geographical regions. Use it when you have geographical regions in your data, like countries/regions, states, counties or postal codes. Note: This feature is available if you have a Microsoft 365 subscription.
- Create, load, or edit a query in Excel (Power Query)Create, load, or edit a query in Excel (Power Query) Applies To. Power Query offers several ways to create and load Power queries into your workbook. You can also set default query load settings in the Query Options window.
- Combine text from two or more cells into one cellSelect the cell where you want to put the combined data. Type =CONCAT (. Select the cell you want to combine first. Use commas to separate the cells you are combining, use quotation marks to add spaces, commas, other text, or the ampersand symbol (&) with the next cell you want to combine.
More
