Content
AI summary
Key Excel shortcuts include showing defined names in tables with fn + F3, converting data to a table using Command + A, displaying sheet formulae with Control + ~, and showing cell formulae with Fn + F2. Additional shortcuts include formatting cells with Control + 1 and repeating the last action with F4. Links to new Excel functions and categorized function lists are also provided.
Status
In progress
Show define names in Excel Tables | Press fn + F3 key |
Select the Data and Turn it to Table: | Command + A , Select the insert , Select table |
Show Sheet Formulae: | Control + ~ |
Show Cell Formulae | Press Fn + F2 |
Show Format Cell: | Control + 1 |
Repeat the last action | Press F4 |
To go down/up/left/right after cell selection | : Control + Shift + Down |
Excel Functions 365 New Functions
Excel Reference - Microsoft Office Add-ins and Consultancy. One website for all Microsoft Office Users and Developers.
bettersolutions.com
Excel functions (by category) - Microsoft Support
Lists all Excel functions by their category, such as Logical functions or Text functions.
support.microsoft.com
Excel functions (alphabetical) - Microsoft Support
A complete list of all Excel functions in alphabetical order.
support.microsoft.com
