Jim O | search
Click here to view Jim O news from 60+ newspapers.
Bookmark or Share- Enable or disable macros in Microsoft 365 filesTo revoke a trusted document, you need to clear all trusted documents. For more info, see Trusted documents. Tip: Rather than enabling macros for each document, you can create a trusted location to store trusted documents. Microsoft 365 will then not check them with the Trust Center.
- Using IF with AND, OR, and NOT functions in ExcelUse the IF function along with AND, OR and NOT to perform multiple evaluations if conditions are True or False. The value that you want returned if the result of logical_test is TRUE. The value that you want returned if the result of logical_test is FALSE. Here are overviews of how to structure AND, OR and NOT functions individually.
- Undo, redo, or repeat an action - Microsoft SupportYou 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.
- Group or ungroup data in a PivotTable - Microsoft SupportGroup or ungroup data in a PivotTable. Grouping data in a PivotTable can help you show a subset of data to analyze. For example, you may want to group an unwieldy list date and time fields in the PivotTable into quarters and months. Need more help? You can always ask an expert in the Excel Tech Community or get support in Communities.
- Turn off Scroll Lock - Microsoft SupportTo disable scroll lock, press the Scroll Lock key (often labeled as ScrLk) on your keyboard. If your computer does not have a Scroll Lock key, do one of the following: If your keyboard does not have a Scroll Lock key, on your computer, click Start > Settings > Accessibility > Keyboard. Click the On-Screen keyboard button to turn it on.
More
