Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#8
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Variable IMAGE in document header | Excel Discussion (Misc queries) | |||
Send a document image to Excel | Excel Discussion (Misc queries) | |||
Aspect ratio of image differs in print | Excel Discussion (Misc queries) | |||
Print Excel to Microsoft Document Image File (MDI) | Excel Discussion (Misc queries) |