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 » Naming Functions
Naming Functions
Resolved · Low Priority · Version 2007
Sarah has attended:
Word Advanced course
Excel Intermediate course
Excel Advanced course
PowerPoint Intermediate Advanced course
Naming Functions
Can you apply naming ranges to all work sheets within a workbook with same formats?
RE: Naming Functions
Dear Sarah
Thank you for attending the Excel courses. I hope you enjoyed the courses and benefited from them.
I am not sure I fully Understand what your question means!!
Do you mean if the same cells in different sheets can be given the same name using the Range Name facility if all the sheets had the similar data?
The answer to that question is unfortunately NO!! Normally when you select a range of cells and keeping the CTRL button pressed select the other cells in the other sheets and name those cells using the name Box. It will only use the first range of cells that you selected!!
So you cannot use multiple cells in different sheets but however you can use multiple cells that are not together on the same sheet and give them names.
I hope this helps If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn
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:Get back to active cellIf you have scrolled away from the active celland want to get back t it quicly you can Ctrl and Backspace to get back |