Help on Excel

[Oreo]

Ok this is a simple request, but i cannot find the answer.

I am doing I.T. Coursework on Microsoft Excel 2003. I want to insert a picture but have the cells ontop of it so i can enter data and see it, so i basicly want a background for my table of data. However i can only manage to get a background that covers the entire Excel sheet, i don't want this as it will look stupid for what i am doing.

Anybody know how ?

 

[superdave1984]

So you want it to be only at the bottom of the sheet? Like a footer sort of?

 

[bla!!]

Whopps, didn't read the whole post before replying.

 

[Oreo]

So you want it to be only at the bottom of the sheet? Like a footer sort of?

I have a table in the middle of the sheet, i just want the background on the table and nowhere else.

 

[leonardmp92]

From help menu:

Add a sheet background

Click the worksheet that you want to display with a sheet background. Make sure only one worksheet is selected.

On the Format menu, point to Sheet, and then click Background.

Select the picture that you want to use for the sheet background, and then click Insert.

The selected picture is repeated to fill the sheet.

 

[Oreo]

This is my problem, i do not/can't have my background image filling the whole sheet. I only wish it to fill my table.

Never mind guys, thanks for your help.

 

[KSoD]

http://office.microsoft.com/en-us/excel/FX100487621033.aspx

You know Office Online has a wonderful search feature. Not many people here use Excel on a daily basis to know your answer.

 

[bla!!]

He wants the background to not tile, which as far as I have found is not possible in 2003, only in 2007.

 

[Lexluethar]

Not sure if you know a lot about VB in Excel, but i'm sure what you are wanting to do is create some type of form or order sheet that has either text next to text boxes people enter information, or a picture in the background that flows well with where people enter text.

My suggestion would be to use a VBA form for this. You can put a background picture on the size of the VB form, it can resize to however large you want the form to be, and you can dynamically change where text boxes are located (within excel it can be a pain to get text box EXACTLY where you want them since in order to do so you have to resize other rows/columns).

Use a VBA form if you have the ability.

 

[Oreo]

Okay thanks. I'll give that VBA thing ago. If not i'll get Excel 2007 from somewhere.