Enter | search
Click here to view Enter news from 60+ newspapers.
Bookmark or Share- Create or change a cell reference - Microsoft SupportPress Enter, or, for an array formula, press Ctrl+Shift+Enter. : If you have a current version of Microsoft 365 , then you can simply enter the formula in the top-left-cell of the output range, then press ENTER to confirm the formula as a dynamic array formula.
- Create, load, or edit a query in Excel (Power Query)Select Enter Data to manually enter data. You might choose this command to try out the Power Query Editor independent of an external data source.
- 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.
- Using IF with AND, OR, and NOT functions in ExcelIn Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False.
- Look up values with VLOOKUP, INDEX, or MATCH - Microsoft SupportUse VLOOKUP, HLOOKUP, and other functions like INDEX and MATCH to search for and find data based on values you enter. This article gives you a quick VLOOKUP refresher, then links to more.
More
