.png)
BuildQuantify
Fast, practical shortcuts that save real time on takeoffs, estimates, and schedules — no formula-building required, just faster ways to do what you're already doing.
Ctrl + ; drops today's date into the active cell — faster than typing it, and useful for dating log entries or change orders.
Alt + Enter starts a new line within the same cell — handy for multi-line notes or addresses without widening the column.
Double-click the small square at the bottom-right of a cell (the fill handle) to copy that formula down automatically to match the length of an adjacent column.
Ctrl + Shift + L adds filter arrows to your header row in one shortcut — no need to click through the ribbon.
Press F4 while editing a formula to toggle a cell reference between relative and absolute ($A$1) — essential when referencing a fixed price list from a takeoff sheet.
Ctrl + Space selects the entire column; Shift + Space selects the entire row — quicker than dragging with the mouse.
Ctrl + E recognizes a pattern from one manually-typed example and fills the rest — great for splitting "Smith, John" into separate first/last name columns instantly.
View → Freeze Panes keeps your header row (or item names column) locked in place on a long takeoff sheet, so column labels never scroll out of view.
Ctrl + ` (the key above Tab) toggles the sheet to show formulas instead of results — useful for auditing a sheet before sending it to someone else.
Select a cell, type a name in the Name Box (top-left), then use that name in formulas — =Quantity*UnitPrice reads far clearer than =D2*E2 months later.
Ctrl + Alt + V → Values pastes just the calculated numbers, stripping out formulas — useful when sending a snapshot of totals without exposing your formula logic.
Alt + = auto-inserts a SUM formula for the column above the active cell — the fastest way to total a takeoff column.
Ctrl + 1 opens the Format Cells dialog directly — skip hunting through ribbon tabs for currency, borders, or number formats.
Data → Text to Columns splits a single pasted column (like "12 ft 6 in" copied from a PDF) into separate columns using a space, comma, or custom delimiter.
Select your header cells → Wrap Text + Merge & Center gives a printed takeoff sheet a professional look without manually resizing every column.
Want the deeper version of any of these? The full tutorials below walk through complete formulas step by step.
Browse all Excel Tutorials →