Excel Xpert · Lesson 117
Approval forms, invoices, timesheets and purchase orders all end with a signature line, and most people print the file, sign it, and scan it back in. You can put your actual handwriting into the workbook once, lock it so nobody can drag it or copy it out, and skip that round trip entirely. Thirty seconds of video below, then the written steps.
The same free Excel Xpert companion workbook used in the video, one tab per lesson. No login, no email required.
There are two entirely different things people mean by signing a spreadsheet, and mixing them up causes real problems. The first is a picture of your handwriting placed on the sheet, which is what this lesson covers. The second is a digital signature, a certificate that cryptographically binds your identity to the file and breaks if anyone edits it afterwards.
The image approach is about appearance and convenience. It makes an approval form look signed, it saves printing and rescanning, and it works in every version of Excel with no setup. What it does not do is prove anything, because a picture can be copied out of one workbook and pasted into another by anyone who receives the file.
That is fine for internal approvals, timesheets and forms circulating inside a team where trust already exists. For a contract, an audit trail or anything a third party will rely on, use a digital signature or an e-signature service instead, covered further down this page.
Most of the work here is not inserting the picture, which takes one click. It is the cleanup: getting rid of the white box around the ink, keeping the signature from sliding around when someone filters a column, and locking it so it cannot be moved or lifted out of the file.
Six steps. The last two are the ones that separate a signature from a picture somebody can drag around.
Sign in dark ink on plain white paper, then scan it or photograph it straight on in good light. Capture it larger than you need, because shrinking a big image in Excel stays sharp while enlarging a small one goes blurry immediately.
Go to Insert > Pictures > This Device and choose the file. Use the crop handles on the Picture Format tab to trim away everything except the signature itself, which makes positioning far easier later.
With the image selected, open Picture Format > Color > Set Transparent Color, then click the white area. The white box disappears and only the ink remains, so the signature sits over a signature line rather than covering it.
Drag a corner handle rather than a side handle to keep the proportions, since a stretched signature is obvious at a glance. Holding Alt while dragging snaps the edges to the cell gridlines for clean alignment.
Right click the image and choose Size and Properties. Under Properties, select Don't move or size with cells. Without this, filtering a column or resizing a row drags the signature somewhere else on the sheet.
Leave the Locked property ticked in that same panel, then go to Review > Protect Sheet. The tick alone does nothing. Sheet protection is what actually enforces it, and until you turn it on the signature can be selected, moved or deleted by anyone.
| Question | Signature Image | Digital Signature |
|---|---|---|
| What is it | A picture of your handwriting | A certificate bound to the file |
| Proves who signed | No | Yes |
| Detects later edits | No | Yes, the signature invalidates |
| Can be copied out | Yes, by anyone with the file | No |
| Setup required | None | A digital certificate |
| Good for | Internal forms and approvals | Contracts and audited records |
Both have a place. The mistake is using the image where the digital signature was needed, which usually surfaces months later when somebody asks who approved a purchase order and the only evidence is a picture that could have been pasted in by anyone.
Doing this once rather than every time a form comes around.
Once the background is removed, right click the image and choose Save as Picture, then save it as a PNG. That file is now ready to insert into any workbook without repeating the cleanup, and PNG is the format that preserves transparency.
A transparent signature file sitting in a shared drive is a signature anyone in the company can apply to anything. Store it in a personal folder, not a team one, and treat it roughly the way you would treat a physical stamp.
If the same form circulates monthly, put the signature into the template with the sheet already protected. Everyone who opens it gets a signed, locked copy without needing the image file at all.
When a picture is not enough.
Go to Insert > Text > Signature Line and fill in the signer's name, title and instructions. Excel places a formal signature block that can be signed digitally later, which is the right choice for a document that will circulate for approval.
With a digital certificate installed, File > Info > Protect Workbook > Add a Digital Signature binds your identity to the file. Any edit afterwards invalidates the signature, which is exactly the property a picture cannot provide.
Exporting to PDF keeps the signature visible while making it far more awkward to extract and reuse. For anything leaving the company, this is the minimum precaution worth taking.
The Locked property does nothing on its own. Until Review > Protect Sheet is turned on, the signature can be clicked, dragged, resized or deleted like any other picture.
An untreated scan covers the signature line and any borders underneath it. Set Transparent Color takes two clicks and is the difference between looking signed and looking pasted.
Enlarging a low resolution capture produces soft, pixelated ink that looks worse than no signature at all. Capture large and scale down, never the reverse.
Side handles stretch the image in one direction and the distortion is instantly visible in handwriting. Always use a corner handle.
Anyone who receives the file can right click the signature, save it, and apply it to something you never approved. Send a PDF for anything going outside the team.
A picture carries no proof of who added it or when. For contracts and audited records, use a digital signature or an e-signature service rather than assuming the image will hold up.
An approval is a record of who decided what, not a picture of handwriting.
Free 14-day trial. No credit card required.
Sign a blank sheet of paper, photograph or scan it, then use Insert > Pictures to place the image in the workbook. Crop it, remove the white background, size it over the signature line and lock it in place.
Select the image, open the Picture Format tab and choose Color, then Set Transparent Color, and click the white area. For an uneven scan, Remove Background gives a cleaner result.
Right click the image, choose Size and Properties, and under Properties select Don't move or size with cells. The signature then stays put when rows and columns change.
Leave the image's Locked property ticked in Size and Properties, then protect the worksheet from the Review tab. Protection is what actually enforces the lock, since the tick alone does nothing.
A pasted picture of a signature carries no cryptographic proof of who added it or when. For anything that needs to hold up, use a digital signature or a dedicated e-signature service instead.
An image is a picture of your handwriting and proves nothing. A digital signature uses a certificate to bind the signer's identity to the file and flags the signature as invalid if the workbook is edited afterwards.
Go to Insert > Text > Signature Line, fill in the signer's name and title, and Excel places a formal signature block that can be signed with a digital certificate.
The source image was too small and got scaled up. Scan or photograph the signature large, then shrink it in Excel, because reducing a big image stays sharp while enlarging a small one does not.
Save the cleaned up image as a transparent PNG in a known folder and insert that file each time, or add it to Quick Parts in Word for a reusable block. Keep the file somewhere private.
Yes, if the image sits inside the print area. Check Print Preview, since a picture positioned near the edge of a page often prints cut off or lands on a second page.
The Insert Pictures route is the same, and Preview on macOS can capture a signature from the trackpad or camera and save it as a transparent PNG ready to place.
Be careful, because anyone receiving the file can copy the image out and reuse it. Send a PDF rather than the workbook, and protect the sheet before sharing.
Every business starts with a spreadsheet. Updoot is where you scale past it, with approvals tied to real people instead of pasted images.
Start Your Free Trial →