How do I insert the "&" symbol into a header?

I typed the "&" symbol into the custom heading box, but when I click okay, it
does not appear in the document. Any suggestons?


How do I insert an image into a specific cell within a protected worksheet.
I have created an order form that is protected so users can only enter data
into specific cells. However, I would like users to be able to insert a
graphic file/image into a specific set of merged cells. Please help.

Thanks,
Scott

Hi all,

How can i insert an image into a text file and can i resize that image??

Is there a way to use the "&" symbol in a header in excel?

Excel uses that symbol as part of its page no. etc header/footer references,
and simply ignores it when simply typed in.

Thanks

how do i..switch the columns into rows and vice-versa....!!

How do I print the "&" character in a footer?

How do I copy the contents of a cell from one workbook to another (as a
formula)? I tried '=[workbook name]worksheet name!cell name' but that
doesn't seem to work

Hi,

can anyone tell me how do I insert the Worksheet Name in Cell A1 ?

Excel version 2000

Many thanks in advance for any help

Rob

--
robertguy

44 Married two kids
------------------------------------------------------------------------
robertguy's Profile: http://www.excelforum.com/member.php...fo&userid=5963
View this thread: http://www.excelforum.com/showthread...hreadid=481872

How do i change the format of a 2 digit date in months to a four digit
showing years and months?

34 = 0210
11 = 0011
45 = 0309

I have a series of months in each cell like 34. I want to create a formula
where it will show 0210. Thats 2 yrs and 10months. It can be a text format
cell.

Thanks,

how do i get the name of a newly added sheet that i add with Sheets.Add in a
vba macro in excel?

How do I delete the gridlines in a single cell in Excell 2003?

How do I change the color of a cell depending on the value of another cell(s)?

HOW DO I CHANGE THE FORMAT OF A SS# FROM 123-45-6789 (text) TO 123456789
(number) in a cell ?

XLS - HOW Do I use the results of a formula to create NAME to vlookup

E.g
cell A5 = "fred"
cell b5 = "bloggs"
cell C5 contains the formula =a5&b5
sell C5 therefore = fredbloggs

fredbloggs is the name of a 2 colunm, 10 row group of cells on another
sheet in the same XLS file

how do I enure that the value of C5 is used in this formula
=vlookup(b11,c5,2)
which is of course
=vlookup(b11,fredbloggs,2)

I'm obviously doing something wrong
CB

*** Sent via Developersdex http://www.developersdex.com ***

Hi,

can anyone tell me how do I insert the Worksheet Name in Cell A1 ?

Excel version 2000

Many thanks in advance for any help

Rob

In a Shared Workbook of Excel, how do I change the color of a Cell by simply
selecting it. For example, if I click on Cell B234 making it the Active
Cell, I want the color of Cell G234 to change to yellow.

In excel how do I protect the format of a cell but let the user change the
cell value?

If I have the date of birth, how do I calulate the age of a person?

Thanks
Doug

I'm using the formula:
=HYPERLINK("http://ngmia026180-003/viewItem&id=!A3", "View Ticket")

The number 13149 is actually in cell A3, so I want the link to be
interpreted as:
=HYPERLINK("http://ngmia026180-003/viewItem&id=13149", "View Ticket")

If I put in A3 or !A3 in the formula the link is actually interpreted as
"http://ngmia026180-003/viewItem&id=!A3"

I want the number 13149 to show up in the link instaed of the A3. How can
I pull the Value in cell A3 and insert it into the Hyperlink ? This is a
massive spreadsheet so I don't want to manually create these hyperlinks for
every ticket. I want a formula so I can copy and paste it.

I am trying to design a very simple macro where by data can be copied and
pasted to another computer programme from excel. The problem I have is that
the other software programe uses the keystroke shiftF3 to clear a field and I
cannot replicate this keystroke in excel. How would I enter these keystrokes
into a cell so that when pasted they would perform the function in the other
programme rather than trying to data enter it?

Any time I click mouse on a cell, the address of cell is needed to appear on
a fixed cell say a1. In other words if I click the mouse on cell b5 say, the
content of the cell should be "b5". How do I do this?

I know this is probably simple, but I can't seem to get it.

As a macro, I want to do is insert the date so it doesn't change everytime I
go into excel in one column, then the next column have initials appear right
next to it.

I want to set this up as a macro so it's one less thing to type. The date
and initials get typed often so I want the macro to be able to work in
another cell as well. When I tried to create a macro, it only worked in the
cell I recorded it in.

Example
Column A Column B
2/10/2005 MH

Any help would be appreciated

Any time I click mouse on a cell, the address of cell is needed to appear on
a fixed cell say a1. In other words if I click the mouse on cell b5 say, the
content of the cell should be "b5". How do I do this?

I am graphing some data in a powerpoint presentation and i need the info from
the data sheet in my presentation. How do I insert that info into powerpoint
from the excel sheet open right next to it?

Can I insert the contents of a cell into the page header or footer without
having to use a macro.

I wish to include a Report Date in the header which is not necessarily the
date the excel spreadsheet was created or modified.