Carol - this isn't working just now. Firstly, if that is the only way, then it appears that only one line can be added at a time, instead of being able to select a line and move it down to wherever. Secondly, I have a spreadsheet where I have already inserted a line, and now when I try to do this in a different row, it keeps inserting the new blank line in the original place, and not where I want it. So, I've no spare or empty lines above the formula, that's why I need to know how to move it down or to insert more lines -
Andy On 10 Aug 2013, at 17:40, Carol Pearson <carol.pearso...@googlemail.com> wrote: > At lines above your calculation. > > Carol P > Sent from my iPhone using BrailleTouch > > On 10 Aug 2013, at 05:34 PM, Andy Collins <a...@recreation.plus.com> wrote: > >> Hi all - >> >> How do I do this? It seems that by default, new spreadsheets only go down by >> 30 rows, and I can't find in the menus anyway to extend the sheet. I know >> from within the context menu it is possible to add a row above or below, but >> I want to select the cell that has the result of a formula, and move it >> lower down the sheet, as I need extra rows going in for additional >> calculations. >> >> Thanks - >> >> Andy >> <--- Mac Access At Mac Access Dot Net ---> >> >> To reply to this post, please address your message to >> mac-access@mac-access.net >> >> You can find an archive of all messages posted to the Mac-Access forum at >> either the list's own dedicated web archive: >> <http://mail.tft-bbs.co.uk/pipermail/mac-access/index.html> >> or at the public Mail Archive: >> <http://www.mail-archive.com/mac-access@mac-access.net/>. >> Subscribe to the list's RSS feed from: >> <http://www.mail-archive.com/mac-access@mac-access.net/maillist.xml> >> >> As the Mac Access Dot Net administrators, we do our very best to ensure that >> the Mac-Access E-Mal list remains malware, spyware, Trojan, virus and >> worm-free. However, this should in no way replace your own security >> strategy. We assume neither liability nor responsibility should something >> unpredictable happen. >> >> Please remember to update your membership preferences periodically by >> visiting the list website at: >> <http://mail.tft-bbs.co.uk/mailman/listinfo/mac-access/options/> >> > <--- Mac Access At Mac Access Dot Net ---> > > To reply to this post, please address your message to > mac-access@mac-access.net > > You can find an archive of all messages posted to the Mac-Access forum at > either the list's own dedicated web archive: > <http://mail.tft-bbs.co.uk/pipermail/mac-access/index.html> > or at the public Mail Archive: > <http://www.mail-archive.com/mac-access@mac-access.net/>. > Subscribe to the list's RSS feed from: > <http://www.mail-archive.com/mac-access@mac-access.net/maillist.xml> > > As the Mac Access Dot Net administrators, we do our very best to ensure that > the Mac-Access E-Mal list remains malware, spyware, Trojan, virus and > worm-free. However, this should in no way replace your own security > strategy. We assume neither liability nor responsibility should something > unpredictable happen. > > Please remember to update your membership preferences periodically by > visiting the list website at: > <http://mail.tft-bbs.co.uk/mailman/listinfo/mac-access/options/> > <--- Mac Access At Mac Access Dot Net ---> To reply to this post, please address your message to mac-access@mac-access.net You can find an archive of all messages posted to the Mac-Access forum at either the list's own dedicated web archive: <http://mail.tft-bbs.co.uk/pipermail/mac-access/index.html> or at the public Mail Archive: <http://www.mail-archive.com/mac-access@mac-access.net/>. Subscribe to the list's RSS feed from: <http://www.mail-archive.com/mac-access@mac-access.net/maillist.xml> As the Mac Access Dot Net administrators, we do our very best to ensure that the Mac-Access E-Mal list remains malware, spyware, Trojan, virus and worm-free. However, this should in no way replace your own security strategy. We assume neither liability nor responsibility should something unpredictable happen. Please remember to update your membership preferences periodically by visiting the list website at: <http://mail.tft-bbs.co.uk/mailman/listinfo/mac-access/options/>