98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Ranges
Excel Ranges
Resolved · Low Priority · Version 2007
Tue 19 Jan 2010, 16:28Delegate 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:49Trainer 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 information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:New to Excel 2010 - Sparklines!Excel 2010 includes a new feature called Sparklines which are tiny charts that fit into a single cell and plot data in cells from the worksheet. There are a host of formatting and styles that can be applied to them and they are really quite interesting. |
