Collaborate on Excel workbooks at the same time with co-authoring
You and your colleagues can open and work on the same Excel workbook. This is called co-authoring. When you co-author, you can see each other's changes quickly—in a matter of seconds. And with certain versions of Excel, you'll see other people's selections in different colors.
View or change the properties for an Office file - Microsoft Support
When you open a document from a document library in Word, Excel, or PowerPoint, you can edit and update these document library properties by clicking File > Info. All required properties from the document library are outlined with red borders on …
Check out, check in, or discard changes to files in a SharePoint ...
When you have the file checked out, you can edit it online or offline, and save it—multiple times, if necessary. When you finish editing and check the file back into the library, other people can see your changes and edit the file, if they have permission.
Restrict changes to files in Excel - Microsoft Support
If you don't want content reviewers to accidentally change a Word document or an Excel spreadsheet, you can use formatting and editing restrictions.
Edit cell contents - Microsoft Support
You can edit the contents of a cell directly in the cell. You can also edit the contents of a cell by typing in the formula bar. When you edit the contents of a cell, Excel is operating in Edit mode. Some Excel features work differently or are unavailable in Edit mode.
Share your Excel workbook with others - Microsoft Support
Share a workbook with others, right within Excel. You can let them edit the workbook or just view it. Select Share. Select permissions and then Apply. Add people. Type a message if you like. Select Send. If you uploaded the file, click the filename to open it. The workbook will open in a new tab in your web browser.
Add or remove items from a drop-down list - Microsoft Support
In this article, we'll show you how to do that depending on how the list was created. If you set up your list source as an Excel table, then all you need to do is add or remove items from the list, and Excel will automatically update any associated drop-downs for you. To add an item, go to the end of the list and type the new item.
Work together on Office documents - Microsoft Support
To edit, they click the command for editing in the Office for the web program. When you are editing a file in Office you might see notification that others are working in the file too. There is no special trick to begin working together on a document.
Save a copy before editing to prevent changing the original file
Before Microsoft 365, you would edit a file and then use Save As to save your changes as a new document. These days with AutoSave, your changes are always being saved so you won't lose your work.
Use the Selection pane to manage objects in documents
On the Home tab, choose one of the following in the Editing group. In Word or PowerPoint, choose Select and select Selection Pane or Alt + F10. In Excel, select Find & Select and choose Selection Pane or Alt + F10. The Selection pane displays the name of each inserted object with the numbered order each was inserted.
Undo, redo, or repeat an action - Microsoft Support
You can undo, redo, or repeat many actions in Microsoft Word, PowerPoint, and Excel. You can undo changes, even after you have saved, and then save again, as long as you are within the undo limits (By default Office saves the last 100 undoable actions). To undo an action press Ctrl+Z on your keyboard, or select Undo on the Quick Access Toolbar.