Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses - Transferring data

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel training courses - Transferring data

Resolved · Low Priority · Version Standard

Reply Thu 12 Apr 2007, 09:47Delegate Maura said...

Maura has attended:
Excel Intermediate course

Transferring data

when transferring data from a table in word to an excel spread sheet, how do i get the cells to remain the same default size, while still keeping the information in the cell?

thanks maura

For upcoming training course dates see: Pricing & availability

Reply Wed 18 Apr 2007, 13:31Trainer Amanda said...

RE: Transferring data

Hi Maura

Thanks for your question.

Can I just clarify, when you refer to the cells remaining the same default size, do you mean getting the data to paste from Word so that each of the columns and rows in Excel are exactly the same width and height as the columns and rows in the table created in Word?

thanks
Amanda

Excel articles

· Excel in the Home Office
· Excel Charts As Easy As Pie
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· What's Better Than the Help Function in Excel? Microsoft Training
· How To Use The Page Layout Features In Excel 2007 And Excel 2010

Excel tip:

Saving your Excel Spreadsheet as a CSV File

In situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps.

Click the File tab and click Save As.
Enter a name in the File name field.
Click the drop-down arrow next to the Save as type field to select the file type. Scroll down the list and select CSV (comma delimited) (*.CSV)
Click Save

The data will now be saved to a separate CSV file which can be used in different applications.

View all Excel hints and tips