inserting image and document files into the spreadsheet
 

I am creating my first spreadsheet. I've spent numerous hours
figuring out how to do this on intuition alone. It's how I learn
best I think.

Initially, I just wanted to make an organized list of expenses. Then
I thought I'd put this spreadsheet into a folder, along with
descriptive documents
and scanned jpeg files that may attach, or pertain to a particular
expense, or line in the spreadsheet. Then I
found I could insert comments in cells, eliminating the need for the
creation of "docs!" Great! Now, I want to add these other files on the
basis of which line they might pertain to. I am betting this can be
done, but am wanting to get the shortcut to how, through you.

Can it be done? Please tell me how.

Since I've figured the size of this spreadsheet will be between 3-5
megabytes, it will be too large to distribute by floppy. I believe I
could email deliver it, but don't really want to clog the mail box of
a dialup user. I'm betting it could be uploaded to my site for
viewing, but don't know if I want to go that route either. I'm
getting sort of sleepy, and need to get this done.

Thank you.

inserting image and document files into the spreadsheet
 

you can insert a picture into a comment
http://www.contextures.com/xlcomments02.html#Picture
--
paul
remove nospam for email addy!



"Cornpone" wrote:

I am creating my first spreadsheet. I've spent numerous hours
figuring out how to do this on intuition alone. It's how I learn
best I think.

Initially, I just wanted to make an organized list of expenses. Then
I thought I'd put this spreadsheet into a folder, along with
descriptive documents
and scanned jpeg files that may attach, or pertain to a particular
expense, or line in the spreadsheet. Then I
found I could insert comments in cells, eliminating the need for the
creation of "docs!" Great! Now, I want to add these other files on the
basis of which line they might pertain to. I am betting this can be
done, but am wanting to get the shortcut to how, through you.

Can it be done? Please tell me how.

Since I've figured the size of this spreadsheet will be between 3-5
megabytes, it will be too large to distribute by floppy. I believe I
could email deliver it, but don't really want to clog the mail box of
a dialup user. I'm betting it could be uploaded to my site for
viewing, but don't know if I want to go that route either. I'm
getting sort of sleepy, and need to get this done.

Thank you.

inserting image and document files into the spreadsheet
 

Hi Cornpone,

You can download one com-addins "Image to comment" for excel-2000+ from
below site.

http://in.geocities.com/shahshaileshs/

To reduce file size try another com-add-ins "File Sizer" from this site.

BTW from Picture Toolbar, you can also compress picture to reduced further
reduction in file size.

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)


-------------------------------------------------------------------
Cornpone wrote in message
...
I am creating my first spreadsheet. I've spent numerous hours
figuring out how to do this on intuition alone. It's how I learn
best I think.

Initially, I just wanted to make an organized list of expenses. Then
I thought I'd put this spreadsheet into a folder, along with
descriptive documents
and scanned jpeg files that may attach, or pertain to a particular
expense, or line in the spreadsheet. Then I
found I could insert comments in cells, eliminating the need for the
creation of "docs!" Great! Now, I want to add these other files on the
basis of which line they might pertain to. I am betting this can be
done, but am wanting to get the shortcut to how, through you.

Can it be done? Please tell me how.

Since I've figured the size of this spreadsheet will be between 3-5
megabytes, it will be too large to distribute by floppy. I believe I
could email deliver it, but don't really want to clog the mail box of
a dialup user. I'm betting it could be uploaded to my site for
viewing, but don't know if I want to go that route either. I'm
getting sort of sleepy, and need to get this done.

Thank you.

inserting image and document files into the spreadsheet
 

paul wrote:
you can insert a picture into a comment
http://www.contextures.com/xlcomments02.html#Picture


Hello Paul,

Thank you for this info. I've successfully added a picture to the
cell. However, I need to learn how to hide the picture and open the
picture. Not just a viewing a thumbnail, but view the added picture
file in it's full size, hopefully without altering the spreadsheet.
Can this be done?

What affect does compressing the picture have on the original
picture? If in fact the original is contained here.

Thanks again for the help.

inserting image and document files into the spreadsheet
 

Shailesh Shah wrote:
Hi Cornpone,

You can download one com-addins "Image to comment" for excel-2000+ from
below site.

http://in.geocities.com/shahshaileshs/

To reduce file size try another com-add-ins "File Sizer" from this site.

BTW from Picture Toolbar, you can also compress picture to reduced further
reduction in file size.

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)


-------------------------------------------------------------------
Cornpone wrote in message
...

I am creating my first spreadsheet. I've spent numerous hours
figuring out how to do this on intuition alone. It's how I learn
best I think.

Initially, I just wanted to make an organized list of expenses. Then
I thought I'd put this spreadsheet into a folder, along with
descriptive documents
and scanned jpeg files that may attach, or pertain to a particular
expense, or line in the spreadsheet. Then I
found I could insert comments in cells, eliminating the need for the
creation of "docs!" Great! Now, I want to add these other files on the
basis of which line they might pertain to. I am betting this can be
done, but am wanting to get the shortcut to how, through you.

Can it be done? Please tell me how.

Since I've figured the size of this spreadsheet will be between 3-5
megabytes, it will be too large to distribute by floppy. I believe I
could email deliver it, but don't really want to clog the mail box of
a dialup user. I'm betting it could be uploaded to my site for
viewing, but don't know if I want to go that route either. I'm
getting sort of sleepy, and need to get this done.

Thank you.





Hello Shailesh Shah,

Thank you for your time. I haven't had a chance to look this info
over yet, but I will!

inserting image and document files into the spreadsheet
 

paul wrote:
you can insert a picture into a comment
http://www.contextures.com/xlcomments02.html#Picture

I think I may have figured out at least one way. Not sure it's the
most effective way. Anyway, just open the comment and drag its
handles to any size you want? It does indeed enlarge the scan so
that its readable! So cool.

inserting image and document files into the spreadsheet
 

Shailesh Shah wrote:
Hi Cornpone,

You can download one com-addins "Image to comment" for excel-2000+ from
below site.

http://in.geocities.com/shahshaileshs/

To reduce file size try another com-add-ins "File Sizer" from this site.

BTW from Picture Toolbar, you can also compress picture to reduced further
reduction in file size.

I can't find the picture toolbar! ;) [I am tired I think].


Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)

<snipped

OK. I have downloaded and installed your file sizer because my
spreadsheet is too large to email, [7.5MB]. I thought I saw a
"compression" button somewhere in Excel while I was creating this
sheet, but I certainly can't find it now! :-0

I do not see any shortcut or program menu entry after installing your
file sizer! How do I find and use it please?

thank you.

inserting image and document files into the spreadsheet
 

Hi Cornpone,

I can't find the picture toolbar! ;) [I am tired I think].

from menu ViewToobarsPicture

10th button for Compress picture.(but not in excel-97)


I do not see any shortcut or program menu entry after installing your file
sizer! How do I find and use it please?

from Menu ToolsFile Sizer



Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)


"Cornpone" wrote in message
...
Shailesh Shah wrote:
Hi Cornpone,

You can download one com-addins "Image to comment" for excel-2000+ from
below site.

http://in.geocities.com/shahshaileshs/

To reduce file size try another com-add-ins "File Sizer" from this site.

BTW from Picture Toolbar, you can also compress picture to reduced
further
reduction in file size.

I can't find the picture toolbar! ;) [I am tired I think].


Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)

<snipped

OK. I have downloaded and installed your file sizer because my
spreadsheet is too large to email, [7.5MB]. I thought I saw a
"compression" button somewhere in Excel while I was creating this sheet,
but I certainly can't find it now! :-0

I do not see any shortcut or program menu entry after installing your file
sizer! How do I find and use it please?

thank you.