Excel Tools
Total Guides
20
Free step-by-step tutorials
Topics Covered
6
Basics · Print · Group · Data
Last Updated
Sep 2026
Excel 365 / 2026 verified
Cost
Free
No sign-up required
All Guides 20
Sheet Basics 7
Printing 2
Grouping 3
Protection 4
Data Tools 4
| Guide | Category | Level | Best For | Action |
|---|---|---|---|---|
Lock cells in 3 steps |
Protection | Beginner | Lock layouts & formulas | Open → |
With or without password |
Protection | Intermediate | Recover protected sheets | Open → |
+ icon & Shift+F11 shortcut |
Sheet Basics | Beginner | Insert new sheets fast | Open → |
3-second duplicate method |
Sheet Basics | Beginner | Duplicate templates | Open → |
Safe deletion & recovery |
Sheet Basics | Intermediate | Remove sheets safely | Open → |
Hide & unhide sheets |
Sheet Basics | Beginner | Hide tabs safely | Open → |
3 ways + naming rules |
Sheet Basics | Beginner | Rename sheets fast | Open → |
15+ keyboard shortcuts |
Sheet Basics | Beginner | Work faster without the mouse | Open → |
Mac-specific steps |
Sheet Basics | Beginner | Delete sheets in Excel for Mac | Open → |
Format, preview & fix |
Printing | Beginner | Clean printouts | Open → |
Fit Sheet on One Page |
Printing | Beginner | Fit a sheet to 1 page | Open → |
Edit multiple sheets at once |
Grouping | Beginner | Batch edit / format / print | Open → |
Direct answer: how do you? |
Grouping | Beginner | Fast answer format | Open → |
Fix "Group" stuck issue |
Grouping | Beginner | Exit group mode | Open → |
Consolidate, VSTACK & VBA |
Data Tools | Advanced | Merge sheets into one | Open → |
Move or Copy & VBA |
Data Tools | Intermediate | Merge files into one workbook | Open → |
Side-by-side & audit |
Data Tools | Intermediate | Diff two sheets | Open → |
Search techniques & verify |
Data Tools | Intermediate | Locate data fast | Open → |
Fix gray button & very hidden |
Protection | Intermediate | Recover hidden sheets | Open → |
Direct answer: how do you? |
Protection | Beginner | Fast answer format | Open → |
Showing all 20 guides · Free forever
1
More Worksheet Libraries
Disclaimer: These guides are for informational and educational purposes only, fact-checked against Microsoft's official Excel documentation. Last Updated: September 2, 2026.