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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
microsoft excel

ResolvedVersion 2007

Catherine has attended:
Excel Intermediate course

Microsoft Excel

How do I cut information from a spread sheet into a word document if it's in a table format?

RE: Microsoft Excel

Hi Catherine

Thank you for your question. First highlight the data you would like to copy in Excel. Right click your selection and choose copy. Switch to Word and again right click in your document and choose paste.

After pasting you will see a small Paste icon (clipboard) at the lower right corner of the data. Left click on the icon and choose how you would like Word to receive this information. By default Word turns the data into a Word table.

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew

Tue 2 Feb 2010: Automatically marked as resolved.

Excel tip:

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function



View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.