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 training microsoft - Excel Advance
excel training microsoft - Excel Advance
Resolved · Low Priority · Version Standard
Fri 11 Jan 2008, 11:10Delegate Mariagiulia said...
Mariagiulia has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Excel Advance
In the Naming range for ormulas, if you name the range and you want to change it after finished the formulas, how can you do it? E.G. I have named the range cell_00 and I wnat to call it Sales_00, how do I do? Thanks
Fri 11 Jan 2008, 14:58Delegate Paul said...
RE: Excel Advance
Insert > Name > define.
It should automatically update your formulae once the cells have calculated. Alternatively, if you have calculation set to manual (you can check this by going tools > options... and selecting the 'calculation' tab) then press F9 and the formulae will update
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:Move to edge of data blockWhen data is held in a block, however large, use the Ctrl key with your cursors to move quickly to the far edge of the block. Works with all 4 direction keys. |
