How to Split the Page in Numbers

I read the link and have decided to stay with Excel and will not bother to learn
Numbers. The lack of the ability to split the screen is a show-stopper.

That's too bad. I think in many ways Numbers provides a more enlighten approach to these problems than Excel. The split window pane feature in Excel is a solution required to address a problem caused by the fact that Excel solutions must be monolithic. Using Numbers provision for many tables avoid the problem to begin with.

I could not find the the little tab in the upper right corner of an Excel worksheet

This is going to be your first hurdle. Thinking, and working, like you would in excel has to be unlearned. If you cannot live without certain features from other programs, you should stay with those programs. At least until Numbers goes to V2, then recheck again.

Hope you find a good workaround, or at least find a way to work withing the limits of the new program.
Jason

I am working on making the transition to Numbers, and for the most part love the flexibility of the new program. However, this lack of being able to open a new window in the same sheet is frustrating. Let me give you my situation, and if anyone has any thoughts I'd be most appreciative!

I run a competition that has 30+ competitors all needing separate scoresheets. Those overall scores for each group need to be summarized on a separate page. In Excel, I had a separate sheet for each competitor, and then I linked cells from those sheets to the summary sheet. This was made easy as I could have one window open with the individual competitors sheet, and another window open with the summary sheet.

When I tried to implement this in Numbers (admittedly I approached the problem with an Excel mindset) I set up my separate sheets for each competitor, and now that I'm in the stage of making the summary sheets, I need to click on the cell in the summary sheet, find the referenced sheet in the sheet list, click on it, find the proper cell, click on it... There are over a dozen references per sheet. I have not been able to find a satisfactory work around in Numbers.

Even if I set up each individual competitor as it's own table, and the summary as it's own table, all in the same sheet, I would still not be able to view both the summary and the competitor tables at the same time without scrolling back and forth. I'm not seeing how Numbers makes my life easier in this regard.

Any thoughts?

Diceplaya wrote:
Select the columns that you don't want to see. Place your mouse over the Top Row (for instance over A-R, I'd put my mouse over R). Click Hide. and there you go.

I don't see how that approach is much help if I am scrolling vertically and simply want my headers to stay in view.

Hello

I will repeat again my well known responce:

Numbers is not designed to fit 100% of the needs of 100% of the numbers crunchers.

If a tool don't fit your needs, drop it and use the one which match them !

All of us where offered a 30 days FREE trial version.
It seems that it's sufficient to see if a tool is the one we need.

Even if Apple accepts to add the feature you are asking for, it will not be before the next major revision which means iWork'09.


Yvan KOENIG (from FRANCE mardi 4 décembre 2007 19:21:21)

KOENIG Yvan wrote:
Hello

I will repeat again my well known responce:

Numbers is not designed to fit 100% of the needs of 100% of the numbers crunchers.

If a tool don't fit your needs, drop it and use the one which match them !

I don't think any reasonable person expects any piece of software to fit 100% of their needs. It is quite a handy, pat and valueless response to imply that they do.

It does seem a shame that Numbers wasn't designed to effectively handle more data than will fit on one page or to be useful as a tool for a group of people to discuss, for example, a budget, which would contain at least 14 columns of data and many rows of accounts.

Tools like keynote or powerpoint are designed to lower the cognitive value of presentations and discussions. I had hoped that numbers could be used with a group discussion to actually raise the value of certain topics.

Hello

What are you hoping?

Here we are users trying to help users.

We can't say you: "OK guy what you ask for is fine, we will add it tomorrow".

Numbers is in a certain state for months.
This forum is not the correct channel to ask for new features (mainly when the repetition changes them as rant).
The official channel is: *Go to "Provide Numbers Feedback" in the "Numbers" menu* and describe what you want.
I'm not sure that your wishes will be implemented but what is sure is that new features will not be added before iWork'09.

So, even if you feel that sad, if Numbers don't fit your needs, at least at this time, it would be better to use an other tool.

Yvan KOENIG (from FRANCE dimanche 9 décembre 2007 12:02:20)

This ends up being a bit of a philosophical question has been discussed before in this forum. You might want to read:

http://discussions.apple.com/thread.jspa?messageID=5327835

The split pane and freeze panes functions are two things Excel does way better than Numbers.

I use both programs often--daily, and this is a definite shortcoming of Numbers.

Select the columns that you don't want to see. Place your mouse over the Top Row (for instance over A-R, I'd put my mouse over R). Click Hide. and there you go.


Stephon