Our best Excel guides for formulas, data tools, formatting, protection and printing.
Formulas and calculations
Add up columns, look up values and calculate percentages, dates and differences.
- How to Sum a Column in Excel
- How to Use VLOOKUP in Excel or Google Sheets
- How to Use a Percentage Formula in Excel
- How to Subtract in Excel (Cells, Columns, Dates and Percentages)
- How to Calculate Age and Date Differences in Excel
- How to Combine Columns Into One in Excel
- How to Combine First and Last Names in Excel
- How to Use IF-Then Formulas to Color Cells in Excel
Data tools and charts
Build pivot tables and charts, clean up duplicates and create drop-down lists.
- How to Create a Pivot Table in Excel
- How to Remove Duplicates in Excel
- How to Insert a Drop-Down List in Excel
- How to Remove Data Validation in Excel
- How to Make a Pie Chart in Excel (With Percentages)
- How to Add a Pop-Up Calendar to a Cell in Excel
- How to Count Colored Cells in Excel
Formatting
Color cells, apply conditional formatting and stop Excel changing your numbers.
- How to Use Conditional Formatting in Excel
- How to Color Cells in Excel
- Why Does Excel Keep Changing My Numbers to Dates?
- How to Keep a Trailing Zero in the Second Decimal Place in Excel
- How to Delete Data But Keep Formatting in Excel
- How to Insert a Picture Into a Cell in Excel
- How to Change the Default Font in Excel (Microsoft 365)
- How to Turn Off Automatic Hyperlinks in Excel
Rows, columns and cells
Merge, split, freeze, hide and resize rows, columns and cells.
- How to Merge Cells in Excel
- How to Split a Cell in Excel
- How to Freeze Panes in Excel
- How to Unhide Rows, Columns and Worksheets in Excel
- How to Add a Row in Excel
- How to Add a Column in Excel
- How to AutoFit Columns and Rows or Expand Row Groups in Excel
- How to Put Excel Column A on the Right Side
- Can I Resize a Single Cell in Excel?
- How to Change Excel Column Labels From Numbers Back to Letters (Excel 2013 and Later)
Protection and sharing
Lock cells, add a password, make files read-only and enable macros.
- How to Lock Cells in Excel
- How to Password Protect an Excel File
- How to Make an Excel Spreadsheet Read-Only for Others
- How to Make Excel Allow Multiple Users at the Same Time
- How to Enable Macros in Excel
Files and printing
Fit sheets on one page, print gridlines and titles, and manage workbooks.
- How to Fit a Spreadsheet on One Page in Excel
- How to Print Gridlines in Excel 2013 and Later
- Can I Repeat Rows in Excel When I Print? (Yes, Here’s How)
- How to Save One Sheet in Excel as a Separate File
- How to Restore a Deleted Worksheet in Excel
- How to Open an XLSX File
- How to Open CSV Files With Excel by Default
- Which Version of Microsoft Excel Am I Using? How to Check