Skip navigation

Consolidating charts

3418 Views 28 Replies Latest reply: Dec 12, 2012 12:59 PM by Niku RSS
  • Badunit Level 6 Level 6 (10,775 points)
    Currently Being Moderated
    Dec 10, 2012 7:40 PM (in response to Niku)

    Adding rows should never result in disappearing rows (what I assume you are calling "lines") or words or anything else. This part of using Numbers should be easy and nearly foolproof so I am at a total loss as to what you might be doing wrong.

     

    There is no better method than dragging for moving rows from one place to another.  The other method requires adding a blank row, Copy/Paste (or Mark for Move followed by Move) of everything from the old row to the new one, then deleting the old row.  Much more error prone in my opinion, plus it takes several more steps. The worst that can happen with the drag and drop method is you drop the row outside of the table and it makes a new table out of it or maybe you drop it in the wrong place on the table. Either way, you just pick it back up and try again.

  • Badunit Level 6 Level 6 (10,775 points)
    Currently Being Moderated
    Dec 11, 2012 5:02 AM (in response to Niku)

    Can you post a screenshot of what you've developed.  Your problems with Numbers make no sense to me.  No matter what you do, dragging a row from one place to another will never result in the row (or other rows) disappearing.

     

    A "page" refers to how the spreadsheet is going to appear when printed. The spreadsheet does not actually have "pages", it has tables and charts and textboxes and shapes that you arrange in such a way that, when printed, they will print on specific pages. You can't add or delete pages except by moving or deleting content (such as deleting a bunch of rows or columns from a table, reducing the size of a table or chart so it can be printed on a single page, etc.  So I am interpresting your problem of "losing pages" to mean you are somehow deleting rows or columns from your table.  But deleting rows and columns is not something that is easy to do accidentally. You might accidentally select an entire row of data and delete the contents but the row itself remains (it just becomes a row of blank cells).

     

    Screenshot: open up your document. Press Command-Shift-4. This will bring up a different looking cursor. Place it at the top left corner of what you want to take a picture of. Hold down the mouse button and drag to make a box that covers the area you want to take a picture of. Let go of the mouse button. The screenshot should be on your desktop. When replying to this message, use the camera icon to insert the screenshot.

  • Badunit Level 6 Level 6 (10,775 points)
    Currently Being Moderated
    Dec 11, 2012 10:36 AM (in response to Niku)

    Well it looks like you have a proper table. Maybe your problem is you are trying to move the contents of cells versus moving an entire row.  If you select cells, move them with the little hand-shaped cursor, and drop them on other cells, the old contents get replaced with the new.  To move a row you click and hold on the row number (circled in the screenshot below), drag sideways to "lift" the row from the table, then move it. You'll see a blue line on the table that indicates where it will be placed. When the blue line is where you want the row to go, let go. I can't take a screenshot of the process.

     

    Screen Shot 2012-12-11 at 1.26.20 PM.png

     

    You might want to read the users manual some more. The problems you are having sound like you are not using the interface correctly, not whether you are being delicate enough.

  • Badunit Level 6 Level 6 (10,775 points)
    Currently Being Moderated
    Dec 12, 2012 10:30 AM (in response to Niku)

    NOT the triangle. I said click on the ROW NUMBER.  Anywhere in the box with the row number in it except the triangle will work. Please take a moment to read before you jump in and start doing.

  • Badunit Level 6 Level 6 (10,775 points)
    Currently Being Moderated
    Dec 12, 2012 12:34 PM (in response to Niku)

    If you need blank rows for inserting "lines", you are obviously not moving rows, you are dragging data from those rows and dropping it into other rows.  And that would explain why some of your data is disappearing; you are overwriting it.

1 2 Previous Next

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.