excel

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

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

Excel 2007

resolvedResolved · Low Priority · Version Standard

Excel 2007

Please can you explain a little more on $ signs

Edited on Fri 14 Mar 2008, 10:13

RE: excel 2007

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:

Multiple Lines of Text in a Cell

As an alternative to the Text Wrapping facility, type a word or two, press Alt+Enter to get a new line, type more text, and continue the process for as many lines as you need. Enter as normal when you have finished.

The line break is not affected by changing the column width, as text wrapping. To remove this you must edit the cell and remove the invisible character and replace with a normal space.

View all Excel hints and tips


Server loaded in 0.08 secs.