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

signs

ResolvedVersion Standard

$ signs

Please can I have more info on $ signs

RE: $ signs

Hiya Mia

How are you today hope you enjoyed the training course on Monday

To give you more explaination on the use of dollar signs will be as follows

when you need dollar signs there is a reason, this is so you can always look in one place for that part of the formula here is an example of using the dollars =d4+h7*f6+$h$25

You will then be using this cell for any copied formulas to other cells

you can have have the dollar signs in four different way these are below

H25 - relative, means will change when copied
$H$25 - permanent cell, means this will remember the cell
$H25 - permanent column, means will remember the column
H$25 - permanent row, means will remember the row

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please click reply or post it as a new question and we should be able to answer that!!

Hope this helps

Mark East
mark@stl-training.co.uk

Excel tip:

New Normal Worksheet

Do you want all your worksheets to confirm to a certain look? Then change the Defaults!!!
1. Press Shift+F11 to create a new worksheet
2. Press Ctrl+A to select (higlight) all cells, Press Ctrl+1, make any formatting changes then click OK.
3. Press F12 (Function 12 key) click in the Save As Type, drop down, then select Template (*.xlt)
4. Click in the Save in drop-down, then find the folder; c:_program files_microsoft office_office_start. (For the underscores shown use backslash)
Name your templete sheet.xlt, then press Enter.
Sheet.xlt is used when you insert a new worksheet (Shift+F11)

Note: These changes are permanent changes on your PC.

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.