Amar - Jul 6, 2009 at 08:26 AM
 Trowa - Jul 6, 2009 at 08:55 AM
Iam pretty new to Excel usage..The problem is , I would like to add few columns in one excell sheet and display the result in other sheet..Can you please guide me to write a formula..Thanks in advance...

1 response

Hi Amar,

To add a column, right click the top of the column (on the letter) and choose insert.

To copy the data to another sheet, in your destination sheet you type in the top cell: =Sheet1!A1 (=, name of the sheet, !, column letter, row number.)
Select the cell, left click on the bottom right corner of the cell and drag it down as far as you want.

Hope this helps.

Best regards,