Editing Multiple Sheets

Question

Level 1

0 points

Editing Multiple Sheets

Is there a way to edit multiple [Shift-Select] Sheets in Numbers. Specifically I have a dozen individual sheets that I'm trying to adjust the margins on and print without gridlines.
I know how to do this on an individual sheet but it's rather tedious doing so across multiple sheets.

Thanks you.

MacBook, Mac OS X (10.5.6)

Posted on Dec 17, 2008 2:51 PM

Reply

Answer 1

KOENIG Yvan

Level 8

41,807 points

Dec 18, 2008 2:20 AM in response to jytessier

Yes we may but we must use a precise protocol.

Shift-select the Tables (not the sheets).
From the Format Bar, select the menu allowing us to define the kind of line and set it to none.

When this is done, always in the Format Bar, we may select the menu allowing us to select the lines to edit. Select the cross which apply to cells separators.

If you apply this protocol, the lines will be removed in every selected tables.

If you start by the menu allowing us to select the lines, only one table will be modified.

Feature or bug, I don't know.

Yvan KOENIG (from FRANCE jeudi 18 décembre 2008 11:20:08)

Reply

Answer 2

jytessier Author

Level 1

0 points

Dec 18, 2008 9:26 AM in response to KOENIG Yvan

Salut Yvan,
Seems I can't Shift-Select the tables individually only the sheets. And when I select a multitude of sheets, the border selection drop down from the Format Bar is greyed out and un-selectable.
Can anything be edited by selecting multiple sheets? Seems like the nothing gets by the first sheet anyhow.

Jean-Yves

Reply

Answer 3

KOENIG Yvan

Level 8

41,807 points

Dec 18, 2008 10:28 AM in response to jytessier

Here I shift-selected these three tables from the Sheet pane.
I selected Table 1 then Table 3 then Table 2

Applying what I described to these selected tables I got:

Yvan KOENIG (from FRANCE jeudi 18 décembre 2008 19:27:08)

Reply

Answer 4

jytessier Author

Level 1

0 points

Dec 18, 2008 1:59 PM in response to jytessier

Ah I see. I have my tables set up on individual sheets:

Sheet 1
~ Table 1
Sheet 2
~ Table 2
Sheet 3
~ Table 3
etc.

My tables are of different configurations and when I gang them up on a single sheet they a, overlap each other and b, need even more formating to get them to look right.

Message was edited by: jtessier

Message was edited by: jtessier

Message was edited by: jtessier

Reply

Answer 5

KOENIG Yvan

Level 8

41,807 points

Dec 19, 2008 3:23 AM in response to jytessier

We may set "Automatically move objects when tables resize" in the Preferences so that tables of a sheet behaves as we want.
When I must add rows, I check the preference.
When I must edit without inserting rows, I uncheck it and tables stay where the where installed.

Yvan KOENIG (from FRANCE vendredi 19 décembre 2008 12:23:31)

Reply