Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Writing on an inserted image

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    101
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I want to insert an invoice as an image and fill it out using excell so I can keep track and manipulate the information I input. The problem is that when I insert the invoice as an image I can't write on it, I write in a cell C3 but I can't see what I am writing. I need to see what I am writing because after I fill out all the information, I want to print on the real invoice just the information I wrote.

    Any ideas?

    Thanks,

    Hugo

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You can make the invoice image the background to your Excel spreadsheet.

    To do this go to Format|Sheet|Background
    then select the invoice image from wherever it's stored.

    This will tile the invoice image all over the spreadsheet. To make it a bit easier to work with you can zoom in on one of the invoices.

    To do this, highight the area of one invoice on the spreadsheet the go to View|Zoom and select "Fit Selection".

    The image of the invoice will not print, just the data you put in the cells.

    HTH

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    101
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-20 12:48, Mark O'Brien wrote:
    You can make the invoice image the background to your Excel spreadsheet.

    To do this go to Format|Sheet|Background
    then select the invoice image from wherever it's stored.

    This will tile the invoice image all over the spreadsheet. To make it a bit easier to work with you can zoom in on one of the invoices.

    To do this, highight the area of one invoice on the spreadsheet the go to View|Zoom and select "Fit Selection".

    The image of the invoice will not print, just the data you put in the cells.

    HTH
    It works the way you say but the problem is that when I do the zoom, it zooms in the information but not the background, I mean the image does not reduce, also when I insert the image as a background it looses its original size, I mean in excel I write the name of the client; but when I print, the client's name is printed away from the space designed for it.

    Hugo

    [ This Message was edited by: huorsa on 2002-02-20 14:23 ]

  4. #4
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    It works the way you say but the problem is when I print because when I insert the image as a background it looses its original size, I mean in excel I write the name of the client; but when I print, the client's name is printed away from the space designed for it.

    Hugo
    I got this technique to work with no problems by making a small invoice sheet in Word, then did a "Print Screen" to create a bitmap. I set the background to be this bitmap.

    My only suggestion now would be to play with the size the invoice image using graphics software.



  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi --

    Did i hear the magic word INVOICE???

    Wonderful, i create invoices many a day to do this i have templates which have all the relevant info and print on headed paper, the template take the workload aways. Image i would do against.

    I use vlookup for names address etc..
    I use vlooup for product codes with dropdown listes

    and financial formula - all painless. no images bar the company logo (bmp file)

    Would this not be best?

    Rdgs
    HTH

    ==========
    Jack

  6. #6
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Why not make the image transparent then
    your cells will show up behind the image.
    If the image doesn't support this the convert
    it to one that does.


    Ivan

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •