Automatic | search
Click here to view Automatic news from 60+ newspapers.
Bookmark or Share- Outline (group) data in a worksheet - Microsoft SupportTo create these, do one of the following: Use the Subtotal command, which inserts the SUBTOTAL function immediately below or above each group of detail rows and automatically creates the outline for you. For more information about using the Subtotal function, see SUBTOTAL function.
- How do I turn on AutoSave? - Microsoft SupportAutoSave is available when a file is saved to Microsoft OneDrive or SharePoint in Microsoft 365, but you need to save or open the file from within Excel, PowerPoint or Word to switch it on. You also need an active Microsoft 365 subscription.
- Create a list of sequential dates - Microsoft SupportYou can quickly create a list of dates, in sequential order, by using the Fill Handle or the Fill command.
- Insert subtotals in a list of data in a worksheet - Microsoft SupportYou can automatically calculate subtotals and grand totals in a list for a column by using the Subtotal command. Important: Subtotals are not supported in Excel tables. The Subtotal command will appear grayed out if you are working with an Excel table.
- Automatically number rows - Microsoft SupportUnlike other Microsoft 365 programs, Excel does not provide a button to number data automatically. However, you can easily add sequential numbers to rows of data by dragging the fill handle to fill a column with a series of numbers or by using the ROW function.
More
