Understanding Sheets and Tables In Mac Numbers

Many Numbers users will try to fit everything into a single Sheet or even a single Table in a single Sheet. But the key to using Numbers effectively is to spead out the functions of your document across multiple sheets and multiple tables inside a sheet in a way that makes the most sense.

Comments: 8 Responses to “Understanding Sheets and Tables In Mac Numbers”

    Robert Aucoin
    3 years ago

    I understand the content of this video. If a sheet has multiple tables, is it possible to print just one of the tables?

    Ray Johnston
    3 years ago

    Occasionally, I somehow manage to change one of my cell formats from left-to-right orientation to right-to-left. I can reverse this using "undo", but is their an easier way?

    3 years ago

    Ray: Easier than a single keyboard shortcut? Not sure what that would be.

    Gene
    3 years ago

    Years ago I was on Windows. I get that Excel is a “sea of cells” and Numbers is a “sea of tables”. Is there a way to list or otherwise identify all of the tables in a sheet? I ask as sometimes I go back to an old workbook and as I scroll left and right I am not sure I am missing a table that exists.

    3 years ago

    Gene: I don't know about "sea of tables." The idea is to organize your document well so you should never end up with a mess on a single sheet. You can see a list of tables by just clicking on the down arrow next to the sheet name at the top.

    Fred
    2 years ago

    Gary, I want to create a numbers file with multiple sheets for each month of the year and a summary sheet for an annual budget. I have saved the "monthly master" as a template. Is there any way I can create sheets for each month by just inserting a template into a blank sheet for each month?

    2 years ago

    Fred: You shouldn't separate the date into multiple tables. If the data is the same type, it should be all in one table. Otherwise, you are limiting yourself in what you can do with the data easily.

Comments Closed.