Blog
How to Add a Macro to Excel from a .bas File
To add a macro to Excel from a .bas file, press Alt + F11, right-click your project, choose Import File, pick the .bas, then save as .xlsm.
2026-09-08
How to Enable the Developer Tab in Excel
To enable the Developer tab in Excel, go to File > Options > Customize Ribbon and tick Developer under Main Tabs. On Mac, use Excel > Preferences.
2026-09-07
How to Record a Macro in Excel
To record a macro in Excel, enable the Developer tab, click Record Macro, name it, perform your steps, then click Stop Recording.
2026-09-05
XLSM vs XLSX: What the Difference Actually Means
XLSM stores VBA macro code and XLSX cannot. Only the file holding the macro needs to be .xlsm. The workbook holding your data can stay .xlsx.
2026-09-04
How to Delete or Edit a Macro in Excel
To delete a macro in Excel, press Alt + F8, select it, and click Delete. To edit one, click Edit, change the code in the VBA editor, and save as .xlsm.
2026-09-02
How to Run a Macro in Excel You Downloaded
To run a macro in Excel you downloaded, open the .xlsm, press Alt + F8, pick the macro by name, and click Run. Your own data can stay in its own file.
2026-09-01
How to Enable Macros in Excel When There Is No Enable Button
If Excel shows no Enable Content button, the file is blocked as internet-sourced. Right-click it, pick Properties, tick Unblock, then reopen it.
2026-08-31
Convert Text to Proper Case in Excel Without a Formula
To convert text to proper case in Excel without a formula, run the free macro; use =PROPER(A2) when you want a live helper column.
2026-08-25
How to Find Values in One Excel Column but Not Another
To find values in one Excel column but not another, use COUNTIF to flag missing matches or compare both lists with the free macro.
2026-08-24
How to Number Only Visible Rows in Excel
To number only visible rows in Excel, skipping hidden and filtered rows, use =SUBTOTAL(103,$A$2:A2). Drag-fill and ROW() both number hidden rows too.
2026-08-17
How to Remove Duplicates in Excel But Keep the Most Recent
To remove duplicates in Excel but keep the most recent row, sort your data newest to oldest by date first, then dedupe so the newest survives.
2026-08-16
How to Highlight Duplicates Between Two Columns in Excel
To highlight duplicates between two columns in Excel, select both and use Conditional Formatting's Duplicate Values rule, or a macro for a one-off check.
2026-08-12
How to Find All Merged Cells in Excel
To find merged cells in Excel, open Find and Replace, click Format, tick Merge cells on the Alignment tab, then click Find All to list every one.
2026-08-08
How to Clean Data Copied From a Website in Excel
To clean data copied from a website in Excel, strip the line breaks and special characters, cut the repeated junk, and trim the spaces with free macros.
2026-08-03
How to Categorize Credit Card Transactions in Excel
To categorize credit card transactions in Excel, clean the messy merchant names in bulk first, then a single VLOOKUP tags every row with its category.
2026-08-01
How to Clean Data for a Pivot Table in Excel
To clean data for a pivot table in Excel, unmerge labels, fix numbers stored as text, trim spaces, and remove blank rows and duplicates with free macros.
2026-07-28
How to Combine Grades from Multiple Sheets in Excel
To combine grades from multiple sheets in Excel, run a free macro that stacks every class section into one gradebook with a single header, ready to rank.
2026-07-24
How to Count Employees by Department in Excel
To count employees by department in Excel, run a free macro that returns the headcount and total salary per department in one pass, no PivotTable needed.
2026-07-20
How to Find Duplicate Payments in Excel
To find duplicate payments in Excel, build a key from vendor, amount, and date, then use a free macro to highlight the repeats so you can review each one.
2026-07-19
How to Reconcile Invoices and Payments in Excel
To reconcile invoices and payments in Excel, line up both invoice-number lists and run a free macro that highlights every unmatched row on each side.
2026-07-17
How to Summarize Survey Responses in Excel
To summarize survey responses in Excel, flag blanks, get the mean and median of ratings, break them down by group, and tally choices with free macros.
2026-07-15
How to Clean a Lead List in Excel Before Outreach
To clean a lead list in Excel, dedupe it, flag leads missing an email or phone, split names for personalization, and standardize numbers with free macros.
2026-07-14
How to Clean Up a Messy Employee List in Excel
To clean up a messy employee list in Excel, use free macros that standardize names, split them, clean phone numbers, and dedupe records in minutes.
2026-07-13
How to Unprotect All Sheets in Excel at Once
To unprotect all sheets in Excel at once, run a free macro that takes your password once and unprotects every tab, then reports any that failed.
2026-07-10
How to Highlight All Cells With Comments in Excel
To highlight all cells with comments in Excel, use Go To Special or a free macro that paints every cell holding a note green, so annotations stand out.
2026-07-09
How to Delete All Hidden Sheets in Excel at Once
To delete all hidden sheets in Excel at once, run a free macro that removes every hidden and very-hidden sheet after one confirmation prompt.
2026-07-08
How to Insert a Blank Row When the Value Changes in Excel
To insert a blank row when the value changes in Excel, sort your data first, then run a free macro that adds a blank row above each group in one pass.
2026-07-07
How to AutoFit All Columns on Every Sheet at Once in Excel
Excel has no built-in way to autofit all columns on every sheet at once. A free macro runs AutoFit on every column of every visible tab in one click.
2026-07-06
How to Freeze the Top Row on All Sheets at Once in Excel
Excel freezes panes one sheet at a time. To freeze the top row on all sheets at once, use a free macro that locks row 1 on every visible tab in one run.
2026-07-05
How to Count Words and Characters in a Cell in Excel
To count words and characters in Excel, use LEN for characters, a SUBSTITUTE formula for words, or a free macro that counts a whole column in one pass.
2026-07-03
How to Highlight Rows That Contain Specific Text in Excel
Highlight rows that contain specific text in Excel with a conditional formatting rule, or a free macro that colors every matching row in one click.
2026-07-03
How to Reverse the Order of Rows in Excel
To reverse the order of rows in Excel, use a helper column and sort, the SORTBY formula, or a free one-click macro that flips rows in place.
2026-07-02
How to Extract Numbers from Text in Excel (Free Macro)
Extract numbers from text in Excel with Flash Fill, an array formula, Power Query, or a free one-click macro that pulls every digit into the next column.
2026-07-01
AI Excel Macro Generator: Turn Plain English Into VBA (Free)
Type the macro you need in plain English. Our AI writes the VBA, validates it, and hands you a working .bas file you can paste into Excel.
2026-05-01
How Finance Teams Clean a Monthly Bank Export in Excel
Bank exports come messy: text dates, leading apostrophes, header junk, blank rows. Five Excel macros turn a 20-minute cleanup into about 90 seconds.
2026-04-30
The Complete Guide to Cleaning Up Data in Excel
Pillar guide to fixing messy data in Excel: duplicates, blanks, mixed formats, dirty text. With free macros and tutorials for every common cleanup task.
2026-04-28
The Complete Guide to Excel Productivity Macros
Pillar guide to Excel productivity macros: workbook-wide operations, multi-sheet automation, navigation, and time-saving free macros for everyday work.
2026-04-28
Excel for Accountants: A Guide to Faster Month-End Close
How accountants use Excel for faster month-end close, cleaner reconciliations, and audit-ready workbooks. Free VBA macros for the repetitive bits.
2026-04-28
Excel for Finance Professionals: The Practical Guide
Practical Excel guide for finance pros: faster reconciliations, cleaner reports, free VBA macros for the repetitive parts of FP&A and treasury work.
2026-04-28
Excel for Students: A Practical Guide to Faster Coursework
Practical Excel guide for students: stats homework, data analysis projects, lab reports, and free VBA macros that work offline on the school laptop.
2026-04-28
Excel for Teachers: A Practical Guide to Saving Hours on Admin
How K-12 and university teachers use Excel for grades, attendance, and class admin. Free VBA macros for the repetitive parts of teaching paperwork.
2026-04-28
Excel Reporting: How to Build Faster, Cleaner Reports
Pillar guide to faster Excel reports: pivot summaries, totals rows, color-coding, descriptive stats, and free macros for the repetitive reporting steps.
2026-04-28
How to Use Excel VBA Macros Without Knowing How to Code
A practical guide to using Excel VBA macros even if you've never coded. How to install, run, and trust pre-built macros for routine Excel work.
2026-04-28
How to Add a Prefix or Suffix to Every Cell in Excel
How to bulk-add a prefix or suffix to Excel cells: concatenation formula, Flash Fill, and a free macro that adds both at once with text-format protection.
2026-04-28
How to Add Row Numbers in Excel
How to fill a column with sequential row numbers in Excel: fill-handle drag, ROW formula, SEQUENCE function, and a free macro that writes static integers.
2026-04-28
How to Add a Totals Row to a Table in Excel
How to add a totals row at the bottom of a table in Excel: SUM formulas, Total Row in formal Tables, and a free macro for plain ranges.
2026-04-28
How to Audit an Inherited Excel Workbook
Pillar guide to auditing inherited Excel workbooks: finding formulas, errors, hidden sheets, comments, and overrides. With free macros for each step.
2026-04-28
How to Calculate Letter Grades from Numeric Scores in Excel
Three ways to convert percentages to letter grades in Excel: the IF chain, the LOOKUP table, and a free one-click VBA macro with custom thresholds.
2026-04-28
How to Calculate Statistics for a Column in Excel
How to calculate mean, median, mode, and standard deviation for a column in Excel: built-in functions, Analysis ToolPak, and a free one-click macro.
2026-04-28
How to Change Text to UPPERCASE or lowercase in Excel
To change text to uppercase or lowercase in Excel, use UPPER and LOWER, Flash Fill, or a free macro that converts a whole column in place.
2026-04-28
How to Clean Phone Numbers in Excel (Format, Strip, Standardize)
Three ways to clean and standardize phone numbers in Excel: a SUBSTITUTE chain, Power Query, or a free macro that strips formatting in one pass.
2026-04-28
How to Combine Multiple Sheets Into One in Excel
A free macro that stacks every sheet in your workbook into a single Combined sheet, keeping just one header row at the top. Works on Windows and Mac.
2026-04-28
How to Convert Formulas to Values in Excel
How to replace formulas with their evaluated values in Excel: paste-special trick, keyboard shortcut, and a free macro that handles the whole sheet.
2026-04-28
How to Convert URL Text to Clickable Hyperlinks in Excel
Make a column of URL text clickable in Excel: the F2 trick, the HYPERLINK formula, and why converting a whole column needs a macro.
2026-04-28
How to Convert Text to Numbers in Excel (Five Real Methods)
How to convert numbers stored as text to real numbers in Excel: green-arrow trick, Paste Special multiply, VALUE formula, Power Query, and a free macro.
2026-04-28
How to Count and Sum Cells by Color in Excel
How to count or sum cells by background color in Excel: GET.CELL trick, custom UDF, and a free macro that reports count and sum in one click.
2026-04-28
How to Create a Pivot Table Quickly in Excel
How to create a pivot table in Excel: built-in PivotTable wizard, Recommended PivotTables, and a free macro that auto-pivots a category and value column.
2026-04-28
How to Create a Running Total Column in Excel
How to add a running total in Excel: SUM with absolute references, the Running Total in pivot tables, and a free macro that writes static values.
2026-04-28
How to Create a Table of Contents in Excel
How to create a clickable table of contents for a multi-tab Excel workbook: HYPERLINK formulas, manual list, and a free macro that does it in one click.
2026-04-28
How to Delete All Comments and Notes in Excel at Once
To delete all comments in Excel, select every sheet tab, then use Home > Clear > Clear Comments and Notes. Threaded comments and Notes differ.
2026-04-28
How to Delete Empty Columns in Excel Safely
How to delete empty columns in Excel safely: a formula to preview them first, why Go To Special deletes too much, and a free macro for the whole scan.
2026-04-28
How to Export Each Excel Sheet to a Separate CSV File
How to save every sheet of an Excel workbook as a separate CSV file: built-in Save As, Power Query, and a free macro that batches all tabs in one click.
2026-04-28
How to Extract Email Addresses from Text in Excel
How to extract every email address from a column of free-form text in Excel: regex, formulas, and a free macro that works on Mac and Windows.
2026-04-28
How to Extract URLs from Hyperlinks in Excel
How to extract the underlying URL from clickable hyperlinks in Excel: GET_URL trick, custom UDF, and a free macro that converts to plain text in one pass.
2026-04-28
How to Fill Blank Cells With the Value Above in Excel
How to fill blank cells with the value from the row above in Excel: F5 trick, Power Query, and a free macro that handles multiple columns safely.
2026-04-28
How to Find and Replace Across All Sheets in Excel
How to run Find and Replace on every sheet of an Excel workbook at once: built-in option, Power Query, and a free macro that reports the count.
2026-04-28
How to Find Blank Cells in Excel
How to find every blank cell in an Excel range: F5 Special trick, COUNTBLANK formula, and a free macro that highlights blanks for visual audit.
2026-04-28
How to Find Cells With Formula Errors in Excel
How to find every #REF!, #VALUE!, #N/A and other formula error in an Excel workbook: Go To Special, IFERROR formulas, and a free macro that lists them all.
2026-04-28
How to Find All Cells With Formulas in Excel
How to find every formula in an Excel sheet: F5 Special trick, Show Formulas mode, and a free macro that highlights all formula cells in light yellow.
2026-04-28
How to Highlight Duplicate Values in Excel (Four Methods Compared)
How to highlight duplicate values in Excel: Conditional Formatting, formulas, and a free macro. With pros, cons, and when to use each.
2026-04-28
How to Highlight Top and Bottom Values in Excel
How to highlight the highest and lowest values in Excel: Conditional Formatting Top 10 rule, RANK formula, and a free macro that flags both ends at once.
2026-04-28
How to Protect All Sheets With a Password in Excel
How to protect every sheet of an Excel workbook with the same password: built-in method, VBA loop, and a free macro that does both protect and unprotect.
2026-04-28
How to Remove All Formatting in Excel
How to strip all formatting (colors, borders, fonts) from Excel cells while keeping values: Clear Formats menu, paste-special, and a free one-click macro.
2026-04-28
How to Remove Blank Rows in Excel (Without Deleting Half Your Data)
How to remove blank rows in Excel safely: filter method, sort trick, F5 method, and a free macro that only deletes truly-empty rows.
2026-04-28
How to Remove Duplicate Rows by Multiple Columns in Excel
Excel's built-in Remove Duplicates checks whole rows. Here's how to dedupe by the columns that matter (name and email, but not phone) using a free macro.
2026-04-28
How to Remove Line Breaks from Cells in Excel
How to remove Alt+Enter line breaks from Excel cells: Find and Replace with Ctrl+J, CLEAN function, and a free macro that handles all whitespace at once.
2026-04-28
How to Remove Special Characters in Excel
How to strip emoji, symbols, and special characters from Excel cells: SUBSTITUTE chains, CLEAN function, and a free macro with three keep-modes.
2026-04-28
How to Sort Excel Sheet Tabs Alphabetically
How to sort sheet tabs in Excel A-to-Z or Z-to-A: drag-and-drop, VBA loop, and a free macro that handles 50+ tab workbooks in one click.
2026-04-28
How to Split a Cell on a Delimiter in Excel
How to split text in cells on any delimiter in Excel: Text to Columns wizard, TEXTSPLIT function, Power Query, and a free one-prompt macro.
2026-04-28
How to Split Full Names Into First and Last in Excel
How to split a column of full names into First Name and Last Name in Excel: Text to Columns, Flash Fill, formulas, and a free macro.
2026-04-28
How to Split a Sheet Into Separate Sheets by Column in Excel
How to split one Excel sheet into separate sheets by a category column: pivot filter, manual filter and copy, and a free macro that does it in one click.
2026-04-28
How to Standardize Mixed Date Formats in Excel
How to convert text dates in M/D/Y, D/M/Y, or Y-M-D formats into real Excel dates. DATEVALUE formula, Power Query, and a free macro.
2026-04-28
How to Swap Two Columns in Excel
How to swap two columns in Excel safely: cut-paste-with-shift method, the Shift drag, and a free macro that swaps without breaking formulas elsewhere.
2026-04-28
How to Transpose Rows and Columns in Excel
How to swap rows and columns in Excel: Paste Special transpose, TRANSPOSE function, Power Query unpivot, and a free macro that does it in one click.
2026-04-28
How to Trim Whitespace from Cells in Excel (Three Methods)
How to trim leading, trailing, and extra internal whitespace from Excel cells. TRIM formula, Find/Replace, and a free macro that fixes them all.
2026-04-28
How to Unhide All Sheets at Once in Excel
To unhide all sheets in Excel at once, Ctrl-click them in the Unhide dialog, run one line in the Immediate window, or use a macro for very-hidden tabs.
2026-04-28
How to Unmerge Cells and Fill Down in Excel
How to unmerge merged cells and fill the value down so your data pivots and filters cleanly. Manual method, F5 trick, and a free macro.
2026-04-28
The Complete Guide to CSV Imports in Excel
Pillar guide to importing CSV files into Excel: the import wizard, Power Query, and free macros that fix the typical post-import data mess.
2026-04-28