Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

cell reference

ResolvedVersion Standard

Saroja has attended:
Excel Introduction course

Cell reference

How do you copy the formula from one cell to another?

RE: cell reference

Click in the cell, copy the formula from the formula bar above the sheet. Press the enter key before selecting any other cell. Then select the target cell and paste in the formula. Also, if you right clik and select paste append you can copy the values/formulas etc.

Excel tip:

Showing all menu items

If you go into a pull down menu you usally find that you get a selection of items(this is the default) or sometimes everything. If you only get a selectiopn you have to go to the double arrows at the bottom of the menu and click it to get all of the hidden items.
To turn this off so that you always get everything, go to Tools / Customize / Options Tab / "Always show full menus". Make sure there is a tick in the box and you will always have every item.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.