Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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! |
#4
|
|||
|
|||
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! |
#5
|
|||
|
|||
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! |
#6
|
|||
|
|||
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! |
#7
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA to change size of data labels? | Charts and Charting in Excel | |||
How do I print labels from an Excel spreadsheet | Excel Discussion (Misc queries) | |||
Convert Word labels to Excel spreadsheet | Excel Discussion (Misc queries) | |||
can I print labels using data from an excell spreadsheet | Excel Discussion (Misc queries) | |||
How do I change a spreadsheet from all caps to "Proper" | Excel Discussion (Misc queries) |