98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Intermediate
Excel Intermediate
Resolved · Medium Priority · Version 2003
Stefania has attended:
Excel Introduction course
Outlook Advanced course
Outlook Introduction course
Excel Intermediate course
Excel Advanced course
Word Introduction course
Word Intermediate course
Word Advanced course
PowerPoint Introduction course
PowerPoint Intermediate Advanced course
Dreamweaver Introduction (2 days) course
Excel Intermediate
Hi,
I would like to know in which way I can use Block names, why it is useful and in which way I can also use the same names as part of a formula.
Thank you veru much
Stefania
RE: Excel Intermediate
Hello Stefania
Thank you for your question.
Block names is used to give a name to a range or group of cells.
Once a range has been named, you can use the name to navigate to the cells, or use the name in a formula to refer to the cells in the range.
To give a name to a range of cells:
1. Select (highlight) the cells.
2. Click in the Name box (to the left of the formula bar), and enter a name for the range - the name cannot contain spaces (e.g. Jan_Sales). Then press Enter to apply the name.
If you click away from the cells you have selected and use the dropdown arrow at the right hand side of the name box, you can select the name you just entered, and Excel will automatically select the cells in the range - so you can use the name to navigate.
If you create a formula which refers to the cells in the named range you have created, you can use the name to refer to these cells instead of the cell references, e.g. =SUM(Jan_Sales) instead of something like =SUM(B5:B50)
We covered block names as part of the Excel Advanced course.
Kind regards
Amanda
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:Quickly insert a functionIn Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog. |