Excel Tools for Teachers
Grading spreadsheets, attendance sheets, parent-teacher reports: these free Excel macros automate the repetitive admin so you can spend more time teaching. Works on the school laptop without IT involvement.
Tools for Teachers
Add Prefix and Suffix to Cells
Bulk-add text to the start and/or end of every cell in your selection, with formulas left untouched
AutoFit All Columns on All Sheets
Run AutoFit on every column of every visible sheet so the workbook is consistently readable in one click
Bulk Add Hyperlinks
Convert every URL-like cell in your selection into a clickable hyperlink in one pass
Bulk Find and Replace From Table
Read a 2-column table of find/replace pairs and apply every pair to your data range in one pass
Change Case to UPPERCASE or lowercase
Convert every text cell in your selection to UPPERCASE or lowercase in a single click
Convert Hyperlinks to Plain Text
Extract the URL from each hyperlinked cell and replace the cell content with the plain URL text
Convert Text to Proper Case
Capitalize the first letter of each word in your selection and lowercase the rest, in place
Count and Sum Cells by Color
Count how many cells share a background color, and sum them when they're numeric, with one click
Count Words and Characters Per Cell
Add word and character counts to the two columns next to your text column in one pass
Delete Empty Columns
Remove every column in your selection where all cells are empty or whitespace-only
Find and Replace Across All Sheets
Replace text in every worksheet of your workbook in one go, with case and whole-cell options
Freeze Top Row on All Sheets
Apply Freeze Panes at row 2 to every visible sheet in the workbook so headers stay visible during scrolling
Highlight Blank Cells
Color every blank or whitespace-only cell in your selection light red so missing data is visible at a glance
Highlight Duplicate Values
Color every cell whose value appears more than once in your selection
Highlight Top and Bottom Values
Color the top N values green and the bottom N values red in your selection in one click
Insert Row Numbers
Fill the selected column with sequential integers starting at any number, no formulas, no fill-handle dragging
Letter Grade From Numeric Scores
Convert a column of numeric scores into letter grades using a configurable A/B/C/D scale
List All Sheet Names
Generate an index sheet at position 1 with a hyperlinked list of every other sheet in the workbook
Remove All Formatting
Strip all colors, borders, fonts, and number formats from your selection while keeping values and formulas intact
Remove Blank Rows
Delete every row in your selection where every cell is empty or contains only whitespace
Remove Line Breaks From Cells
Strip newlines and tabs from text cells, replacing them with spaces and collapsing extra whitespace
Remove Special Characters
Strip non-alphanumeric characters from text cells in your selection, with options to keep spaces and basic punctuation
Sort Sheets Alphabetically
Reorder every tab in the active workbook A to Z or Z to A in one click
Split Cell on Delimiter
Split each cell in a column on any delimiter you choose, writing the parts to columns to the right
Split Full Names Into First and Last
Take a single column of full names and split it into First Name and Last Name columns to the right
Swap Two Columns
Swap the data in two columns in one click, supporting both adjacent and Ctrl-clicked non-contiguous columns
Transpose Rows and Columns
Copy your selection and paste a transposed version (rows become columns and vice versa) at the cell you pick
Trim Whitespace From All Cells
Strip leading, trailing, and extra internal whitespace from every text cell in your selection
Unhide All Sheets
Make every hidden and very-hidden sheet in the workbook visible at once
Unmerge Cells and Fill Down
Unmerge every merged cell in your selection and copy the value into all the cells the merge used to span