how do i change a spreadsheet into labels?
 

if you have a "simple" process for this I'd appreciate it. If its not so
simple I need that too!

Hi

if you mean formulas (=A1*B1) in to values, ie the result of the previous
calculation ... then
select your worksheet
choose copy
choose edit / paste special - values
(do this on a copy of your workbook first, just in case it isn't what you're
after)
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"saveusonthemisssissippi"
wrote in message
...
if you have a "simple" process for this I'd appreciate it. If its not so
simple I need that too!

Not sure exactly what you want.

Do you want to see the formulas themselves as labels so you can document
your worksheet? If so, press the Ctrl-~ key combination

Do you want all the formula results converted to static values? Export your
worksheet as a .txt or .csv file

Something else? Give us more of an explanation

"saveusonthemisssissippi" wrote:

if you have a "simple" process for this I'd appreciate it. If its not so
simple I need that too!

Or do you want to print labels, based on info in a spreadsheet?

"Duke Carey" wrote:

Not sure exactly what you want.

Do you want to see the formulas themselves as labels so you can document
your worksheet? If so, press the Ctrl-~ key combination

Do you want all the formula results converted to static values? Export your
worksheet as a .txt or .csv file

Something else? Give us more of an explanation

"saveusonthemisssissippi" wrote:

if you have a "simple" process for this I'd appreciate it. If its not so
simple I need that too!

I'm trying to take an excel spreadsheet and make mailing labels.

thnx for your responses!

"saveusonthemisssissippi" wrote:

if you have a "simple" process for this I'd appreciate it. If its not so
simple I need that too!

Very impressive powers of deduction!!!

"Kassie" wrote:

Or do you want to print labels, based on info in a spreadsheet?

"Duke Carey" wrote:

Not sure exactly what you want.

Do you want to see the formulas themselves as labels so you can document
your worksheet? If so, press the Ctrl-~ key combination

Do you want all the formula results converted to static values? Export your
worksheet as a .txt or .csv file

Something else? Give us more of an explanation

"saveusonthemisssissippi" wrote:

if you have a "simple" process for this I'd appreciate it. If its not so
simple I need that too!

Best to use Word for the mailmerge operation.

For help on Word mail merge using Excel as the data source.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm

And a training tutorial for creating envelopes and labels.

http://office.microsoft.com/training...RC010390291033


Gord Dibben Excel MVP

On Fri, 1 Apr 2005 12:11:02 -0800, "saveusonthemisssissippi"
wrote:

I'm trying to take an excel spreadsheet and make mailing labels.

thnx for your responses!

"saveusonthemisssissippi" wrote:

if you have a "simple" process for this I'd appreciate it. If its not so
simple I need that too!