At 08:52 27/10/2014 -0400, Dan Lewis wrote:
When you enter the formula into cell E3, a black box appears around
E3 with a small black at the bottom right corner which we call a
"handle". Click on it and drag it down the column. One note: it is
going to take some time for Calc to copy the formula into the 1048573 rows.
Someone else may know of a way to copy the formula into all the rows
more quickly.
More easily, perhaps, but not more quickly:
Either:
o Click on the source cell. Press Ctrl+C or go to Edit | Copy. Click
the column header to select the entire column. Ctrl+click the column
heading to deselect it if necessary. Press Ctrl+V or go to Edit | Paste.
Or:
o Click the column header to select the entire column. Ctrl+click the
column heading to deselect it if necessary. Go to Edit | Fill > | Down.
(I wouldn't recommend filling entire columns with formulae: a million
is a lot of rows! But the above techniques are applicable to shorter extents.)
Brian Barker
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
