Here's the question you clicked on:

55 members online
  • 0 replying
  • 0 viewing

elmenol1

  • 3 years ago

what is a quick way to format the headings in all of the worksheets

  • This Question is Open
  1. Chris2332
    • 3 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Try this... found it in a forum. You can set up identical headers in all worksheets by grouping them all and apply the header once. Right-click on a sheet tab and click on Select All Sheets. Then click on File | Page Setup | Header/Footer tab then click Custom Header and enter your text into one of the three panels. If you want to enter the current date, click on the symbol which looks a bit like a calendar - "7" covering "6". Once this is done, OK your way out of it, and then right-click a sheet tab once more and Ungroup Sheets.

  2. bookworm00981
    • 3 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    chandoo.org/wp/2010/11/15/formatting-multiple-sheets/

  3. Not the answer you are looking for?
    Search for more explanations.

    • Attachments:

Ask your own question

Sign Up
Find more explanations on OpenStudy
Privacy Policy