Wizard’s tips by email
Search this site
Topics
- Advice (11)
- Formulae explained (12)
- General (8)
- How to (33)
- Quick tips (18)
- Tools (8)
- Uncategorized (5)
Tags
- ACOS
- ADDRESS
- Chart
- COLUMN
- CONCATENATE
- Conditional format
- COS
- COUNTA
- COUNTIF
- Custom View
- Dates
- Dropdown
- Format
- Formulae
- Frequency
- IF
- INDIRECT
- LARGE
- MAX
- MID
- MOD
- Named ranges
- Navigation
- OFFSET
- Paste Special
- Percentages
- PivotTable
- PivotTables
- PRODUCT
- RADIANS
- RAND
- RANK
- Reference
- Ribbons
- ROUND
- ROUNDDOWN
- Shortcut
- Sorting
- Sudoku
- SUM
- SUMIF
- Syntax
- Text to columns
- Trigonometry
- VLOOKUP
Tag Archives: Shortcut
F4: repeat last action
For many things, F4 repeats the last thing you did, whether it's put a border on a cell, change its colour, insert a row, right-align etc. It's a bit hit and miss—it doesn't, for example, repeat data entry. But it's … Continue reading
Charting shortcut
If you select a range of data and hit F11, Excel will create a default chart on a new sheet based on that data. It's often useful as a throw-away action just to visualise how your data trends. Or you … Continue reading