Excel

The UK's most regular instructor-led training courses.
Training information: excel+training · Advanced.excel · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Excel

Sophie has attended:
Excel Intermediate course

by - delegate Sophie [1 post] (2008 Mar 11 Tue, 16:24) Reply

What does the $ represent?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	1	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	3	book now	£475	£495
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	4	book now	£475	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	3	book now	£475	£495
2003	2008 Oct 23 Thu + 24 Fri	Southwark	4	book now	£475	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel

by - trainer Mark gold contributer [180 posts] (2008 Mar 14 Fri, 16:13) Reply

Hi Sophie

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

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

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@microsofttraining.net

· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Microsoft Excel Training Course
· How to Create Better Excel Spreadsheets: Part Three
· Benefits of learning about Excel charts
· Microsoft Excel's Best Kept Secret

Please browse our web site to find out more about
excel+training and other Microsoft training courses.

Excel tip:

Select only cell that contain text to lock format

For selecting cells that only contain Text in Excel

By selecting cells that only contain text, you can delete, fill or protect cells of this type.

Use short cut to Go to box (F5) or Edit, Go to
In the dialog box, click special button & select Constants and only check text or any other desired type.

Click OK.

And text cells will all be highlighted for you to apply format. Please note only works on one sheet at a time.

View all Excel hints and tips