Bringing excel tables into word

Resolved · Low Priority · Version 2003

Thu 13 Nov 2008, 11:35 Delegate Amandeep said...

Amandeep has attended:
Excel Introduction course
Word Intermediate course

Bringing excel tables into word

can you format an excel table brought into word.

Thu 4 Dec 2008, 15:25 Trainer Amanda said...

RE: bringing excel tables into word

Hello Amandeep

Thank you for your question and welcome to the forum.

Apologies for the unusually long delay in answering your question.

If you select your Excel data and copy it, then when you paste into Word there should be a small clipboard icon that comes up on the screen, which you can click on to access pasting options.

If you select the Match Destination Table Style, this will paste the data in as a table usually formatted to Table Normal style. Then you can format as usual.

I hope this helps.
Amanda

Wed 10 Dec 2008: 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:

Undo Autoformt Features

Later Microsoft Word versions have auto-formatting features. But, we don't always want our Web addresses hyperlinked; we do not always want our spelling corrected.

Select from the menu, Tools > AutoCorrect options from the drop-down list to toggle these features, You will be able to tweak Word's settings to your liking from the dialog that pops up. However, if you'd rather keep the automatic features turned on, you can easily undo an auto-format immediately after it has been applied.

For example when typing and Word creates an automatic hyperlink, just hit backspace as soon as Word makes the automatic change. It will revert back to your original string. You can also use the undo feature (CTRL+Z).

View all Word hints and tips