Dark Light

Numbers Tip: combine related spreadsheets into one file.

Tagged: 

  • Creator
    Discussion

  • Unknown Member

      Numbers will let you have multiple sheets in one file just like tabs in a browser. For individual spreadsheets that are used together it makes sense to convert many separate files into one file with many different sheets. It is simpler to find and open one file instead of several.

      Examples:

      1. Book file with separate sheets for Books to Read, Books Read, Favorite Authors and Read Again.

      2. Car Service file with a sheet for each vehicle listing every service with date, cost, mileage and what was done. This file is easily searched for your last battery or wiper replacement or when you had a major service unnecessarily being offered to you again.

      3. Money and Taxes:

      a. Money file updated monthly with one sheet for bank cash and investment holdings, another for dividends and sales gains with a YTD total and a third for all taxable income and gains. The last sheet gets some of its data from the 2nd sheet.

      b. Tax Forecast sheet for the current and next year to guess at estimated tax funds needed.

      A safe way to try this approach is to duplicate one of the files and then copy and paste in the other files. The sheets can be dragged into a different order and have very different layouts. It is also easy to undo this combination by duplicating the combined file and deleting all but one sheet.

      Thumbs
      Thumbs
      • Mike Kwasniak
      1

    Log in to reply.

    Free 30-Day Trial!

    Sign up today and attend up to 4 meetings to see what we are about!

    Skip to content