#1   Report Post  
cjones
 
Posts: n/a
Default Images in Excel 2000

I'd like to import an 8 1/2" x 11" jpg image into an exel 2000 spreadsheet
and be able to enter data into the cells and still see the image underneath.
Is this possible and how do I do it.
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

This would be impossible or nearly so using Microsoft Excel. You could do it
with Word.
http://www.officearticles.com/word/t...oft_word. htm
However, I think it's crazy to try it under any circumstances.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"cjones" wrote in message
...
I'd like to import an 8 1/2" x 11" jpg image into an exel 2000 spreadsheet
and be able to enter data into the cells and still see the image

underneath.
Is this possible and how do I do it.



  #3   Report Post  
cjones
 
Posts: n/a
Default

In Excel, I inserted the image and then hit the Set Transparent Color.
If you tab through the cells from outside the image, you can type over
the image but of course the Set Transparent Color changes my original
image color.

What is the best way to create a dummy statement using a scanned image
that I can then type my data and color print?

"Anne Troy" wrote:

This would be impossible or nearly so using Microsoft Excel. You could do it
with Word.
http://www.officearticles.com/word/t...oft_word. htm
However, I think it's crazy to try it under any circumstances.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"cjones" wrote in message
...
I'd like to import an 8 1/2" x 11" jpg image into an exel 2000 spreadsheet
and be able to enter data into the cells and still see the image

underneath.
Is this possible and how do I do it.




  #4   Report Post  
Anne Troy
 
Posts: n/a
Default

Skip the scanned image and create a form. By the time you spend all your
time trying to get a scanned image in, you could create the form. Use Excel
or use Word.

http://www.officearticles.com/word/c...osoft_word.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"cjones" wrote in message
...
In Excel, I inserted the image and then hit the Set Transparent Color.
If you tab through the cells from outside the image, you can type over
the image but of course the Set Transparent Color changes my original
image color.

What is the best way to create a dummy statement using a scanned image
that I can then type my data and color print?

"Anne Troy" wrote:

This would be impossible or nearly so using Microsoft Excel. You could

do it
with Word.

http://www.officearticles.com/word/t...oft_word. htm
However, I think it's crazy to try it under any circumstances.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"cjones" wrote in message
...
I'd like to import an 8 1/2" x 11" jpg image into an exel 2000

spreadsheet
and be able to enter data into the cells and still see the image

underneath.
Is this possible and how do I do it.






  #5   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

You could try: format / sheet / background.... It won't print, but it will display the way you
want.

HTH,
Bernie
MS Excel MVP


"cjones" wrote in message
...
I'd like to import an 8 1/2" x 11" jpg image into an exel 2000 spreadsheet
and be able to enter data into the cells and still see the image underneath.
Is this possible and how do I do it.





  #6   Report Post  
cjones
 
Posts: n/a
Default

Thank you both for your tips. Not sure which way I'll go.

"Bernie Deitrick" wrote:

You could try: format / sheet / background.... It won't print, but it will display the way you
want.

HTH,
Bernie
MS Excel MVP


"cjones" wrote in message
...
I'd like to import an 8 1/2" x 11" jpg image into an exel 2000 spreadsheet
and be able to enter data into the cells and still see the image underneath.
Is this possible and how do I do it.




  #7   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

Bernie

...but it will display the way you want.


Welllllll, not exactly. A sheet background image is put on the screen
actual size (pixel for pixel), tiled from the upper left corner. You can't
move it around. Changing zoom doesn't change the size. Changing the screen
resolution does, I think.
--
Earl Kiosterud
www.smokeylake.com/
-------------------------------------------

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
You could try: format / sheet / background.... It won't print, but it
will display the way you want.

HTH,
Bernie
MS Excel MVP


"cjones" wrote in message
...
I'd like to import an 8 1/2" x 11" jpg image into an exel 2000
spreadsheet
and be able to enter data into the cells and still see the image
underneath.
Is this possible and how do I do it.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Excel 2000 with Chinese Mark S. Excel Discussion (Misc queries) 1 June 8th 05 02:33 AM
Help! Excel 2000 fully SP'ed will not start Dirk-Thomas Brown Excel Discussion (Misc queries) 2 June 2nd 05 01:01 AM
Excel XP Pivot Table in Excel 2000 bsantona Excel Discussion (Misc queries) 0 January 20th 05 06:37 PM
How do I update Excel 2000 macros to work in Excel 2002? BobPetrich Excel Discussion (Misc queries) 3 January 4th 05 04:06 PM


All times are GMT +1. The time now is 12:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"