In Excel: for a picture of a signature use Insert ▸ Pictures; for a verifiable one use Insert ▸ Text ▸ Signature Line ▸ Microsoft Office Signature Line, then right-click it ▸ Sign.
For a picture: crop the scan tightly, remove the white background with Picture Format ▸ Remove Background, then Insert ▸ Pictures and position it.
For a signature line: Insert ▸ Text ▸ Signature Line ▸ Microsoft Office Signature Line, fill in name, title and instructions.
To sign it: right-click the line ▸ Sign, then either type your name, select an image, or choose a certificate.
Without a certificate, create one with SELFCERT.EXE from the Office install folder — it will be trusted only on that machine.
Save as .xlsx; signatures do not survive a save to CSV or an export that rewrites the file.
What this does
Two entirely different things share the word. An IMAGE of a signature — a scan or a photo with the background removed — is decoration: it proves nothing, anyone can copy it out of the file, and it is what most people actually want for an internal form. A DIGITAL SIGNATURE is cryptographic: it binds the signature to the workbook contents using a certificate, so any later edit invalidates it visibly. That requires a certificate, either from a certificate authority or a self-signed one made with the SELFCERT tool that ships with Office, and self-signed certificates are trusted only on the machine that created them. Excel's Signature Line sits between the two: it inserts a signature placeholder with the signer's name and title, which can then be signed either with a certificate or by inserting an image. Note that signing a workbook marks it final — the file becomes read-only, and editing it removes the signature. Keep the inputs visible and clearly labelled and the whole thing stays auditable — anyone who opens the file later, including you, can see at a glance exactly what feeds the result and change one assumption without hunting through the formula. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “create a signature in excel”. Start on a copy or a tiny sample, keep the affected cells visible, and compare the result with the tool above before you touch the real workbook. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. The point is a layout choice that keeps the sheet readable and sortable, but the practical win is that someone else can open the file and understand what happened without asking you.
A worked example
An approval sheet needing the manager's sign-off. Insert ▸ Text ▸ Signature Line ▸ enter name, title and instructions ▸ OK. Excel places an X-with-a-line block in the cell area. The manager right-clicks it ▸ Sign, selects their certificate (or picks an image of their signature), and Excel marks the workbook as final. Any subsequent edit shows the signature as invalid rather than silently keeping it. The distinction between a picture of a signature and a cryptographic one decides whether the file proves anything at all, and Excel presents both under the same menu word. One habit worth forming early: name the cells that hold your inputs, so the formula reads in plain language instead of a string of cell addresses. A reviewer — or you in three months — can then follow the logic without decoding what B7 and D2 were supposed to mean, which is most of what makes a sheet maintainable.
In Google Sheets
If you are in Google Sheets rather than Excel, the good news is that the formula shown here is identical and the workflow barely changes — menus sit across the top instead of in a ribbon, and a few function names differ slightly, but anything you build here moves across with little or no rework. Nothing on this page is behind a login: the tool runs entirely in your browser, the formula is shown in full with one-click copy, and the steps work the same on Windows and Mac. That is the whole promise here — the exact answer, a way to prove it on your own numbers, and just enough context to make it stick. Here is the takeaway for “create a signature in excel”: copy the answer if you are busy, but if you have a spare few minutes, rebuild the example in Excel yourself with the tool above open beside it. That single pass — type it, run it, watch the result move when you change an input — is what turns a formula you found into a technique you trust. Keep your inputs labelled and referenced, never hard-coded, and the same sheet stays correct and auditable as it grows. Done that way, you will not need to look this up again, and you will be the person others ask.
Common mistakes
- Treating a pasted image as legally binding — it is a picture, extractable by anyone who opens the file.
- Editing the workbook after signing, which invalidates the signature (this is the feature working, not a fault).
- Distributing a workbook signed with a self-signed certificate and expecting recipients to see it as trusted.
- Floating the image over cells so it drifts when rows are resized; set Format Picture ▸ Properties ▸ Move and size with cells.
- Using Excel for a document that needs a real audit trail, where a PDF signing service is the right tool.
Frequently asked questions
How do I add a signature in Excel?
Insert ▸ Pictures for an image of one, or Insert ▸ Text ▸ Signature Line for a Microsoft Office Signature Line that can then be signed.
What is the difference between an image and a digital signature?
An image is decorative and copyable. A digital signature uses a certificate to bind the signature to the file contents, so any later edit shows as invalid.
Do I need a certificate?
Only for a true digital signature. You can make a self-signed one with SELFCERT.EXE from your Office folder, but other machines will not trust it.
Why can I no longer edit the workbook after signing?
Signing marks it as final and read-only. Removing the signature restores editing, and it must be re-signed afterwards.
Other ways people ask this
This is also commonly searched as “how to create signature in excel”, “create signature in excel”, “create a signature in excel” and “creating a signature in excel”. They describe the identical operation, so you are in the right place no matter how you phrased it.
Why do people search for this in so many different ways?
Because the same task has many names. “how to create signature in excel”, “create signature in excel”, “create a signature in excel” all point at the one operation explained on this page, which is why they all lead here.