OBINTUSACADEMY
HOME CONTACT SERVICES PRIVACY
COMPUTER BASICS MS-PACKAGES
Excel - How To Add Signature

MICROSOFT EXCEL

MODULE ONE

Prerequisite Introduction to Microsoft Excel Getting Started MS Excel Environment Title Bar Quick Access Toolbar Search Account Name Buttons Menu Tab Ribbons Dialog Box Launcher Name Box Insert Function Formula Bar Worksheet Area Worksheet Navigation Creating New Sheet Status Bar Worksheet View Format Zoom Slider MS Excel File Tab Entering Data Saving Your Workbook Opening Saved Workbook Copy, Delete and Hiding Sheet Closing Entire Workbook

MODULE TWO

Cells, Rows and Columns Resizing Rows and Columns Inserting Data Select, Delete and Move Data Copy, Paste and Cut Find and Replace Checking Spellings Inserting TextBox Inserting Symbols Inserting Special Characters Zooming Undoing and Redoing Changes

MODULE THREE

Mini Toolbar Setting Fonts Text Decoration Setting Text Case Text Alignments Text Orientation Increase and Decrease Indentation Wraping Text Merging Cells Cells Borders Cells Shades Copy Formatting Insert and Delete Worksheet Format Worksheet, Cells, Rows and Columns

MODULE FOUR

Insert Tables Insert Pictures Insert Shapes and Smart Art Insert Screenshots Insert Icons Insert 3D-Models Using Add-ins Insert Charts 3D Maps Creating Sparklines Insert WordArt

MODULE FIVE

Addition Subtraction Multiplication Division Using Formulas Using Functions Quick Functions

MODULE SIX

Fill Handling Sorting Filtering References (Relative and Absolute) Conditional Formatting Applying Styles

MODULE SEVEN

Page Themes Page Colors Page Fonts Page Effects Page Header and Footer Page Numbering Page Margins Page Orientation and Size Print Area Page Breaks Setting Background Print Titles Preview and Print Share Workbook Freezing Panes Range Data Validation Excel Templates MS Excel Shortcuts Conclusion

HOW TO

Excel How-To Send Email Separate Text Date and Time Format Macro Thesaurus Insert Comments Password Workbook Count Characters Count Words Add and Remove Hyperlinks Insert PDF in Excel Editing and Formatting Restrictions How to Compare Columns How to Compare Worksheets Add Signature in Worksheet Calculate Age Calculate Mean Calculate Median Calculate Standard Deviation Find the Mode Add and Remove Commas How to Remove Filter Convert Excel to CSV Excel to PDF Excel to Ms-Word Document Excel to Picture Formats Duplicate Rows and Columns Hide and Unhide Rows and Columns Rows and Columns Conversion How to Remove Gridlines Create Graphs Insert Check Box Add and Remove Watermark Logical Operators Logical Functions Text Functions Square Symbol Pi Symbol Selecting Different Columns Creating QR Code Creating Bar Code Insert Bullet Points Generate Random Numbers Combine Two Columns Wrap Text Create Dropdown List

How To Add Signature

PREVIOUS NEXT

In this tutorial I will be showing you step by step on how to add you signature in an Excel worksheet. This will take you only few minutes and you are done.

  • ADDING SIGNATURE
  • Step 1 - Open a blank excel worksheet for this tutorial.
    • signature
  • Step 2 - Write your signature on a white piece of paper, snap it and send it to your computer system.
    • signature
  • Step 3 - Now go back to Excel. In your worksheet, click the Insert tab then click on the Illustrations options. From the Illustrations group displayed, click the Picture option then click on This Device option from the dropdown list of options displayed.
    • signature
  • Step 4 - Excel will open your file explorer. Go to where you keep the picture of your signature in your computer system. Select it and click the Insert button.
    • signature
  • Step 5 - This signature will now be inserted into your excel worksheet as shown in the image below.
    • signature
  • Step 6 - Right click on the picture. From the list of options displayed, click on Format Picture
    • signature
  • Step 7 - After clicking on the format picture, the Format Picture pane will be displayed at the right side of your excel windows. Inside the pane, click on the picture tab icon. In the picture tab section, open the Picture Corrections section.
    • signature
  • Step 8 - Inside the picture correction section, change the sharpness option to around 65%, brightness around 40% and the contrast around 20%.
    • signature
    note
    NOTE:

    Depending on the paper and how the background looks like you can always adjust the sharpness, brightness and contrast to make it as perfect as possible.

  • Step 9 - After you are done, click on the close icon to close the pane.
    • signature
  • Step 10 - Now while the image is still selected, click on the Picture Format tab and go to the Adjust group. Click on the Color button option which will display list of options. From the dropdown list of options, click on Set Transparent Color.
    • signature
    tips
    TIP:

    The Set Transparent Color option makes the background of the image to completely fade away leaving only the solid shape or writing.

  • Step 11 - Now, after clicking that option above, notice you mouse pointer changes to another icon. So now, simply click directly on the image.
    • signature
  • Step 12 - Notice the white background in the image is now completely removed leaving only the signature writing in the worksheet.
    • signature
  • Step 13 - Next you can use the text box to write the name as shown in the image below.
    • signature
  • Step 14 - Remove the text box background and outline, then move the signature above the name and centralize it as shown in the image below.
    • signature
  • Step 15 - You can also add a line directly above the name of the signatory as shown in the image below.
    • signature
  • Step 16 - ALL DONE!
    • signature
PREVIOUS NEXT
ADVERTISEMENTS

LEARNING IS A CONTINOUS PROCESS - PRACTICE MAKES PERFECT