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

sign

ResolvedVersion Standard

Cleide has attended:
Excel Intermediate course
Excel Advanced course

$ sign

How to copy formula down using $ sign?

RE: $ sign

Hi Cleide

when you want to copy down a formula that has dollar signs within it, the easiest way to do this is by going to to bottom lefthand corner of the cell that you want to copy down and when you pointer becomes a little black cross click and drag it down to the cells you want this copied and that should do the trick

Hope this helps

Mark East

Excel tip:

Status Bar Functions

When using the SUM, MIN, MAX, AVERAGE and COUNT functions, the result of such calculations are displayed in the worksheet.

However, if a range of cells, containing numbers, is highlighted, and then a right-mouse click is performed at the bottom right side of the status bar, then the result of those functions will be displayed.

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.09 secs.