Excel features articles

Learn how to lock cells in Excel to stop accidental edits, plus how to protect a sheet and lock formulas, with steps for Windows and Mac.

Discover what Excel version control is, the version control features Excel has to offer, and how to use them to share, merge, and review Excel changes.

Learn how to remove password protection from Excel: unlock a file or a sheet when you know the password, and what to try if you’ve forgotten it.

Learn the Excel reference another sheet formula and how to pull a cell, a range, or whole columns from another worksheet or another workbook.

There are many ways to combine multiple columns into a single column in Excel. Here’s how to do it without losing any data.

Learn how to use macros in Excel to automate repetitive tasks: record a macro, save it as a macro-enabled template, and run it on new data.

Learn how to insert an Excel hyperlink to another sheet, cell, or website with the Insert Hyperlink command or the HYPERLINK function, and how to remove it.

Learn how to share Excel file for multiple users with OneDrive, protect a shared workbook, and choose who can edit it in Microsoft 365.

Learn how to unlock cells in Excel. Unprotect the sheet, unlock only the cells you need while the rest stay locked, and see what to do without the password.

If you received an Excel file you’d like to edit but it’s read-only, there are ways to work around it. Here’s how to remove read-only in Excel.

Learn how to remove duplicates in Excel with the Remove Duplicates button, Advanced Filter, the UNIQUE function, conditional formatting, and Power Query.

Learn how to remove blank rows in Excel with keyboard shortcuts or the Filter, Find, Go To Special, and Sort commands, with step-by-step screenshots.

Power Automate Excel examples: learn how to get data from an Excel file with a flow, export Excel rows to a SharePoint list, and the limits to plan for.

Learn how to add an Excel header and footer with a preset or your own text, such as page numbers, the date, the file name, or a company logo.

How to sign in Excel: insert a Signature Line, sign it with your name or an image, add an invisible digital signature, and remove a signature.

Realizing the edits that you’ve been making to a file are all wrong is frustrating. Here’s how to restore the previous version of an Excel file.

Learn how to co author in Excel: save your workbook to OneDrive or SharePoint, share it with your team, and work around the feature’s limitations.

Learn how to use queries and connections in Excel with Power Query. Import data from one or more sheets, set refresh options, and remove a query.

Learn conditional formatting in Excel, from built-in highlight rules to writing an Excel conditional formatting formula with COUNTIF, AND, or another cell.

Learn how AutoRecover works in Excel, where to find your Excel auto recovery file location on Windows and Mac, and how AutoSave and AutoBackup help.

There are a variety of methods to compare Excel files or sheets and identify differences. Here’s how to compare two Excel files or sheets.

SharePoint allows you to share and collaborate with others on the same work online. Here’s how to import and export from SharePoint to Excel and vice versa.

Learn how to aggregate data in Excel with the AGGREGATE function, which can skip errors and hidden rows, or with Group By in Power Query.

Data can suddenly change when multiple people work on a shared Excel file. Here’s how to use Excel sheet view to create a temporary view that won’t change.

How to find circular reference in Excel: use Error Checking to list the cells, then trace precedents and dependents to break the loop.

Learn what data entry automation is, its main benefits, and how to automate data entry in Excel with a VBA form or a Power Automate flow.

If you have various Excel files but would like to access the data in one centralized worksheet, this guide is for you. Here’s how to consolidate data in Excel.

Once you connect your Excel file to an external data source, you simply have to refresh for the most recent data. Here’s how to use Excel connections.

Many Excel tasks are repetitive and time consuming. Learn spreadsheet automation in Excel with VBA macros, Power Automate, and Sheetgo’s AI workflows.

Here’s how to lock Excel file content in 5 ways: Mark as Final, a password, read-only mode, workbook structure protection, and locked cells.