Excel Basics
How to Copy and Paste in Excel (the right way for each job)
Copy and paste cells with Ctrl+C and Ctrl+V, paste values only, keep column widths, drag-copy with Ctrl, and copy formulas without the references moving.
Learn Excel the easy way.
Short, plain-English tutorials on formulas, shortcuts, charts and everyday Excel tasks. No jargon. One idea per post.
Start here Get Daily One LessonLatest tutorials
Excel Basics
How to Unhide Sheets in Excel (one or all at once)
Unhide a hidden worksheet from the tab menu, unhide all sheets in one go in Microsoft 365, and what to check when Unhide is greyed out.
Excel Basics
How to Hide a Sheet in Excel (and hide it properly)
Hide a worksheet from the tab menu, hide several at once, and stop other people from unhiding it with Protect Workbook. Formulas keep working on hidden sheets.
Excel Basics
How to Rename a Sheet in Excel (double-click the tab)
Rename a worksheet by double-clicking its tab, the right-click menu or Alt+H+O+R — plus the characters Excel won't allow and how renaming affects formulas.
Excel Basics
How to Add a New Sheet in Excel (4 quick ways)
Insert a new worksheet with the + button, Shift+F11, the right-click menu or the ribbon — and how to add one in a specific place or add several at once.
Excel Basics
How to Delete a Sheet in Excel (and get it back)
Delete a worksheet from the tab menu or the ribbon, remove several at once, and what to do if you deleted the wrong one — because Ctrl+Z won't bring it back.
Excel Basics
How to Copy a Sheet in Excel (same file or another workbook)
Copy a worksheet in two seconds with Ctrl+drag, or use Move or Copy to put the copy in another workbook. Formats, formulas and column widths all come along.
Formulas & Functions
What-If Analysis in Excel: Scenarios, Goal Seek and Data Tables
Excel's three What-If tools compared: Scenario Manager for named sets of inputs, Goal Seek to work backwards, and Data Tables to see many results at once. When to use each.
Formulas & Functions
Excel Solver: find the best answer with several inputs and limits
Solver finds the best combination of inputs — maximum profit, minimum cost — while respecting limits you set. Turning it on, a worked product-mix example, and fixing 'no feasible solution'.
Showing 55–63 of 294 tutorials · Page 7 of 33
