sign

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

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

$ sign

resolvedResolved · Low Priority · Version 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:

Outlining - ungrouping rows or columns

Highlight want you want to ungroup and press ALT + SHIFT + right cursor arrow

View all Excel hints and tips


Server loaded in 0.09 secs.