- Ctrl + PgDown
- Ctrl + PgUp
- Ctrl + Tab
- Shift + Tab
No category found.
- Ctrl + PgUp
- Ctrl + PgDown
- Ctrl + Tab
- Shift + Tab
- Sort
- Filter
- Conditional Formatting
- Subtotal
- To color-code cells.
- To restrict the type of data or values that users enter into a cell.
- To automatically correct spelling errors.
- To analyze large datasets.
- SUMIF()
- COUNTIF()
- IF()
- VLOOKUP()
- AutoSum
- AutoFilter
- AutoFill
- AutoCorrect
- It adjusts the column width to fit the text.
- It allows text to extend beyond the cell boundary.
- It wraps long text within a cell so that it appears on multiple lines.
- It rotates the text within the cell.
- Pie Chart
- Bar Chart
- Line Chart
- Scatter Plot
- To combine multiple text strings into one.
- To split the contents of one cell into separate columns.
- To change the font color of text.
- To wrap text within a cell.
- Ctrl + 9
- Ctrl + 0
- Ctrl + Shift + 9
- Ctrl + Shift + 0
- Ctrl + 9
- Ctrl + 0
- Ctrl + Shift + 9
- Ctrl + Shift + 0
- Sort
- Filter
- Remove Duplicates
- Data Validation
- Shift + F11
- Ctrl + F11
- Alt + F11
- F11
- It changes when a formula is copied to another cell.
- It remains constant when a formula is copied to another cell.
- It refers to a cell on another worksheet.
- It refers to a cell in a different workbook.
- Data Validation
- Conditional Formatting
- Sort
- Filter
