1 Workbook, 2 Sheets: Both Positioned (x = 0 pt and y = 0 pt) but Sheet #2 is Positioned Slightly More to Right?

Question

Level 1

51 points

1 Workbook, 2 Sheets: Both Positioned (x = 0 pt and y = 0 pt) but Sheet #2 is Positioned Slightly More to Right?

I was wondering how to get both sheets to look like that are in the exact same position (x and y) when I click from one sheet to the other so it doesn't "jar" the eyes and look out of alignment?

Image 1 is correct and neatly aligned to the left margin.

Image 2 is over to the right more despite same x = 0 pt and y = 0 pt positioning?

I've red highlighted the top left of image 2 / Sheet 2 to show that it is wider here causing Sheet 2 to be more over to the right. Even the vertical row numbers in that rows column are wider in Sheet 2 and the top left circle is not centred above the column showing row numbers as they are in Sheet 1?

Any ideas how to get them to be positioned the same would be gratefully appreciated?

MacBook Pro 15″, macOS 13.0

Posted on Apr 1, 2023 1:54 AM

Reply

Answer 1

Badunit

Level 7

30,444 points

Apr 1, 2023 10:20 AM in response to Bardonicloud

Your one table has more rows than the other (1000+ vs <1000). It is making room for the additional digits in the row numbers.

Reply

Answer 2

Bardonicloud Author

Level 1

51 points

Apr 5, 2023 1:15 PM in response to SGIII

I missed this reply. It is slightly better following your suggestion and when I switch between sheets to see if it "jars the eye" however I can't figure out why that top left circle is not sitting directly above the first column with all the corresponding Row nos as it does in every other sheet?

And bear in mind when I move that circle it has now put approximately 50 smaller charts out of alignment as the circle moves those charts but not the table, nor the big main 4 charts?... so I had to undo that move to get the charts back into alignment as they have adjacent cells next to the charts that have writing showing max min values next to the charts?

Not sure why this has happened as I haven't touched the circle or the x=0 and y= o or the Align Left function as far as I know (before the suggestions here)?

Reply

Answer 3

Bardonicloud Author

Level 1

51 points

Apr 5, 2023 1:19 PM in response to Badunit

Cheers @Badunit!

Right, that explains it... 1403 Rows.

Reply

Answer 4

SGIII

Level 8

37,550 points

Apr 1, 2023 5:25 AM in response to Bardonicloud

Have you tried giving the tables a little space. Instead of x=0, y=0, maybe position it a little down and to the right from the origin?

BTW, if you're new to Numbers I highly recommend having a look at the User Guide via Help > Numbers Help in your menu. Also at the templates at File > New in the menu.

Numbers as you probably know does not try to be an Excel clone. Most formulas work the same, but it has a different design philosophy and vocabulary.

Numbers does not have "workbooks." That's an Excel term. The closest equivalent in Numbers is "document" or "spreadsheet." The equivalent of a "worksheet" in Excel is "sheet" in Numbers (a tab). Each sheet in Numbers has a blank canvas on which you place tables, charts, shapes and other objects.

Numbers often works best with multiple smaller tables rather than a big expanse of cells.

SG

Reply

1 Workbook, 2 Sheets: Both Positioned (x = 0 pt and y = 0 pt) but Sheet #2 is Positioned Slightly More to Right?

Similar questions