Microsoft Word

Dleopoldi914

New Member
Joined
Nov 9, 2012
Messages
49
I am creating wedding invitations and created my first label with the formatting I wanted. I was curious if there is a shortcut key similar to alt+e+s in excel that I can copy paste the format from the first label on to all the rest in microsoft word?
 
Last edited:

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Good morning! I'm not sure what type of formatting you have but the "Format Painter" works for most formatting. It's icon is a little paint brush and can be found with the cut and copy commands.
Hope this helps!
 
Upvote 0
I have a bunch of text. I format the first label the way I want. Now how do I copy and paste just that format onto all the other labels. In excel I can use alt+e+s and select format and it will format the cel the same as the area I have cut and pasted from. Any advice?
 
Upvote 0
Click on the format painter and highlight the contents of the first label. Your cursor will turn into a little paint brush, then move onto the next label and highlight. This will only bring across the formatting, no text or pictures.

Clicking the format painter once will only copy the formatting once. If you want to do multiple labels based on the same formatting, double click the icon first.
Cheers!
 
Upvote 0
Can you just do a mail merge, so that the adressee is a "field", and everything else is static, and the list of addressee is imported from elsewhere?

Sorry for the generic-ness of my reply, I've only watched my wife do mail merges, not actually done them myself.
 
Upvote 0
Hi Rob,
I'm not sure what you mean by the addressee being a field. Normally when you do a mail merge, you move large quantities of information (ie names, addresses and postal codes) from one format (normally a spreadsheet) into a label or document. Can you give me an example of what you are trying to do?
Cheers!
 
Upvote 0
If you're doing a label mailmerge, simply clicking on 'Update Labels' after formatting the first one should result in all the labels being updated to reflect the first one's content and formatting.
 
Upvote 0

Forum statistics

Threads
1,225,635
Messages
6,186,128
Members
453,340
Latest member
Stu61

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top