Skip navigation

Adding a title/subtitle

357 Views 9 Replies Latest reply: Oct 30, 2012 4:59 AM by NJM55 RSS
NJM55 Calculating status...
Currently Being Moderated
Oct 26, 2012 3:16 PM

I'm creating a large, text-based spreadhseet. it's actually three long lists being pooled into one enormous table, and I want to have a break between each of the sections with a header/title. The first, and longest, section has already been created; it's 10 columns and nearly 3,000 rows. How can I add a row with no columns for a subhead?

Intel-based Mac, Mac OS X (10.6.7)
  • Jerrold Green1 Level 7 Level 7 (28,120 points)
    Currently Being Moderated
    Oct 26, 2012 5:41 PM (in response to NJM55)

    Why not make it three separate tables, each with a Header?

     

    Jerry

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Oct 26, 2012 11:52 PM (in response to NJM55)

    I'm with Jerry on this.

     

    At 3000 rows, you may already noticed a slowing in data entry.

     

    With three separate tables, one for each of your major categories, switching from one category to another is a simple click on the icon for that table in the Sheets list. That click, although it is a separate step, will be far more efficient in changing categories than scrolling down past the 3000 rows of your first category.

     

    You may find that placing each of the three tables on its own sheet has some advantages. If not, it's easy to move the new tables onto the same sheet as the first (then delete the two, now empty, sheets).

     

    Adding a sheet is easy: Click the Sheet's button in the button bar above the working area and choose new sheet.

    The new sheet comes with a new, empty table by default. If you want the same column headers in this table, Select the first row of the original table, Copy. Select the first row of the new table. Paste.

     

    Regards,

    Barry

  • Jerrold Green1 Level 7 Level 7 (28,120 points)
    Currently Being Moderated
    Oct 27, 2012 8:37 AM (in response to NJM55)

    NJM55 wrote:

     

    This is the first time I've ever done a spreadsheet, so I'm not familiar with the tricks of the trade. Do you mean create separate documents/files, or three tables within one document? The document I'm creating is a list of boks I'm interested in reading (although I calculated the other day that it would take me about 300 years to read everthing on it, not to mention the fact that I add new titles several times a week). Although the document has a column for the genre of the book, my plan was to create separate sections within the spreadsheet for broad, general categories like fiction and nonfiction. That's probably not really necessary in spreadhseet format, since I could sort the entries whatever way I like, but as with the paper lists I've had for years, the idea is to be able to see the major sections as a whole, at a glance, not to have to take another step or two to see all the authors/titles in that category.

     

    I could proablly just create a header in the first column, which is where I have entered each letter of the alphabet as a subhead/reference point, and increase the font size. But what I was envisioning was a more prominent label or headline, perhaps centered, and I don't know how to create a row that doesn't adhere to the column/row format I have used up to that point and will use after it.

    I meant three tables, however you wish to package them. Separate documents would run faster, but would be less convenient. Experiment and find which method you like the best.

     

    Jerry

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Oct 28, 2012 11:32 PM (in response to NJM55)

    Try this:

     

    In the original table, represented on the left, select the top two rows. Copy.

     

    Click on an empty part of the sheet to deselect the original table rows. Paste.

    The result should be similar to the table "Copy" in the image. delete any data from row 2 of the Copy.

     

    Click on any cell in the Copy table to show the row and column reference tabs and the controls at the top right, bottom right and bottom left corners of the table.

     

    Use the mouse to drag the Row control (bottom left) down to add rows to the table, for the result shown in Copy (extended).

    Picture 10.png

    To add data to the table by pasting, without disturbing the colour fill, use Paste and Match Style (from the Edit menu).

     

    Regards,

    Barry

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Oct 29, 2012 10:36 PM (in response to NJM55)

    If you have all of the non-header cells in a column set to the same font size, then added rows should also adopt that font size. If you have even one cell in the column with a different font size, size in the added rows will revert to the default size.

     

    Regards,

    Barry

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.