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
- ADDRESS
- CLEAN
- CONCATENATE
- Conditional format
- copy
- COUNTIF
- COUNTIFS
- Custom View
- cut
- Data import
- Dollars
- Editing
- EXACT
- Fill
- filter
- Format
- Formulae
- Frequency
- HLOOKUP
- IF
- INDIRECT
- LEFT
- Mail Merge
- MID
- MIN
- MOD
- Navigation
- paste
- Paste Special
- PivotTable
- PivotTables
- RANK
- RIGHT
- ROUNDDOWN
- ROUNDUP
- Series
- Shortcut
- SMALL
- SUM
- SUMIF
- SUMIFS
- Text to columns
- TRIM
- VLOOKUP
- WEEKDAY
Tag Archives: Navigation
F2: the most useful key in Excel
F2 is probably the most useful key in Excel. Below's a description of what it does. It toggles between Edit mode and Enter mode. If you're navigating across the spreadsheet, hit F2 when you've settled upon a cell, and the … Continue reading →
Navigation: Zipping around the worksheet
When I take over someone's machine to help them out with Excel, whether remotely or in person, the first thing that wows them is the speed at which my cursor moves around the screen to accomplish the task at hand. … Continue reading →