Using Numbers, but can't figure out how to insert cells into a table without adding a whole row. Excel does that but does Numbers?
MacBook Pro, Mac OS X (10.7.3), iWork '09
No. But neither does Excel, although that's the way it's described.
When you insert a 'cell' in Excel, what you are actually doing is moving the content of that cell, and all cells below it down a row, and if necessary, adding a row at the bottom of the table. If you were actually 'inserting a cell'. it would push all those below it down a row, and the end result would be a table with a single cell sticking out at the bottom, where it had been pushed by the insertion of a cell somewhere above it.
So far, I've not seen such a table in Excel.
You can do essentially the same thing in Numbers. Hare's a small example:
Starting with the table below, we want to 'insert an empty cell' in position B2, moving the rest of the cells in column B downward. What we actually do is:
Make room for the content of the cells in column B, then move that content down a row.
Here's the table as it starts out:
To open a space in B2, we need to move the five values in column B down one row. But first we need to create a space into which to move that data. Click on any cell, then drag the Row Control handle (lower left) down until a new row appears.
Now select the cells whose content is to be moved (shown above). With the five cells selected, click and hold on B2, the drag down until the mouse pointer is in cell B3. Release the mouse button for the result shown below:
For move 'moving' cells, see the article Copying and Moving Cells in Chapter 4, Working with Table Cells, in the Numbers '09 User Guide. You may download the guide via the help menu in Numbers.
Regards,
Barry
"Why am I trying to stick with Numbers?"....Because there are no other options 😢
Thanks for trying to make it easier...
In Kindness,
Margie
There are, indeed, options...
Number
MS Excel
LibreOffice (Free Office Clone)
NeoOffice (Free Office Clone)
Add to Wayne's list; IBM Lotus Symphony. Acts like Excel but with a nicer-looking user interface, and also free.
Jerry
Wayne, you have me curious.
You mention Number as being an alternative to Numbers?
MS Excel-for Macbook Pro? The reviews for MS Office Mac are not exactly stellar.
Not familiar with Libre or Neo Office...are these spreadsheet apps?
Thanks for letting me 'pick your brain' : )
In Kindness,
Prof. Margie
Wow, I didn't think Lotus was still available! I used AmiPro for Years and Loved it!
So, the Lotus Symphony works on a Macbook Pro Lion?
Would you be so kind as to share where I can get the free copy? Is it in the App store?
In Kindness,
Prof. Margie
Margie,
Don't get too excited, it's not the old Symphony that was my favorite desktop app of the era. 🙂
I downloaded the original version of IBM's new Symphony a while back just out of curiousity. They are on Version 3.0.1 now. The download page is here. It's a lot like Office, and for all I know it might be a licensed version of one of the "open Office" apps.
The opening page:
Spreadsheet app:
Regards,
Jerry
I listed all the options for spreadsheet programs. I listed, and Jerry added, programs as they came to mind. The point is that the the options for spreasheet programs for the Mac OS X platform are at least several. I cannot comment on reviews of MS Excel. I use excel at work but try to use Numbers where/when I can.
Google can assist in locating any of the installers. All of these are spreasdsheet programs of office clones (word processing, spreadsheet, presentation, etc).
Since switching to Numbers I have come to appreciate the simplicity. Many things I used to think were features in MS Excel are now less useful-- mostly becuase I can use separate tables to contain related data.
Since you have Numbers consider presenting a real example of what you are trying to do (the data you presented earlier is clearly contrived). There are people here that are very willing to help and enjoy looking for the best solution.
Regards,
Wayne
Yes, you all are Extremely kind in sharing your time and knowledge, and it is Truly appreciated.
I am not as savvy as you all are in showing a real example with step by step screen shots, so my apologies if my question seems 'contrived'..it is not.
I use a spreadsheet to copy and paste student comments and my comments back to the student , each week.
Each week's text is put into one row.
Rather than putting the information at the end of the row, I put similiar information next to each other..Ex: student comment in one cell, next cell my comment....which causes the need to insert a blank cell and paste. Make sense?
That said, I will take your terrific advice, and do Google searchs before I request assistance.
Again, thanks for your time and information.
In Kindness,
Prof. Margie
Bless you! I am off to Lotus Land! 🙂
Update:
I just finished downloading Lotus. Perfect! The spreadsheet is laid out Exactly the way I need it..with multiple sheets down at the bottom, rather than listed separately on the side...and does Exactly what I need it to do, insert cells with a simple one step right click of the mouse.
Thank You! Thank You! I may be able to wean myself off Dell afterall 😝
In Kindness,
Prof. Margie
Using Numbers, but can't figure out how to insert cells into a table without adding a whole row. Excel does that but does Numbers?
