Re: Formulas fin Numbers for Mac - follow up question

2018-07-13 Thread 'Andrew Lamanche' via MacVisionaries
The key combination to add rows or columns is not control plus arrow keys but option. Is this what’s causing you trouble? > On Jul 13, 2018, at 9:23 AM, 'Adrienne Chalmers' via MacVisionaries > wrote: > > Guys > > That all worked a little too well:) > > I used the control up arrow to insert

Formulas fin Numbers for Mac - follow up question

2018-07-13 Thread 'Adrienne Chalmers' via MacVisionaries
Guys That all worked a little too well:) I used the control up arrow to insert a row and that all seemed fine, but then when I started to move to another bit of the spreadsheet to insert another row, new rows and columns seemd to be springing up all over the place. Seemed to be any time I

Re: Formulas in Numbers for Mac - follow up question

2018-07-11 Thread 'Andrew Lamanche' via MacVisionaries
You can use option key + up or down arrow to insert a row above or below. If you make a mistake by inserting a row at the wrong place, you can use the usual command+z key combination to reverse the insertion unless you’ve saved the spreadsheet. This is a quick way of correcting an error. As

Re: Formulas in Numbers for Mac - follow up question

2018-07-10 Thread Jonathan Cohn
I find that if you are in the mode where arrow keys moves through the set of cells, then the option key with the arrow key will add a column/cell either before or after the currently selected cell. I often was adding columns to my spreadsheets when I first started using Numbers when I thought

Re: Formulas in Numbers for Mac - follow up question

2018-07-10 Thread Jeff Berwick
Use the context menu to insert or delete rows and columns: [control] + [option] + [shift] + M Hth, Jeff > On Jul 10, 2018, at 5:42 AM, 'Adrienne Chalmers' via MacVisionaries > wrote: > > Thanks. I knew it would be something that should have been blindingly > obvious, if you will pardon the

Formulas in Numbers for Mac - follow up question

2018-07-10 Thread 'Adrienne Chalmers' via MacVisionaries
Thanks. I knew it would be something that should have been blindingly obvious, if you will pardon the expression. Anyway, I now have a new problem. I have constructed a spreadsheet, but I have missed something out in the middle of the blasted thing. I feel sure there must be a way to insert a