- Page Up
- Page Down
- Home
- End
No category found.
- F5
- Shift + F5
- Ctrl + F5
- Alt + F5
- Ctrl + M
- Ctrl + C
- Ctrl + D
- Ctrl + X
- Ctrl + N
- Ctrl + S
- Ctrl + M
- Ctrl + D
- To create full-sized charts on a separate sheet.
- To insert small charts within a single cell to represent data trends.
- To apply conditional formatting.
- To animate cell values.
- SheetName!CellAddress
- SheetName.CellAddress
- CellAddress@SheetName
- CellAddress(SheetName)
- Shift + F3
- Ctrl + F3
- Alt + F3
- F3
- To find the maximum value in a range.
- To determine what input value is needed to achieve a desired output (goal).
- To highlight cells with specific values.
- To predict future trends.
- Moves one screen up in the current worksheet.
- Moves to the previous worksheet in the workbook.
- Moves to the previous workbook.
- Scrolls to the top of the current worksheet.
- Moves one screen down in the current worksheet.
- Moves to the next worksheet in the workbook.
- Moves to the next workbook.
- Scrolls to the bottom of the current worksheet.
- Alt + H, O, U, S
- Ctrl + H
- Ctrl + Shift + H
- Ctrl + W
- To create simple calculations.
- To summarize and analyze large datasets.
- To draw complex shapes.
- To check for spelling errors.
- Home
- Insert
- Review
- File (then Info)
- Ctrl + Home
- Ctrl + End
- End, Home
- Shift + End
- Alt + =
- Ctrl + =
- Shift + =
- F2
- Looks for a value in the leftmost column of a table, and returns a value in the same row from a column you specify.
- Looks for a value in the top row of a table, and returns a value in the same column from a row you specify.
- Adds values vertically.
- Validates data entry.
- #DIV/0!
- #NAME?
- #VALUE!
- #SUCCESS!
