Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

ResolvedVersion 2003

Wed 29 Oct 2008, 16:49 Delegate Ashley said...

Ashley has attended:
Excel Introduction course

Excel

How do you transfer formulas across different sheets ?(ie use a cell on sheet 1 as part of a formula on sheet 2)

Thu 30 Oct 2008, 13:52 Trainer Amanda said...

RE: Excel

Hi Ashley

Thank you for your question and welcome to the forum.

When you are putting the formula together, use your mouse to go to the sheet you wish to select the cell from and click on the cell to enter it into your formula.

It is important when you are constructing formulas across different sheets that you always press the Enter key as soon as you have finished putting the formula together.

I hope this helps.
Amanda

Training courses

98.7 % recommend us

More live stats...

Training information:

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

Excel

Excel

RE: Excel

Excel articles

Excel tip:

Saving your Excel Spreadsheet as a CSV File