How to Audit Someone Else’s Excel Workbook
Inherited a mystery workbook? Follow this forensic workflow to map sheets, trace formulas, expose hardcoded values, and document everything you find.
June 11, 2026
Excel Basics and General Knowledge
This category revisits Excel's core features, making it a great refresher for seasoned users or an ideal starting point for beginners. It covers basic operations, use of ribbons and toolbars, keyboard shortcuts, and more.
259 guides in this section
Latest guides
Excel for Freelancers: Invoices, Time Tracking, and Taxes in One Workbook
Build one Excel workbook that runs your freelance business: income log, invoices, time tracking, quarterly tax estimates, and a monthly dashboard.
June 11, 2026
Excel Interview Questions That Actually Get Asked (With Answers)
17 real Excel interview questions with model answers, from cell references to pivot caches - plus the trap hidden in each one that interviewers listen for.
June 11, 2026
Build a Project Tracker in Excel That Doesn’t Collapse at 50 Rows
Build an Excel project tracker that scales past 50 rows: structured tables, validated status columns, due-date formatting, and a COUNTIFS dashboard.
June 11, 2026
What Is Absolute Cell Referencing in Excel
Learn about absolute cell referencing in Excel and how it can be used to fix cell references when copying formulas. Gain a better understanding of Excel functions and improve your data analysis skills.
May 21, 2023
How to Adjust Row Height in Excel
Learn how to adjust row height in Excel with ease by following our step-by-step guide. Increase or decrease the height of your rows as per your data size.
May 21, 2023
How to Automatically Number Rows in Excel
Learn how to automatically number rows in Excel with our step-by-step guide. Save time and make your spreadsheet more organized with this simple trick.
May 21, 2023
How to Average a Column in Excel
Learn how to easily calculate the average of a column in Microsoft Excel with this step-by-step guide. This tutorial is perfect for beginners.
May 21, 2023
How to Center Worksheet Horizontally in Excel
Learn how to center your Excel worksheet horizontally with step-by-step instructions. Improve your Excel skills and make your documents look professional.
May 21, 2023
All excel basics and general knowledge guides by topic
Cells (83)
- What Is Absolute Cell Referencing in Excel
- How to Copy Multiple Cells in Excel
- How to Count Highlighted Cells in Excel
- How to Create a New Line in Excel Cell
- How to Cut a Cell Value in Excel
- How to Delete a Cell in Excel
- How to Divide Excel Cells
- What Is a Excel Cell
- How to Remove Cell Lines in Excel
- How to Remove Letters from a Cell in Excel
- How to Sum Cells in Excel
- How to Anchor a Cell in Excel
- How to Apply Total Cell Style in Excel
- How to Change Cell Color in Excel
- How to Clear Multiple Cells in Excel
- How to Combine Cells in Excel
- How to Combine Two Cells in Excel
- How to Copy Cells in Excel
- How to Copy and Paste Multiple Cells in Excel
- How to Count Blank Cells in Excel
- How to Count Colored Cells in Excel
- How to Count Number of Cells in Excel
- How to Delete Multiple Cells in Excel
- How to Deselect Cells in Excel
- How to Edit a Cell in Excel
- How to Edit a Cell in Excel Using Keyboard
- How to Enter a Cell in Excel with Keyboard
- How to Enter in Excel Cell
- How to Enter Within a Cell in Excel
- How to Expand Cells in Excel
- How to Fill Blank Cells with Value Above in Excel
- How to Fix Excel Cells
- How to Fixate Cells in Excel
- Which of the Following Identifies a Cell in Excel
- How to Freeze a Cell in Excel
- A Group of Cells Is Called What in Excel
- How to Hide Cells in Excel
- How to Hide Rows in Excel Based on Cell Value
- How to Highlight Multiple Cells in Excel
- How to Hit Enter Within a Cell in Excel
- How to Increase Cell Size in Excel
- How to Insert Cells in Excel
- How to Keep a Cell Constant in Excel
- How to Lock Cells in Excel When Scrolling
- How to Lock Certain Cells in Excel
- How to Lock the Excel Cell
- How to Lock Multiple Cells in Excel
- How to Make an Active Cell in Excel
- How to Make Cells Bigger in Excel
- How to Make Excel Cells the Same Size
- How to Make Multiple Lines in One Cell Excel
- How to Make One Cell Bigger in Excel
- How to Make Two Lines in One Cell in Excel
- How to Move a Cell in Excel
- How to Have Multiple Lines in Excel Cell
- How to Multiply Cells in Excel
- How to Multiply Two Cells in Excel
- How to Name a Cell in Excel
- How to Number Cells in Excel
- How to Outline Cells in Excel
- How to Protect a Cell in Excel
- How to Protect Cells in Excel Without Protecting Sheet
- How to Protect Certain Cells in Excel
- How to Refer Cell in Excel
- How to Remove Blank Cells in Excel
- How to Remove Empty Cells in Excel
- How to Remove Numbers from a Cell in Excel
- How to Return in a Cell in Excel
- How to Select Cells in Excel
- How Do You Select Multiple Cells in Excel
- How to Select Non-Adjacent Cells in Excel
- How to Selected Cells in Excel
- How to Separate Cells in Excel
- How to Shift Cells Down in Excel
- How to Start New Line in Excel Cell
- How to Subtract Cells in Excel
- How to Subtract Multiple Cells in Excel
- How to Sum Random Cells in Excel
- How to Swap Cells Excel
- How to Type Multiple Lines in a Cell in Excel
- How to Unhide Cells in Excel
- How to Unlock a Cell in Excel
- How to Wrap Cells in Excel
Rows (78)
- How to Adjust Row Height in Excel
- How to Automatically Number Rows in Excel
- How to Change Column to Row in Excel
- How to Change the Height of a Row in Excel
- How to Combine Rows in Excel
- How to Convert Row to Column in Excel
- How to Count the Number of Rows in Excel
- How to Count Rows in Excel
- How to Delete Every Other Row in Excel
- How to Delete Multiple Rows in Excel
- How to Delete Rows on Excel
- How to Alternate Row Colors in Excel
- How to Create a Total Row in Excel
- How to Delete Alternate Rows in Excel
- How to Delete Blank Rows in Excel
- How to Delete Empty Rows in Excel
- How to Delete Multiple Rows in Excel with Condition
- Which Excel Feature Allows You to Hide Rows
- How Does Excel Treat Criteria Entered on Different Rows
- How to Expand All Rows in Excel
- How to Fix a Row in Excel
- How to Flip Columns and Rows in Excel
- How to Freeze 2 Rows in Excel
- How to Freeze Multiple Rows and Columns in Excel
- How to Freeze Multiple Rows in Excel
- How to Freeze More Than One Row in Excel
- How to Freeze a Row and Column in Excel
- How to Freeze Second Row in Excel
- How to Freeze Selected Rows in Excel
- How to Freeze Specific Rows in Excel
- How to Freeze the Top Row in Excel
- How to Freeze Top Row and First Column in Excel
- How to Freeze Top Two Rows in Excel
- How to Freeze Two Rows in Excel
- How to Get Rid of Blank Rows in Excel
- How to Get Rid of Empty Rows in Excel
- How to Handle More Than 1048576 Rows in Excel
- How to Hide Rows in Excel
- How to Hide Rows in Excel Shortcut
- How to Highlight Multiple Rows in Excel
- How to Highlight a Row in Excel
- How to Insert Multiple Rows in Excel
- How to Insert New Row in Excel
- How to Insert a Row in Excel on a Mac
- How to Insert Rows in Excel
- How to Insert Total Row in Excel
- How to Keep a Row Fixed in Excel
- How to Lock First Row in Excel
- How Do You Lock a Row in Excel
- How to Lock a Row in Excel When Scrolling
- How to Make Every Other Row Shaded in Excel
- How to Make a Row a Header in Excel
- How to Make a Row Stay in Excel
- How to Make All Rows the Same Size in Excel
- How to Make the Top Row of Excel Stay
- How Many Rows Can Excel Handle
- How to Move Entire Rows in Excel
- How Do I Move a Row in Excel
- How to Move Rows in Excel Without Replacing
- How to Number Rows in Excel
- How to Pin a Row in Excel
- How to Remove Duplicate Rows from Excel
- How to Repeat Header Rows in Excel
- How to Repeat Rows in Excel
- What Are Rows in Excel
- How to Select Every Other Row in Excel
- How to Select Multiple Rows in Excel
- How to Separate Rows in Excel
- How to Shade Every Other Row in Excel
- How to Sum Multiple Rows in Excel
- How to Sum Rows in Excel
- How to Swap Rows in Excel
- How to Switch Columns and Rows in Excel
- How to Switch Row and Column in Excel Chart
- How to Switch Rows in Excel
- How to Switch Two Rows in Excel
- How to Unfreeze Rows in Excel
- How to Unhide a Row in Excel
Columns (61)
- How to Average a Column in Excel
- How to Change Width of Column in Excel
- What Is a Column on Excel
- What Is a Column Index Number in Excel
- How to Compare 2 Columns in Excel
- How to Copy a Column in Excel
- How to Count in Excel Column
- How to Delete a Column in Excel
- Why Are Excel Columns Numbers
- How to Unfreeze a Column in Excel
- How to Widen Columns in Excel
- How to Adjust Column Width in Excel
- How to Auto Fit Column in Excel
- How to Autofit Columns in Excel
- Can’t Insert Column in Excel
- How to Collapse Columns in Excel
- How to Combine Columns in Excel
- How to Combine Two Columns in Excel
- How to Compare Two Columns in Excel
- How to Delete Unused Columns in Excel to Reduce Size
- How to Expand All Columns in Excel
- How to Flip a Column in Excel
- How to Freeze Columns in Excel
- How to Freeze First Two Columns in Excel
- How to Freeze Multiple Columns in Excel
- How to Hide Columns in Excel
- How to Hide Columns in Excel Mac
- How to Hide Multiple Columns in Excel
- How to Highlight a Column in Excel
- How to Insert Column in Excel
- How to Insert a New Column in Excel
- How to Keep a Column Fixed in Excel
- How to Lock Columns in Excel
- How to Make a Clustered Column Chart in Excel
- How to Make a Column Stay in Excel
- How to Make Columns in Excel
- How to Make Columns Wider in Excel
- How to Make All Columns the Same Width in Excel
- How Many Columns in Excel
- How to Match Two Columns in Excel
- How to Move Columns in Excel
- How to Move Columns in Excel Mac
- How to Multiply a Column in Excel
- How to Name a Column in Excel
- How to Pin a Column in Excel
- How to Rename Columns in Excel
- How to Repeat Columns in Excel
- How to Select an Entire Column in Excel
- How to Select Multiple Columns in Excel
- How to Select Two Columns in Excel
- How to Select Whole Column in Excel
- How to Separate Columns in Excel
- How to Shift Columns in Excel
- How to Subtract Columns in Excel
- How to Subtract Two Columns in Excel
- How to Sum Columns in Excel
- How to Swap Columns in Excel
- How to Swap Two Columns in Excel
- How to Switch Columns in Excel
- How to Total Columns in Excel
- How to Unhide Column A in Excel
Workbook (10)
- How to Audit Someone Else’s Excel Workbook
- How to Share Workbook in Excel
- What Are Workbooks in Excel
- What Is Excel Binary Workbook
- How to Make a Copy of an Excel Workbook
- How to Mark a Workbook as Final in Excel
- How to Protect Excel Workbook
- How to Search an Entire Excel Workbook
- How to Unhide an Excel Workbook
- How to Unprotect an Excel Workbook
Spreadsheet (8)
Worksheet (7)
Excellent (5)
More guides (7)
- Build a Project Tracker in Excel That Doesn’t Collapse at 50 Rows
- Excel for Freelancers: Invoices, Time Tracking, and Taxes in One Workbook
- Excel Interview Questions That Actually Get Asked (With Answers)
- How to Delete a Worksheet in Excel
- How to Delete an Excel Spreadsheet
- How to Insert a New Worksheet in Excel
- How to Select All Spreadsheets in Excel
Explore other categories
- How To
- Basic Excel Operations
- Excel Formatting and Visual Adjustments
- Excel Formulas and Functions
- Excel Charts and Graphs
- Excel Data Analysis
- Excel Integration and Conversion
- Excel Macros and VBA
- Excel Data Validation and Conditional Formatting
- Excel Printing
- Excel File Management
- Excel Data Manipulation and Transformation
- Excel Date and Time Functions
- Excel Linking and Merging
- Excel Cell References and Ranges
- Excel Errors
- Excel Settings
- Excel Versions
- Excel and Other Software
- Excel Add-ins
- Form Controls and User Interaction
- Pivot Tables
- Working with Text
- Excel Tips and Shortcuts
- Excel Training