Repeat text in grid

I need to type text then repeat it 10 or more times on a sheet of paper. This is to send a note or address out multiple times. I think of this as a grid that I can put on paper in rows and columns, say 2 or 3 columns and 5 or 6 rows so I have 10, 12 15 or 18 of the same text that I can then cut the paper into that many notes or addresses.


I'm using Pages for this. I thought using the business card template would do it but I haven't figured out how to replace the template text with mine and then how to make it repeat this in every box or on every card block.


Can someone lead me though this?

Posted on Dec 10, 2019 1:22 PM

Reply
Question marked as Top-ranking reply

Posted on Dec 12, 2019 12:26 AM

Hi Ed,


Unless Apple has revised the business card template recently, the document created from that template does not include a Table. It is composed of a set of graphic objects and text boxes repeated 10 times on the first page (and a similar set repeated 8 times on the second page. Here's an example, using the "modern business card" template from Pages 5.

As can be seen in the upper left set, where all elements are selected, each 'card' has a graphic object (which is actually a Grouped object, made from three small squares, each filled with a different colour), and two text boxes, each containing placeholder text.


Click once to select one of the text boxes, then click once in the 'name' text to select that placeholder text, then type the name.

Click once in the job title placeholder, then type in the job title.


Repeat with the second text box and the phone, email, street address, and web address information.


Copy the contents of the first text box, then paste it into each of the others in turn.

Repeat with the contents of the second text box.


Not a lot of automation (even less than with the table approach I suggested), but it does give you some basic design, and a layout that fits available Business Card stock from Avery or other suppliers.


As for the table approach, the complicated part is setting up the table to begin with. Most of the complication in my description above was in avoiding sowing a page filled with error triangles. Here's a rewrite that avoids that struggle:


The image shows three copies of the same table at different stages of the process. It does not include the initial step of setting the row heights and column widths as described above.



Image 1 (top):

With the column and row sizes set:

  • Click once on cell A1, then type = to open the formula editor.
  • Enter the formula shown ( $A$1 ) and click the green check to confirm the formula and close the editor.

Ignore the error triangle in the cell.

  • Using the Fill handles, fill the formula right to C1, then down to the last row of the table

All cells will contain error triangles.

A1 is due to the formula in that cell referencing its own cell.

The rest are due to their referencing a cell (A1) which contains an error.

  • Click once on cell A1 and press delete to delete the formula in that cell.
  • Display in the rest of the cells will immediately change to "0" as seen in image 2 (middle)
  • Enter the desired text in cell A1.
  • The text will be automatically reproduced in each of the other cells.


Once set up, you can change the text in all cells by entering the new text in cell A1.


Limitations:

Text in a single cell in Numbers must all have the same format properties. Changing type size (as done in the upper text box of the Business card template) or other attributes of the text is not possible within the same cell.

Images and other graphic objects may be placed in table cells only as Image Fill, which automatically resizes to fill the cell.

(Images can be placed behind the table, though.)


Regards,

Barry



4 replies
Question marked as Top-ranking reply

Dec 12, 2019 12:26 AM in response to neoflyer

Hi Ed,


Unless Apple has revised the business card template recently, the document created from that template does not include a Table. It is composed of a set of graphic objects and text boxes repeated 10 times on the first page (and a similar set repeated 8 times on the second page. Here's an example, using the "modern business card" template from Pages 5.

As can be seen in the upper left set, where all elements are selected, each 'card' has a graphic object (which is actually a Grouped object, made from three small squares, each filled with a different colour), and two text boxes, each containing placeholder text.


Click once to select one of the text boxes, then click once in the 'name' text to select that placeholder text, then type the name.

Click once in the job title placeholder, then type in the job title.


Repeat with the second text box and the phone, email, street address, and web address information.


Copy the contents of the first text box, then paste it into each of the others in turn.

Repeat with the contents of the second text box.


Not a lot of automation (even less than with the table approach I suggested), but it does give you some basic design, and a layout that fits available Business Card stock from Avery or other suppliers.


As for the table approach, the complicated part is setting up the table to begin with. Most of the complication in my description above was in avoiding sowing a page filled with error triangles. Here's a rewrite that avoids that struggle:


The image shows three copies of the same table at different stages of the process. It does not include the initial step of setting the row heights and column widths as described above.



Image 1 (top):

With the column and row sizes set:

  • Click once on cell A1, then type = to open the formula editor.
  • Enter the formula shown ( $A$1 ) and click the green check to confirm the formula and close the editor.

Ignore the error triangle in the cell.

  • Using the Fill handles, fill the formula right to C1, then down to the last row of the table

All cells will contain error triangles.

A1 is due to the formula in that cell referencing its own cell.

The rest are due to their referencing a cell (A1) which contains an error.

  • Click once on cell A1 and press delete to delete the formula in that cell.
  • Display in the rest of the cells will immediately change to "0" as seen in image 2 (middle)
  • Enter the desired text in cell A1.
  • The text will be automatically reproduced in each of the other cells.


Once set up, you can change the text in all cells by entering the new text in cell A1.


Limitations:

Text in a single cell in Numbers must all have the same format properties. Changing type size (as done in the upper text box of the Business card template) or other attributes of the text is not possible within the same cell.

Images and other graphic objects may be placed in table cells only as Image Fill, which automatically resizes to fill the cell.

(Images can be placed behind the table, though.)


Regards,

Barry



Dec 10, 2019 5:32 PM in response to neoflyer

I'd use a Table in Numbers for this task, although a Table in Pages would also work.


Set the table for the number of rows and columns needed, then use the Inspector to set the row height and column width to the space you need for each block of text.


Enter the text in the top left cell of the table, using option-return to move to a new line within the same cell.


Click on cell B1 to select it, then press = to open the formula editor.

In the editor, type $A$1

Then click the green checkmark to confirm the formula and close the editor.


With Cell B1 still selected, hover the mouse pointer near that cell's bottom boundary. When a yellow dot (the Fill handle) appears, click and hold, then drag down to fill the formula into the rest of column B.


With all cells in column B selected, hover the mouse pointer near the centre of the right boundary of the election, grab the Fill handle, and drag right to fill the formula to the rest of the columns to the right of B.


Finally,

Click an empty space outside the table to deselect all cells,then:


Click cell B2 to select it, and shift-click the bottom cell in column B to add all cells from it to B2 to the selection.

Locate the Fill handle on the left boundary of the selection, and drag it left to fill the formula into all cells (except A1) in column A.


All cells in the table should now display the text entered in cell A1.


Save the result as a Template (or as a Document) for re-use.


To change the contents of the whole table, (Open the document or open a new document using the template, ) click on cell A1 and enter the new text.


Regards,

Barry




Regards,

Barry




This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Repeat text in grid

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.