At first glance, this week’s creative tip may seem a little frivolous. One of our clients recently called for some coaching in how to create word-search puzzles for a monthly magazine she designs.
Yet as we dig a little below the surface this fun project demonstrates InDesign’s ability to place Excel spreadsheets as a table — which can be pretty handy for many types of information-heavy design projects.
In the workflow our client has established, an outside copywriter organizes the actual word-search puzzle. Since her copywriter does not own (or want to learn) Adobe Indesign, she builds the monthly puzzle using a Microsoft Excel spreadsheet.
Tip: For our example, we created a custom word-search puzzle using a create your own word-search website we discovered.
Placing an Excel document in InDesign is as easy as choosing File > Place. Find your Excel spreadsheet and you will be presented with InDesign’s Microsoft Excel Import Options.
We’ll focus on Table options: If you select Formatted Table, InDesign tries to preserve the same formatting used in Excel. Since we generally prefer doing the formating in InDesign, we’d choose Unformatted Table. You can also choose Unformatted Tabbed Text if you want tab-delimited text instead of an InDesign table.
InDesign places tabled inside of existing text frames, or creates a new text frame for you.
To resize a table, select the Type tool, and hover your cursor over the lower right corner until you get a diagonal double-arrow. Drag your table to the size you want your finished puzzle.
Tip: When you are done resizing the table, choose Object > Fitting > Fit Frame to Content to make your overall text frame match the table’s finished size.
To select the whole table, click inside one cell with the Type tool and choose Table > Select > Table. Then to change or removed the strokes around each cell choose Table > Cell Options > Strokes and Fills…
In our case we’ve turned off all borders for our puzzle by using a weight of 0 pt for all cell strokes.
Tip: With the whole table highlighted you can also adjust your font choices for your word search (or assign a predefined style).