Next Line Title

Option Return is probably what you are wanting. It creates a line feed character (ASCII decimal code 10). Option Shift Return creates a line separator code (Unicode decimal 8232). Control Option Shift Return creates a carriage return (ASCII code decimal 13).

The Return and Enter Keys have a specific use in spreadsheet apps, including in Numbers. Those keys are for completing data entry in a cell.

If you need a multi-line title for a table, you can put a text box above the table with whatever text in whatever fonts and formats and as many lines as you would like. Just turn off the actual table title so it does not display.

HI Chriz,

Same issue here as in your previous post.

Can you clarify what it is that you are referring to as a "Title"?

In this case, it sounds like you mean either the Table Name or the Header label in a single column.

The Table Name is placed in a box that is not user Adjustable. It is one line high, and set to center the name automatically.

Header labels are placed in Header cells. The default setting in Header cells is to Wrap text as i becomes too long to fit the width of the column. In these cells (and in body cells) you can insert option-return to force a line break, as seen in column C, where "A Blank" would fit on a single line.

IF the table is made narrower (by removing the empty and unlabelled columns, the box for the table name becomes shorter—too short to hold the long name given to this table. Note that this does NOT cause the table name to wrap. The 'extra characters simply disappear. option return in this box has no special effect.

The full name of the table is still there, and widening the columns (or adding a column) will bring Frederik back into view.

And that full name will be required in formulas on a different table referencing cells on this table.

But to display the full name abouve the narrow table above requires the use of a container for that text that is not part of the Table.

Copy the Table name to the clipboard, then uncheck the Table Name box in the Table format pane inthe right sidebar.

Click the Text button in the button bar above the document window, then drag the box to the top of the table and resize it to match the table width.

Click inside the box and press command-V to Paste the table name into the Text box.

Regards,

Barry

An Excel document or workbook is equivalent to a Numbers document or spreadsheet.

A worksheet in an Excel workbook is similar to a Numbers sheet. However, an Excel worksheet has a grid of cells, whereas a Numbers sheet has a blank canvas on which you place tables (which have a grid of cells), charts, shapes and other objects.

When you open your Excel workbook in Numbers the Excel worksheets are placed in Numbers tables. It's not a question of tables having "advantages" in Numbers. Tables are mandatory if you want to have grids of cells. You are using tables in Numbers whether you think you are or not!😀

SG

I thought you were talking about text in general. Are you talking about table titles? If table titles, you are correct that you cannot use a line feed (or similar) character. Table titles are used in formulas for cell references. A line feed in one would be problematic.

When you hit command-n you should either the template chooser or a document based on your preferred template (depending on how you have set up Numbers at Numbers > Preferences).

It looks as if you are presented with a sheet (not a page; Numbers doesn't have "pages") and on that sheet there is already a table with cells ready for input.

That makes sense because tables are so integral to the Numbers design. You can do very little in Numbers without at least one table. Note that you can easily have more than one table on the same Numbers sheet, something quite difficult to do in Excel. (Excel has tables too, which can be very useful, though they are harder to use than Numbers tables, and are optional.)

SG

Hi Chris,

Not much to add to what SG has already said.

Command-N opens a 'new document' using a template specified in Numbers preferences.

The default setting is for a 'Blank' template which produces a document with a single sheet, named "Sheet 1", containing an empty table named "Table 1".

In an open document, shift-command-N adds a new Sheet to the document.

The new sheet will be named Sheet n (where n is the first available number for a Sheet in this document)

The new Sheet will contain one Table (named Table 1).

You can add a new table to an existing sheet using the Insert menu, choosing Table, then choosing from several styles.

The new table will be named Table n (where n is the first available number for a new table on this Sheet)

If you add the option key to thecommand-N keystroke combination* and press option-command-N, Numbers opens the Template Chooser, which displays thumbnails of a collection of prepared templates for a variety of Numbers documents.

Several of these templates (Basic Charting comes to mind) serve as excellent "How to" examples for creating graphs, tracking expenses, etc.

Regards,

Barry

*The option key itself is worth an exploration trip through the menus at the top of the Numbers menu. Only two of the menus (on my older version) have items that toggle between two items, but others list items that include the option symbol at the beginning of the keystroke set.

Open the File menu, for example, then note the changes in that menu as you press and release the option key.

B.