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

Excel Ranges

ResolvedVersion 2007

Tue 19 Jan 2010, 16:28 Delegate Shreyas said...

Shreyas has attended:
Project Intro Intermediate course
Excel Intermediate course
Excel Advanced course
Visio Advanced course
Project Management - Framework & Processes course
Presentation Skills course

Excel Ranges

Why do you use a ! in ranges?

Thu 21 Jan 2010, 08:49 Trainer Simon said...

RE: Excel Ranges

Hi Shreyas,

Thank you for your question.

An exclamation mark is used when creating formulas relating to cells in another worksheet or workbook.

The following formulas shows a link to cell C1 in Sheet2:

=Sheet2!C1

The exclamation mark separates the Sheet Name from the cell.

I hope this answers your question.

Regards

Simon

Wed 27 Jan 2010: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Sorting data stored in rows

Primarily Excel is set up to sort data that is stored in columns rather than rows.

It is possible to get Excel to sort data stored in rows however.

Click in the row you want to sort, or select the cells in the rows you wish to sort.

Go to Data - Sort, then go to the Options button in the bottom left corner of the Sort dialogue box.

View all Excel hints and tips

Excel Ranges

Excel Ranges

RE: Excel Ranges

Excel articles

Excel tip:

Sorting data stored in rows