ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to paste a image (signature) in a cell in Excel? (https://www.excelbanter.com/excel-worksheet-functions/96982-how-paste-image-signature-cell-excel.html)

V.Jeyakumar

How to paste a image (signature) in a cell in Excel?
 
I wish to create a database with the name of persons &their signature in
Excel.This will be useful for me to verify the signature . Please help me by
advicing me how to paste & save the signature of the person in the cell .

cell A2 - NAme of the person
Cell B2 - Signature image
Likewise i propose to have 100 persons signature in the excel sheet

I am using Excel 2003


Thanks in advance.

Ken Johnson

How to paste a image (signature) in a cell in Excel?
 
V.Jeyakumar wrote:
I wish to create a database with the name of persons &their signature in
Excel.This will be useful for me to verify the signature . Please help me by
advicing me how to paste & save the signature of the person in the cell .

cell A2 - NAme of the person
Cell B2 - Signature image
Likewise i propose to have 100 persons signature in the excel sheet

I am using Excel 2003


Thanks in advance.


Hi,
It looks to me like all you have to do is...

1. Format the signature images' Properties to "move but don't size with
cells" by selecting the images then going Format|Object|Properties|move
but don't size with cells

2. Make sure that the Column B cells are large enough so that each
signature image fits inside its cell. It doesn't have to be a neat or
complete fit, it just shouldn't protrude outside its cell bounderies.

This way the signature images will move with the names when you sort
the columns, provided you select both columns before sorting.

Ken Johnson



All times are GMT +1. The time now is 01:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com