Manipulating sheets in Excel Part II. By Gail Perry

Share this content
3

Last week's article discussed methods for manipulating the sheets within an Excel workbook file. There is a lot more that can be said on the subject, so we've decided to have another Sheets session this week.

You've already learned about what those sheet tabs mean, the little Sheet1, Sheet2, Sheet3 tabs that appear at the bottom of your spreadsheet. In Manipulating Sheets in Excel, Part I we talked about how to:

  • move among the sheets

  • Increase the number of sheets

  • Decrease the number of sheets

  • Rearrange the sheets

  • Change the default for the number of sheets
  • In this session, we will learn about creating formulas that refer to data from different sheets, using the mouse to refer to cells on other sheets in your formulas, and a quick multi-sheet formula trick...

    Please Login or Register to read the full article

    Replies

    Please login or register to join the discussion.

    Page set up across multiple worksheets
    Andy is correct - this method does work in Excel 2003, but not in earlier versions. Unfortunately I'm still using Excel 2000, so Mrs Gemmell's solution of copying a "master" sheet's set-up details will be the method that I will have to use.
    Thanks to everyone for their solutions.

    Thanks (0)

    Formatting Multiple sheets
    The best way of entering the same headers and footers etc on a selected range of sheets is to use Page set-up option from the File drop down menu. Note - this will overwrite any previous formats that you may have entered.

    Thanks (0)

    Formatting across multiple worksheets
    I agree that formatting multiple worksheets by selecting several tabs is a useful facility.
    However this function does not seem to work for page set-up settings. Despite having multiple tabs selected, changes to any page set-up details such as "print from tray 3" or "format page header" only apply to the visible worksheet, and not to the other selected worksheets (this applies to Excel 2000 - I assume it's true for later versions too).
    Is there a way to overcome this?

    Thanks (0)