Manipulating sheets in Excel Part II. By Gail Perry

Kashflow logo
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

    The full article is available to registered AccountingWEB.co.uk members only. To read the rest of this article you’ll need to login or register. Registration is FREE and allows you to view all content, ask questions, comment and much more.

    Share this content

    Replies

    Please login or register to join the discussion.

    avatar
    By johnm41
    28th Sep 2007 13:39

    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)
    avatar
    27th Sep 2007 17:54

    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)
    avatar
    By johnm41
    27th Sep 2007 12:16

    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)