Excel 2024: Simultaneously Edit a Workbook in Microsoft 365 »
MrExcel Publishing
by
1w ago
After Google's spreadsheet product began offering the ability for multiple people to edit the same worksheet, the Excel team spent over two years developing a feature that they call co-authoring. The feature was released to Office 365 customers in the summer of 2017 ..read more
Visit website
Excel 2024: Save Filter & Sorting in Sheet View »
MrExcel Publishing
by
1w ago
Do you share a workbook with co-workers? Does you co-worker want to Filter or Sort the workbook differently than you do? Eight years ago, I was ready to strangle my co-worker Scott when he kept filtering our project list to show only his projects ..read more
Visit website
Excel 2024: New Threaded Comments Allow Conversations »
MrExcel Publishing
by
1w ago
Threaded comments debuted in 2018. When you insert a comment, Excel stores the comment, the author, the date, and time. When a co-worker sees your comment, they can click Reply and add a new comment to the same cell. Each set of comments lists the author, date, and time ..read more
Visit website
Excel 2024: Create Perfect One-Click Charts »
MrExcel Publishing
by
1w ago
One-click charts are easy: Select the data and press Alt+F1. What if you would rather create bar charts instead of the default clustered column chart ..read more
Visit website
Excel 2024: Paste New Data on a Chart »
MrExcel Publishing
by
1w ago
You might be responsible for updating charts every month, week, or day. For example, in my last job, a collection of charts were updated during the month-end close process. The charts would track progress throughout the year ..read more
Visit website
Excel 2024: Use Default Settings for All Future Workbooks »
MrExcel Publishing
by
3w ago
In a few minutes, you can teach Excel your favorite settings. Then, every time you create a new workbook with Ctrl+N or insert a new worksheet, the worksheet will inherit all of your favorite settings ..read more
Visit website
Excel 2024: Search While Using File Open »
MrExcel Publishing
by
3w ago
When you choose File, Open, Excel will show you a list of recently opened workbooks. The size of this list is controlled by File, Options, Advanced, Display. The maximum numbers of recent workbooks or folders is 50 ..read more
Visit website
Excel 2024: Show Changes From Last 60 Days »
MrExcel Publishing
by
3w ago
The Show Changes feature debuted in June 2021. For any workbook that is stored in OneDrive or SharePoint Online, Excel is tracking every change to the workbook. Changes are saved for 60 days ..read more
Visit website
Excel 2024: Filter by Selection »
MrExcel Publishing
by
1M ago
The filter dropdowns have been in Excel for decades, but there are two faster ways to filter. Most people select a cell in the data, choose Data, Filter, open the dropdown menu on a column heading, uncheck Select All, and scroll through a long list of values, trying to find the desired item ..read more
Visit website
Excel 2024: Total the Visible Rows »
MrExcel Publishing
by
1M ago
After you've applied a filter, say that you want to see the total of the visible cells ..read more
Visit website

Follow MrExcel Publishing on FeedSpot

Continue with Google
Continue with Apple
OR