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

excel.advanced.course - excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel.advanced.course - Excel

excel.advanced.course - Excel

ResolvedVersion Standard

Jon has attended:
PowerPoint Introduction course
Excel Advanced course

Excel

Easiest way to reformat a spreadsheet when pasted into a word document

RE: Excel

Hi Jon

Well jon the first thing to consider is, is this spreadsheet linked to excel and the way to find out is if you double click on the spreadsheet object does it take out into excel. If it does then you can make all the changes through excel

But if not word will look at the spreadsheet as a word object you will then have to use the formatting stuff in word

If you have the excel spreadsheet still available then you could link it to word very easy as follows

in excel select the spreadsheet and then go to edit copy, then go to the word document click the place you need the spreadsheet to be linked, then go to the edit menu and choose paste special where you will be able to paste as link

try this and see how it inproves you formatting

Mark East

Excel tip:

Printing spreadsheets without opening them first

Here's a fast way of printing a spreadsheet from Windows Explorer/My Computer.

Go to the location where the spreadsheet is saved on your computer, then right-click on the icon next to the document and select Print from the menu.

The spreadsheet will automatically open, print and close itself.

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.13 secs.