Excel AI in 2026: What Copilot in Excel Actually Does
Copilot in Excel writes formulas, builds PivotTables and pulls in web data. What it does, what the licence costs, and the automation it can't start.
Excel
28 posts
8 Best AI Assistants for Excel (2026)
Two of these edit the workbook in front of you. The rest read a copy and hand you a new file. Which is which, and what happens to macros.
Claude for Excel: What the Add-In Does and Doesn't
Claude for Excel is an add-in with cell-level citations and formula-aware edits. What it handles, what it refuses, and the macro gap that matters.
Grok for Excel: What the Free Add-In Actually Does
xAI shipped Grok for Excel on July 20, 2026 as a free Microsoft 365 add-in. What it does in a workbook, how it pulls from your connectors, and its limits.
Airtable vs Excel: Database or Spreadsheet in 2026?
Airtable is a relational database and app builder; Excel is the deep analytical spreadsheet. Here's which to pick in 2026.
Google Sheets vs Excel: Which Spreadsheet Wins in 2026?
Google Sheets is a free, web-first spreadsheet built for real-time collaboration; Excel is the deep analytical powerhouse. Here's which to pick in 2026.
How to Export Contacts from Outlook (2026 Guide)
Export Outlook contacts to a CSV or Excel file, back them up, and move them to an iPhone — from new Outlook, Outlook on the web, classic Windows, and Mac.
How to Export Microsoft Forms to Excel (2026)
Export Microsoft Forms responses to Excel: open results as a workbook, get a live OneDrive copy that refreshes, and fix export and download issues.
Excel Row Limit: Max Rows & Columns Per Sheet (2026)
Excel worksheets hold 1,048,576 rows by 16,384 columns (column XFD) — about 17.2 billion cells. Here are the real limits and what to do with bigger data.
How to Concatenate in Excel (Combine Text from Cells, 2026)
Combine text from multiple cells in Excel: the & operator, the CONCAT and TEXTJOIN functions, adding spaces and commas, and joining a whole range with a delimiter.
How to Create a Drop-Down List in Excel (2026)
Add a drop-down list in Excel with Data Validation: build one from a typed list or a cell range, show an input message, allow blanks, and edit or remove the list.
How to Insert a Checkbox in Excel (2026)
Add checkboxes in Excel two ways: the new built-in Checkbox button in Microsoft 365, and the classic Developer-tab form control — plus how to link a checkbox to a cell and copy it down.
How to Lock Cells in Excel (2026)
Lock specific cells in Excel so they can't be edited: why locking needs sheet protection, how to unlock the cells people should still fill in, and how to protect and unprotect the sheet.
How to Merge Cells in Excel (2026)
Merge cells in Excel with Merge & Center, Merge Across, and Merge Cells — plus how to unmerge, keep all your data, and use Center Across Selection as a safer alternative.
How to Password Protect an Excel File (2026)
Password protect an Excel file with Encrypt with Password, set a separate password to open vs. modify, protect the workbook structure or a single sheet, and remove a password you no longer need.
How to Remove Blank Rows in Excel (2026)
Delete blank rows in Excel the safe way: use Go To Special to select blanks, filter them out, or sort them to the bottom — without deleting rows that only look empty.
How to Remove Duplicates in Excel (2026)
Remove duplicate rows in Excel with the Remove Duplicates tool, find them first with conditional formatting, dedupe by specific columns, or extract a unique list with the UNIQUE function.
How to Unhide Columns in Excel (2026)
Unhide columns in Excel by right-clicking, unhide column A with the Name Box, unhide all columns at once, and fix columns that won't reappear because their width is zero.
How to Use Conditional Formatting in Excel (2026)
Use conditional formatting in Excel to highlight cells by rule: highlight values, top/bottom items, data bars and color scales, formula-based rules, and how to manage or clear them.
How to Use INDEX MATCH in Excel (with Examples, 2026)
Learn INDEX MATCH in Excel: how the two functions work together, why it beats VLOOKUP, looking left, a two-way lookup with two MATCH functions, and error fixes.
How to Use SUMIF in Excel (with Examples, 2026)
Learn SUMIF in Excel: the syntax, text and number criteria, comparison operators, wildcards, summing a different column, and SUMIFS for multiple conditions.
How to Use the IF Function in Excel (with Examples, 2026)
Learn the IF function in Excel: the syntax, text and number tests, nested IFs, the IFS function, combining IF with AND and OR, and how to fix common errors.
How to Use VLOOKUP in Excel (with Examples, 2026)
Learn VLOOKUP in Excel step by step: the syntax, exact vs. approximate match, looking up data from another sheet, anchoring the range, and how to fix #N/A and #REF errors.
How to Use XLOOKUP in Excel (with Examples, 2026)
Learn XLOOKUP in Excel: the syntax, exact and approximate match, looking left, returning multiple columns, the built-in if_not_found argument, and how it beats VLOOKUP.
How to Wrap Text in Excel (2026)
Wrap text in Excel so long entries show on multiple lines inside one cell: the Wrap Text button, manual line breaks with Alt+Enter, adjusting row height, and common fixes.
How to Export a SharePoint List to Excel (2026)
Export a SharePoint list to Excel as a one-shot CSV or as a live Power Query connection — plus how to refresh it, export selected rows, and fix common formatting issues.
How to Export Airtable to Excel (2026 Guide)
How to export Airtable data to Excel, including CSV download from a view, encoding fixes, attachment handling, scripting exports, and live sync to Excel.
How to Export Asana to Excel (2026 Guide)
Step-by-step instructions for exporting Asana projects to Excel and CSV, covering project exports, My Tasks, JSON, and full workspace exports via the Asana API.