labels

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Word Training and help » Labels

Labels

resolvedResolved · High Priority · Version 2016

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.

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

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

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


Server loaded in 0.08 secs.