Labels

Resolved · High Priority · Version 2016

Thu 13 Apr 2017, 12:30 Delegate Jane said...

Jane has attended:
Word Intermediate course
Word Advanced course

Labels

Please can you tell me how to copy and paste addresses from a Word perfect document into an excel spreadsheet. I can normally do this but when i have used the Control C and Control P functions to do this, the addressed is copied onto multiple cells rather than into just one cell. Please can you advise how I can copy and paste an address into just one cell so that i don't have to retype the whole list. Thank you.

Tue 18 Apr 2017, 12:16 Trainer Jens said...

RE: Labels

Hi Jane,

Thank you for the forum question.

You can paste multiple lines in one cell.

if you click in the cell or on the formula bar so you see the blinking cursor and then paste you will have multiple lines in one cell. it is more time consuming because you can't do many fields at once.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Tue 25 Apr 2017: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Word tip:

Assign shortcut keys to styles

If you're a fan of using styles, you can create your own shortcut keys to apply styles quickly.

Go to Tools - Customise, then to the Options tab. Click on the Keyboard button on this tab.

Scroll down the list displayed on the left, until you see Styles. Click on Styles to select it, then you will see a list of styles currently available for use on the right.

If a style you wish to assign a shortcut key to does not appear in the list on the right, close out of the dialogue box, apply the style, then follow the steps above again - you should then see the style listed.

Enter your shortcut key combination in the 'Press new shortcut key' box. If the shortcut keys selected are already assigned to another function in Word, it will be displayed in the box.

If you want to overwrite the existing function for the shortcut keys you have chosen, click Assign.

If you wish to assign a unique set of shortcut keys, use Backspace to remove the shortcut keys you have typed in; then try typing in another key combination. Click Assign when you have a key combination you are happy with.

View all Word hints and tips