Excel features articles

Learn how to create a data entry form in Excel with the built-in Form tool, a VBA UserForm, Power Automate, or macros, plus examples and templates to start.

Learn how to combine rows in Excel and sum duplicate values with the Consolidate feature or a VBA macro. Each method comes with step-by-step instructions.

Here’s how to email an Excel spreadsheet: attach the whole workbook, share a link to it, or paste part of a sheet straight into the body of your email.

Why can’t I save my Excel file? Learn the most common Excel save errors, like read-only files, a full disk, or an invalid name, and how to fix each one.

Learn how to unshare an Excel file in Windows, the Excel desktop app, or OneDrive on the web, and why the Unshare Workbook button is greyed out.

Seeing the ‘locked for editing by me’ error in Excel? Learn what causes it and how to unlock Excel file for editing when it’s password-protected or shared.

When the sharing violation Excel error appears, you can’t save your changes. Here are five ways to fix the Excel sharing violation error in Windows.

Learn Excel file repair step by step. Fix a corrupted workbook with Open and Repair or a manual fix, try a third-party tool, or extract the data.

Learn how Excel notes differ from threaded comments, and how to add, edit, view, resolve, and delete comments and notes in Excel for Microsoft 365.

What is XLS? It is the Excel 97-2003 spreadsheet format. Learn what XLS means and how to open, create, convert, and repair XLS files.

Learn how to unhide columns in Excel, and how to hide columns and rows, with the right-click menu, the Format menu, and keyboard shortcuts.

Learn how to convert PDF to Excel for free with Power Query, copy and paste, Excel’s Data from Picture feature, or an online converter.

Learn how to create a dashboard in Excel step by step. Import and clean your data, then build it with pivot tables, slicers, and charts to track key metrics.

Split cells in Excel with the Text to Columns wizard, Flash Fill, TEXTSPLIT, or Power Query, and split merged cells too. Each method comes with step-by-step instructions.

To make Excel freeze top row and first column together, select cell B2 and click Freeze Panes. Learn to freeze more rows or columns and unfreeze them.