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

excel training courses - Transferring data

ResolvedVersion Standard

Thu 12 Apr 2007, 09:47 Delegate 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

Wed 18 Apr 2007, 13:31 Trainer 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

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Conditional formatting for cells that return text , not picked up by Go to command

If you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text.

Then try this. Select the range the formula cells appear in on your sheet. Format, select Conditional Formatting menu. In the dialog box under Condition 1, select "Formula Is" from drop down. Next to it in the Formula Box, enter the formula =Istext(A1. Click Format button , choose desired formatting settings and click OK. To go ahead and apply the conditional formatting click OK to accept

View all Excel hints and tips

excel training courses - Transferring data

Transferring data

RE: Transferring data

Excel articles

Excel tip:

Conditional formatting for cells that return text , not picked up by Go to command