Picture behind text in Cells

Is there any way in which a picture can be sent behind the text in the
worksheet cells?

Or round the other way, is there any way to show the cells contents in
front of a picture?

Many thanks

Bezza

0
4/5/2005 11:33:17 AM
excel 39879 articles. 2 followers. Follow

10 Replies
1351 Views

Similar Articles

[PageSpeed] 41

Format\sheet\background
should do the trick

RES
0
RES
4/5/2005 12:22:06 PM
That is a valid command. Unfortunately I've got numerous different
images that need to be displayed behind cells.

I need to use the cells so that the values displayed infront of the
different pictures can be used in forumula's.

Bezza

0
4/5/2005 12:52:43 PM
That is a valid command. Unfortunately I've got numerous different
images that need to be displayed behind cells.

I need to use the cells so that the values displayed infront of the
different pictures can be used in forumula's.

Bezza

0
4/5/2005 1:06:19 PM
Pictures, except for watermarks, live in the drawing layer "in front of" 
of the cells. You can adjust the transparency of the picture - 
right-click the picture, choose Format Picture, and enter a large 
percentage in the transparency textbox.

Note that the picture will still prevent selection of the cell with the 
mouse, since it's still "in front of" the cell (assuming it covers it 
completely). You can still use arrow keys, etc.


In article <1112700797.479298.285670@g14g2000cwa.googlegroups.com>,
 "Bezza" <adam_beresford@baa.com> wrote:

> Is there any way in which a picture can be sent behind the text in the
> worksheet cells?
> 
> Or round the other way, is there any way to show the cells contents in
> front of a picture?
0
jemcgimpsey (6723)
4/5/2005 1:42:27 PM
Take a picture (camera tool) of the cell with the text and "develop" it on
top of the other picture.
Bob Umlas
Excel MVP

"Bezza" <adam_beresford@baa.com> wrote in message
news:1112700797.479298.285670@g14g2000cwa.googlegroups.com...
> Is there any way in which a picture can be sent behind the text in the
> worksheet cells?
>
> Or round the other way, is there any way to show the cells contents in
> front of a picture?
>
> Many thanks
>
> Bezza
>


0
rumlas (268)
4/5/2005 5:27:30 PM
Hi Bezza


Take a textbox from the drawing toolbar and put it over the picture.
Select it. Enter =A1 in Excel's formula bar and the textbox will reflect the
content of cell A1 at all times.
Maybe format the box transparent background, no line, colored font, ...

HTH. Best wishes Harald

"Bezza" <adam_beresford@baa.com> skrev i melding
news:1112700797.479298.285670@g14g2000cwa.googlegroups.com...
> Is there any way in which a picture can be sent behind the text in the
> worksheet cells?
>
> Or round the other way, is there any way to show the cells contents in
> front of a picture?
>
> Many thanks
>
> Bezza
>


0
stf (176)
4/6/2005 9:50:19 AM
Thanks for all your replies, they are all valid answers, problem is
none of them can be used in formulas.

Essentially what I need to do is put some numbers in front of an image
and use the numbers in a formula.

I'm trying to use a spreadsheet to document all our computer cabinet
layouts, using images of the server and putting power and heat outputs
over the top. I then want to be able to total up the cabinet and
provide a sub-total. All these sub-totals can then be added together to
provide total figures for the data centre.

Bezza

0
4/6/2005 10:55:55 AM
Thanks for all your replies, they are all valid answers, problem is
none of them can be used in formulas.

Essentially what I need to do is put some numbers in front of an image
and use the numbers in a formula.

I'm trying to use a spreadsheet to document all our computer cabinet
layouts, using images of the server and putting power and heat outputs
over the top. I then want to be able to total up the cabinet and
provide a sub-total. All these sub-totals can then be added together to
provide total figures for the data centre.

Bezza

0
4/6/2005 11:03:19 AM
Can you put the pictures in one column and the numbers in the next(or 
previous) column?

Bill

"Bezza" <adam_beresford@baa.com> wrote in message 
news:1112785399.362295.203920@l41g2000cwc.googlegroups.com...
Thanks for all your replies, they are all valid answers, problem is
none of them can be used in formulas.

Essentially what I need to do is put some numbers in front of an image
and use the numbers in a formula.

I'm trying to use a spreadsheet to document all our computer cabinet
layouts, using images of the server and putting power and heat outputs
over the top. I then want to be able to total up the cabinet and
provide a sub-total. All these sub-totals can then be added together to
provide total figures for the data centre.

Bezza


0
bsharpe (111)
4/6/2005 4:51:08 PM
Maybe put the pictures in a Comment Box attached to each cell............

Vaya con Dios,
Chuck, CABGx3


<RES%nospam> wrote in message news:OTcjjvdOFHA.3788@tk2msftngp13.phx.gbl...
> Format\sheet\background
> should do the trick
>
> RES


0
croberts (1377)
4/6/2005 9:46:55 PM
Reply:

Similar Artilces:

how can you view cells from different worksheets in to one sheet,.
hi, I have multiple worksheets, more than 200 of them, and i wanted to summarize some cells in to one sheet, I know how to do it by entering the code manually (='7'!$D2), this shows cell d2 in sheet 7, but is there a function to do that like drag or something? You can use this macro myasin http://www.rondebruin.nl/summary.htm -- Regards Ron de Bruin http://www.rondebruin.nl "myasin" <myasin@discussions.microsoft.com> wrote in message news:07759D01-70FE-416A-B54B-009646C2C365@microsoft.com... > hi, > I have multiple worksheets, more than 200 of them, and i...

picture is not showing up in Excel
I have a picture that is in an Excel worksheet. I can see the handles and if I move the handles some, the picture will show up. However, it will not show up in print preview at all or page break preview. I can open the same file on another computer and it will show up fine. Any help would be appreciated. thanks. Check Tools -> Options ->General Do you have "Show All" selected for Objects? "cab58" wrote: > I have a picture that is in an Excel worksheet. I can see the handles > and if I move the handles some, the picture will show up. However, it > will...

Embedded pictures
Hello! I noticed that the when we set the picture property of a button or another control as embedded, it takes a lot of place. Is there an explication that show why the Access file encrease in size by more than the picture size (even if it is a bitmap, a format that is normaly heavy) Exemple: An mdb without picture would take 4 MB the same file with pictures would increase to 40 MB with only 400 KB of pictures. In JPEG format. Is it because Access uses a non efficient compression to include the image file? Thank you in advance for any suggestion! PS: I know that I can set the pictur...

Find a empty cell in next column
hi. Dave helped me with this before, now i need more help. I use this code to find a column called PoF and the numbers written in the cells below it. This code work in every row/column (i dont need to name it). PoFRow = 0 PoFCol = 0 On Error Resume Next PoFRow = Worksheets(2).Range("PoF").Row PoFCol = Worksheets(2).Range("PoF").Column On Error GoTo 0 If PoFRow = 0 Then MsgBox "No range named PoF on worksheet:" ' & .Name ' Else Set numberPoF = Nothing On Error Resume Next Set num...

Pictures don't print in outlook 2000 or 97
How do I get pictures to print when I print messages for Outlook 2000 or Outlook 97. I'm using XP Home. Thanks, Chris Hi Chris, Have you checked to make sure you have all of the latest Windows and Office Service Packs installed? I remember this issue from a whle back, and it was corrected in one of the service pack releases. Regards, Scott Atkins MCSE, MCSA Partner Technical Lead - Outlook Microsoft Technical Support for Platforms and Business Applications -------------------- >From: socialism001@yahoo.com >Newsgroups: microsoft.public.outlook >Subject: Pictures don't...

Need event macro to tab past a (calculated) cell
I have an Excel 2003 List (aka Table in Excel 2007). There are some protected (calculated) columns that I don't want users to enter data into. But I can't protect the sheet, because that prevents users from entering a new record at the bottom of the List. Does anyone have a suggestion on how to deal with this? I'm thinking of using an event macro invoked when user tabs out of say column C, which makes the selection skip the cell in column D and go directly to the cell in column E. I guess I'd have to use Worksheet.SelectionChange. But I don't know how to do...

Inserting picture from "My Pictures"
When I add a pic from "My pictures" the entire picture does not appear on the slide and when I try to format it it is impossible to get it back to the same pic I am attempting to add. If I am trying to add a pic I might only get a nose or a blade of grass instead of the original picture from "My Pictures". Reduce the zoom to 10%. Coul be a too large image "PP Neophyte" <PP Neophyte@discussions.microsoft.com> a �crit dans le message de news: CA5F97E6-D4D8-401B-B066-E261024F082F@microsoft.com... > When I add a pic from "My pictures" t...

picture in picture
Have to digital pictures & would like to put a couple of people on one picture into the other picture. How do i do this? Anyone got any ideas? TIA "ted medin" <n6trf@arrl.net> wrote in message news:OaNwFXQeKHA.2596@TK2MSFTNGP04.phx.gbl... > Have to digital pictures & would like to put a couple of people on one > picture into the other picture. How do i do this? Anyone got any ideas? > TIA Well not with Vista. You need a Graphic editing application. The Gimp may be able to do this. (It's free, Open Source but is a bit tricky yo get to lear...

Convert Social Security text to number?
I would like to convert a text social security number (###-##-####) to a numerical format (#########) so that it can search using vlookup functions. Any help is greatly appreciated. -Joe it depends on whether it is numeric formated with the dashes or Text with the dashes embedded. goto <format><cells><number> and select general if the dashes are still there it is text. select the cells and use find replace (Find the dash replace with nothing) the cells will still be text, so enter 1 in a cell copy it select the SSN cells and paste special Multiply "Joe" wro...

Picture in Publisher
When inserting pictures in publisher the picture does not show. I can see the frame. The same thing when I load a publisher file created by someone else. All the inserted pictures does not show. View>pictures is set to detailed display. Any suggestions for a solution? -- Thor Read the third FAQ here http://ed.mvps.org/Static.aspx?=Publisher/FAQs -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com http://officebeta.iponet.net/en-us/publisher/FX100649111033.aspx "Thor" <Thor@discussions.microsoft.com> wrote in messag...

Sending pictures with text and then another picture with text.
I receive some e-mails with text and then a picture with more text and again a picture. Some of these will have 8 to 10 pictures with text under each picture. But when I send it out it is received with all of the text in a group and the pictures are all sent as attachments. How do I get my e-mails to send the pictures and text the way I receive them? Thanks for any help you can give me. Bob ...

Text over 255 characters won't display
I understand from other posts that the limit on the number of characters in a text cell is large (32K or 64K?). But whenever I enter more than 255 characters, the cell doesn't display. I just get a single line of #s. The cell is formatted as text with word wrap, top aligned, and the row height is auto-fit. Even if I manually change the row height to some large number, it doesn't help. I've looked in vain for a setting that might affect this, but can't find one. I have had Excel files sent to me by co-workers where this does not happen, and compared my setting with theirs....

blinking or flashing cell or cells
I want a cell or string of cells to flash or blink constantly when i open the spreadsheet. It does not matter if the text or background blink or flash. Is this possible? Possible? Yes. Recommended? No. Why? Slows down the processing time. But a search through the google archives yielded a lot of solutions. Here's one from MVP Chip Pearson: http://tinyurl.com/yw7md HTH Jason Atlanta, GA >-----Original Message----- >I want a cell or string of cells to flash or blink constantly when i open the spreadsheet. It does not matter if the text or background blink or flash. Is this...

Insert username into text box
I am using the fOSUserName functionality in my DB. I would like to use it to dynamically preface comments a user types into a text box. Scenario...user opens a ticket form, starts typing a comment in the text box, and Access automatically inserts their username in front of their comments (in bold typeface if possible) followed by a couple spaces, or a space dash space. Any ideas? Thanks! Paul, Use the AfterUpdate event of your text control (ex. control name = [Comments]) Me.Comments = CurrentUser & " - " & [Comments] -- hth Al Campagna Microsoft...

Formatting Cell #2
I have a block of text that I auto corrected and shows corrected in the Normal view. However, when I preview the sheet there is space between cell above it and the text in my cell. I want the text to come all the way up against the cell above it. How do I fix this? Format-Cells-Alignment tab. Set the vertical text alignment to "top." "Mike" <anonymous@discussions.microsoft.com> wrote in message news:2bedc01c46905$2321d7f0$a501280a@phx.gbl... > I have a block of text that I auto corrected and shows > corrected in the Normal view. However, when I preview t...

Picture Link
Appreciate some help here and thanks in advance. I link my pictures to the following folders C:\Documents and Settings\MyName\Desktop\Picture.jpg C:\Documents and Settings\MyName\My Documents\Picture.bmp My code: If Me!pic1a = "X" Then Forms!startpg!fmpPic!Img.Picture = "" Else Forms!startpg!fmpPic!Img.Picture = Me!pic1a End If It works on my PC but when I copied the program to another PC, it does not work. This is because of "MyName" and the other PC has a different name. Is there a way to ignore "MyName" for any PCs Regards "ChoonBoy&quo...

Picture in header
How do I get a picture in the header? This was added in xl2002. File|Page setup|header/footer tab|custom header There's an icon that looks like a picture near the far right. Steve wrote: > > How do I get a picture in the header? -- Dave Peterson If you are using a version of Excel before 2002 then check out: http://www.nwarwick.co.uk/Excel2000GraphicalHeaders.htm for a workaround. HTH Neil www.nwarwick.co.uk "Dave Peterson" wrote: > This was added in xl2002. > > File|Page setup|header/footer tab|custom header > There's an icon that looks lik...

outlook viewable text size
Hi- I have an issue where the viewable text size in Outlook is too large- when I open a msg, its normal, what everyone typically sees. But when I create a new msg or reply or fwd an existing msg, the viewable size gets huge. The font size stays the same (eg, 11), but in my msg it appears to be size 64 (font format stays 11 though). Its like looking at a normal sized font through a giant magnifying glass. This first happened when I was editing the viewable size in Word (all apps 2007 on Vista x64). Alt-tab back to Outlook and I must have moved my mouse scroll bar and the font view ...

Button Text
Can you change the text of a dialog button during run time ? There doesn't seem to be anything about doing it under the MSDN CButton help... -- Lordy "Lordy" <spam@recycle.bin> wrote in message news:MPG.1a8f677777d87d9a989918@text.news.ntlworld.com... > Can you change the text of a dialog button during run time ? I think you can use SetWindowText. -- Jeff Partch [VC++ MVP] As mentioned by Jeff, you can use SetWindowText. CButton is derived from CWnd and SetWindowText is a public method in CWnd. Alternativcely, you can use SendMessage w/WM_SETTEXT. -- Ajay K...

Extract data from a cell after a constant value
Howdy All, I have a spreadsheet that contains 1 column of data, if the cells of the column are the city names and populations of towns in the following format: Appleton, Wisconsin (WI) (pop. 70,087) The 'pop.' is always present. I want to extract just the population number (ie: 70,087) from these cells into another cell. What is the simplest way to accomplish this? Thank you, Brian On Sun, 19 Aug 2007 12:29:37 -0500, "Wolfman" <wolfmanx@charter.net> wrote: >Howdy All, > >I have a spreadsheet that contains 1 column of data, if the cells of the >...

how to change what text and feilds r sent as a "return Receipt"
Would like to change what is sent when I send a Return Receipt to someone. can't seem to find this anywhere i any documentation Splash wrote: > Would like to change what is sent when I send a Return Receipt to someone. > can't seem to find this anywhere i any documentation The sender of an e-mail with the headers requesting a "read/delivery receipt" cannot specify how that acknowledgement e-mail is composed. Ok, Where is this information pulled from? At two locations email is sent and recieved. when sent from M1 a reead receipt is requested. At M2 the m...

Text to Columns issue
Hi, The accounting program that I use does not have a well formatted excel download, so it is better to dump the data into notepad and then format it. I have created a macro to do the formatting for me. The only trouble is that if I open excel, and I run the macro, if I want to put new data in the file to run the macro on, excel has already converted the data to columns, and my macro no longer works correctly. The only way I can fix it, and have all of the data show up in column A (with | as a delimiter) is close the entire program and launch it again. Does anyone know ho...

Can pictures be centered in a picture frame in a catalog?
I have created a catalog for items we sell. I have added the pictures to the catalog through the Excel worksheet. When the worksheet is imported, all of the pictures left-justify in the picture frame. Can this be centered? ...

How do i change the cells in a column at the same time in Excell?
Christar, You post is way thin on details and to insure you get some goo feedback, it is important to take the time to be a specific as possibl about what you want to happen. That being said; here is an example of changing an entire column' formatting.. If you want to apply the same formatting to all the cells in a column click on the column letter A,B,C........, you will notice that th entire column is highlighted. Now, go straight to Format>Cells an begin selecting the formatting changes you would like. These change will be applied to the entire selected column. Hopes this helps, ...

Counting cells with specific month in
How can I count the number of cells in date format which contain a certain month Example: A 1 01/10/2009 2 01/09/2009 3 20/09/2009 4 12/10/2009 How can I count the number of cells in column A which contain an October date. The answer here would be 2. Thanks Try this formula (set the month number, 10 in this case, as needed)... =SUMPRODUCT(--(MONTH(A1:A4)=10)) -- Rick (MVP - Excel) "JRD" <JRD@discussions.microsoft.com> wrote in message news:ED76B82C-3517-4C1E-AAE0-21C0DDC84E80@microsoft.com... > How can I count th...