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