How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask John D Your Own Question

John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9666
Experience:  Bachelor of Science - Engineering Consultant
Type Your Microsoft Office Question Here...
John D is online now
A new question is answered every 9 seconds

Can I get Excel to name a sheet with the headline from cell

Customer Question

Can I get Excel to name a sheet with the headline from cell A1? Or the other way around - sheet name appears in cell A1?
Submitted: 4 years ago.
Category: Microsoft Office
Expert:  John D replied 4 years ago.
Hello and welcome to JustAnswer. I look forward to assisting you today with your question and providing the best answer possible.



Paste this formula in A1 and it will return the current sheet name




Hope this is ok. Let me know if you have any questions



Remember, if for any reason you are unsatisfied with my answer, we can continue the conversation until you’re satisfied and Accept my answer. I can address follow up questions at no extra charge and I’m always here to help. Thank you for using JustAnswer!
John D and 3 other Microsoft Office Specialists are ready to help you
Customer: replied 4 years ago.
It worked great after I finally saw that American Excel uses "," in formulas instead of ";" like in Sweden!
So now you know next time you chat with a Swede...
Expert:  John D replied 4 years ago.

Great. Thanks


Yes you are right the US version uses commas to separate the arguments in the formula, while some European versions use the semi colon. Glad you figured it out :)




Related Microsoft Office Questions