Condense | search
Click here to view Condense news from 60+ newspapers.
Bookmark or Share- Aggregate data from a column (Power Query) - Microsoft SupportUsing Power Query, you can aggregate one or more columns of a related table. For example, you can aggregate the sum of order details for each order. Data Preview of the Orders table in the Northwind OData feed.
- Clean excess cell formatting on a worksheet - Microsoft SupportTo remove the excess formatting in the current worksheet, do the following: On the Inquire tab, click Clean Excess Cell Formatting. Choose whether to clean only the active worksheet or all worksheets. After excess formatting has been cleared, click Yes to save changes to the sheets or No to cancel.
- TEXTJOIN function - Microsoft SupportThe TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.
- Combine text from two or more cells into one cellCombine data using the CONCAT function. Select 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 and use quotation marks to add spaces, commas, or other text.
- Scale a worksheet - Microsoft SupportIn Excel, you can scale a worksheet for printing by shrinking or enlarging its size to better fit the printed pages. You can also scale a worksheet to fit the paper width of printed pages, or specify the number of pages that you want to use for the printed worksheet.
More
