Formatting

Resolved · Low Priority · Version 2003

Thu 16 Jul 2009, 16:44 Delegate Aisha said...

Aisha has attended:
Excel Intermediate course
Excel Advanced course

Formatting

How can I remove formats when copying & pasting between workbooks?

Fri 17 Jul 2009, 18:00 Trainer Andrew said...

RE: Formatting

Hi Aisha

Thank you for your question. When you paste data into your workbook Excel puts a Smart Tag in the lower right corner of the pasted data. Click on the Smart Tag and you will find one of the choices allows you to paste the data in line with destination sheet's formatting.

I hope this helps.
Kind regards,
Andrew

Fri 24 Jul 2009: Automatically marked as resolved.

Excel tip:

Cycling through Absoulte cell references

If you are working with formulas in excel and need to convert your formula to an absolute formula, instead on manually adding in the $dollar signs you can highlight the specific part of your formula and press the F4 key.

You can cycle through all the absolute options by pressing the button (up to four times)

View all Excel hints and tips

Formatting

Formatting

RE: Formatting

Excel articles

Excel tip:

Cycling through Absoulte cell references