How to Insert a Signature in Excel: Image and Digital Sign 2026

A spreadsheet without a signature feels half-finished. Maybe you are sending a quote, an invoice, a meeting agenda, or a contract draft — and the file looks somehow naked without the swoosh of a name across the bottom. The good news: Excel will let you add a signature in three quite different ways, and each one is the right answer for a different situation. The bad news: most guides treat all three as the same thing, which is how people end up pasting a photo of their John Hancock into a cell and calling it "signed".

The three approaches are: an image signature (you drop in a PNG or JPG of your handwritten name), a freehand drawing made on the Drawing tab (you sign with mouse, trackpad, or stylus right inside Excel), and a cryptographic digital signature line inserted from the Insert menu (you sign with a real certificate that proves who you are). The first two are about looks. The third is about legal weight.

This guide walks you through all three. We will cover when to use which, how to combine a sign-and-protect workflow so your signed file does not get edited the moment somebody else opens it, and how to remove a signature cleanly when something needs to change. By the end you should be able to look at any "please sign this Excel" request and know exactly which method fits.

Start with the obvious question. Which approach is right for the file in front of you? If the recipient just wants to see that you signed — a quote, a delivery slip, an internal approval form — image or freehand is fine. If the recipient needs to verify the signature against your identity, or the document might end up in a legal dispute, you need the digital signature line backed by a real certificate.

Image signatures are the everyday workhorse. You sign a piece of paper, photograph or scan it, clean up the background, and save it as a transparent PNG. Once that file exists, dropping it into any Excel workbook takes five seconds.

Go to Insert > Pictures, choose "This Device" if your PNG is local or "Stock Images" / "Online Pictures" if it lives in the cloud, pick the file, and Excel places the signature wherever your cursor was last active. Resize by dragging a corner handle — hold Shift to keep the proportions locked — and reposition by clicking and dragging the image itself.

The single biggest mistake at this stage is using a JPG with a white background. A JPG signature sitting on top of a grey or coloured cell looks like a postage stamp glued onto the page. The fix is a transparent PNG, where the background pixels are removed so only the ink of the signature shows.

You can produce one yourself in Paint 3D, Photoshop, GIMP, or any free online background remover (just search "remove background from signature"). Save the result as a PNG — not a JPG — because only PNG preserves transparency. Once you have a clean transparent signature PNG saved somewhere sensible, treat it like a permanent asset. Every quote, invoice, and signed worksheet you produce from now on can reuse it.

One small tip that saves time. If you are going to be inserting the same signature into many workbooks, save the cleaned PNG into your OneDrive or Dropbox folder. Then in Excel use Insert > Pictures > Online Pictures and browse to that cloud folder. The file is always one click away from any computer where you are signed in, which is much faster than hunting through Documents > Personal > Scans > 2025 every time you need it.

The Drawing tab approach is newer and underrated. Excel 365 (and recent Excel 2019/2021 versions) ships with a full Draw ribbon that lets you sign directly inside the workbook using a mouse, trackpad, or stylus. To turn it on, go to File > Options > Customize Ribbon and tick the "Draw" box under Main Tabs. Click OK and the Draw tab appears in the ribbon. From there, choose a pen, pick a colour and thickness, then sign anywhere on the sheet.

The result is a vector drawing — not a pixel image — which means you can resize it indefinitely without going blurry. The drawing is anchored to the cell behind it by default but floats above the grid like an image, which makes positioning intuitive.

Freehand signing inside Excel is brilliant for one specific use case: you receive a workbook, need to sign a single line and send it back immediately, and you do not have a clean PNG of your signature anywhere on the machine. Draw it once, save the file, send. Job done in under a minute.

The catch is that signatures drawn on a desktop trackpad rarely look like the ones you produce on paper. If you sign agreements regularly and your scribble matters — legally or aesthetically — invest in either a stylus and touchscreen, or stick with the transparent PNG of your real signature. The Drawing tab is also the only built-in way to annotate a sheet, so people who are not signing but just marking up cells (circling totals, drawing arrows, adding handwritten notes for review) find it indispensable even if they never use it for signatures.

Now to the formal option. Insert > Signature Line is the only Excel feature that is actually called "signature line" and the only one that ties a signature to a verified identity. To insert one, click the cell where the signature should appear, then go to Insert > Text > Signature Line > Microsoft Office Signature Line. A dialog opens asking for the signer's suggested name, title, and email, plus instructions to display to the signer. Fill those in and click OK. Excel drops a placeholder line with an X and the signer's name into the cell.

What happens next depends on who signs. If you are the signer, double-click the line, and Excel asks for a digital ID. If you have a certificate installed on your machine, it appears in the list. If not, Excel offers a "Get a digital ID from a Microsoft partner" link, plus the option to create a self-signed certificate for personal or internal use.

Self-signed certificates are free but only "trusted" on the machine that created them, so they are mostly useful for internal workflows where everyone agrees in advance to accept the certificate. For external-facing legally binding signatures, you need a certificate from a recognised certification authority — DigiCert, GlobalSign, IdenTrust, and Sectigo are the big names.

These typically cost between $20 and $200 per year depending on the validation level. Once you have a certificate installed, the signing process takes one click and produces a cryptographic mark that can be verified by anyone opening the file. Tamper with the signed cells afterwards and the signature breaks visibly, alerting any reader that the document was modified after signing.

The signature line method is overkill for most everyday Excel use. But for procurement contracts, regulated industries (finance, healthcare, government), and any document where "this person signed it and it has not been altered since" needs to be provable in court, it is the only approach that holds up. Most of us will go through life never needing it, but knowing it exists matters the day a lawyer or compliance officer asks how Excel handles verifiable signatures.

Once a signature is in place, the next question is how to stop it being moved, deleted, or modified by whoever opens the file next. Excel offers several layers of protection and most signers do not bother with any of them, which is how so many "signed" workbooks end up unsigned again within an hour of leaving the inbox.

The simplest protection is Review > Protect Sheet. Tick a password if you want one, choose which actions to allow (selecting locked cells, formatting columns, sorting, etc), and click OK. From that point on, the sheet is read-only except for actions you explicitly allowed.

By default every cell in Excel is locked, but locking only takes effect when sheet protection is on. So the typical sign-and-protect workflow is: insert the signature image, click Review > Protect Sheet, set a password if needed, save the file, and send. Anyone who opens the file can see the signature but cannot move it, resize it, or delete it without the password.

For stronger protection, combine sheet protection with File > Info > Protect Workbook > Mark as Final. This sets a flag that warns anyone opening the file that it is a final version. The warning can be dismissed but it nudges casual readers toward viewing rather than editing. For the highest level of protection short of a digital signature, save the workbook as a PDF instead of sending the .xlsx. The signature becomes a permanent part of the page image and cannot be edited without specialist tools.

One important note: protecting a sheet does not encrypt or hide the contents. Anyone can still read the file. If the signed document contains sensitive data, use File > Info > Protect Workbook > Encrypt with Password to add a password requirement at file-open time. That is a separate setting from sheet protection and the two combine well for serious documents.

Time for a step-by-step walkthrough of the most common scenario: producing a signed PDF invoice from an Excel template. Start with your invoice workbook open. Click the cell beneath the "Authorised by" line where the signature should appear — usually somewhere in the bottom right of the page. Go to Insert > Pictures > This Device and select your transparent PNG signature. Excel places the image at the cursor position, usually overlapping a few cells.

Resize the signature by dragging a corner handle (hold Shift to keep proportions locked) until it looks proportional to the surrounding text. Drag the image into the exact position you want above the signature line.

Now lock it down. Right-click the image, choose Size and Properties, expand the Properties section, and select "Don't move or size with cells". This stops the signature from drifting if rows above are inserted or deleted later. Go to Review > Protect Sheet, optionally add a password, and click OK. The signature is now anchored and protected.

Finally, export to PDF. Go to File > Export > Create PDF/XPS Document, pick a folder, and click Publish. Excel produces a PDF copy of the invoice with the signature baked into the page image. Attach the PDF to your email and send. The recipient gets a clean, signed invoice that cannot be edited and that opens correctly in every PDF reader on every operating system.

The whole workflow — from clicking Insert > Pictures to sending the email — takes under two minutes once you have done it twice. Save the unsigned invoice template separately as a .xltx file so next month you start from a clean copy. Most freelancers and small businesses run their entire invoicing operation through some variation of this pattern; the only thing that changes between invoices is the customer name, line items, and date.

Removing a signature is sometimes more important than adding one. Maybe the file needs to be edited and re-signed. Maybe the wrong signature went in. Maybe the document is being archived and the signature is no longer relevant.

For image signatures, the removal is straightforward once sheet protection is off. Go to Review > Unprotect Sheet, enter the password if there was one, click the signature image, and press Delete. The image disappears. Re-protect the sheet if you want to keep the rest of the lock in place.

For freehand drawings made with the Draw tab, the same approach works: unprotect the sheet, click the drawing, press Delete. Drawings are technically shape objects and behave similarly to inserted images, so anything that works for one usually works for the other.

For digital signatures inserted via the Signature Line, the removal is slightly different because the signature is tied to a cryptographic record. Right-click the signature line and choose Remove Signature. Excel asks you to confirm because removing a signature invalidates the document's signed state — once the signature is gone, the cryptographic guarantee that no editing has happened disappears with it.

The signature line itself remains in place as an unsigned placeholder, ready for re-signing if needed. If you want to remove the line entirely as well, right-click again and choose Cut or Delete.

One quiet feature worth knowing: Excel keeps a record of any digital signatures that have ever been added and removed in the workbook's metadata. If you are working in a regulated environment where audit trails matter, that metadata is your friend — it shows that a signature existed, when it was added, when it was removed, and by whom. Compliance teams pull this information regularly during audits. For consumer-facing workbooks where you simply want a clean file, you can strip the metadata via File > Info > Inspect Document > Check for Issues before sending.

Finally, a few small tricks that experienced Excel users rely on. If you sign a lot of documents, set up a single workbook called "signature-template.xlsx" with your transparent PNG already positioned, sized, and protected. To sign a new document, copy the protected cell range from your template and paste it into the target workbook. The signature comes through with all its settings intact, saving you ten seconds per file and avoiding the need to remember which folder holds the source PNG.

If you collaborate with colleagues who all need to add their own signatures to the same workbook — a multi-approver expense form, for example — build a single template with one signature row per signer and a separate placeholder Picture object in each. Each signer replaces their own placeholder using Right-click > Change Picture > This Device, which preserves the size and position of the placeholder while swapping in their own PNG.

It is a small workflow change that prevents the chaos of every approver inserting and resizing their own image independently.

If you find yourself signing the same kinds of documents repeatedly — weekly timesheets, monthly invoices, quarterly reports — treat the signature as part of the template, not as something you add at the end. Build the workbook once with the signature already in place, lock the relevant cells, save as a .xltx template, and the future versions only need new data filled in. The signature is permanent and protected from the moment the file is created.

This small habit removes a step from every recurring document workflow, which compounds over a year into a serious time saving.

One more practical pointer. When you save an .xlsx workbook with an image signature inside it, the PNG is stored as a binary attachment inside the file. This makes the workbook larger than it would otherwise be — usually by a few hundred kilobytes for a clean transparent PNG signature. For workbooks that are sent over slow email systems or stored in tight cloud quotas, this can matter.

If file size is critical, compress the signature image after inserting it: click the image, go to Picture Format > Compress Pictures, untick "Apply only to this picture" if you want to compress all pictures, choose 220 ppi (Print) or 150 ppi (Screen), and click OK. Excel re-encodes the image at the chosen resolution, often reducing the file size by 50–80% with no visible quality loss for signature-sized images. Run this once per workbook before sending and you will keep file sizes lean without sacrificing how the signature looks.

For documents that have to look identical across operating systems — a signed quote opened on a colleague's Mac, a customer's Linux machine, or a manager's iPad — always export to PDF before sending. Excel rendering varies slightly across platforms (fonts, image scaling, page breaks) and your perfectly positioned signature might shift by a few pixels on a different machine.

A PDF freezes the layout exactly as you saw it on the screen where you signed. This is non-negotiable for client-facing documents and good practice for everything else. The PDF export is built into Excel via File > Export > Create PDF/XPS Document and takes three clicks. Once you build the habit of exporting before sending, you stop receiving emails that say "the signature has moved on my computer, can you re-send?" — which on its own is worth the small extra step.

The last word goes to the choice between image and certificate. Most readers of this guide will never need to set up a digital certificate. An image signature on a protected sheet, exported to PDF, is the right answer ninety per cent of the time. Knowing that the certificate-based option exists matters the day somebody in legal or compliance asks how Excel handles verifiable signatures — and now you know exactly where to point them. Insert > Signature Line, install a certificate from a recognised authority, sign with one click, done.