At 06:44 28/01/2015 -0800, Mark Howe wrote:
I can't find help for merging columns or ranges. Is it possible?
Merging cells is so easy, but I hate to have to do it a million times.
I don't think so. You can merge two cells into one. Or a range of
cells into one - so a column or columns into a single cell. But I
don't see any way of merging, say, two adjacent columns into a single
column of cells - other than the piecemeal way you've described. If
you find a way, please let me know!
As a workaround (and as has already been suggested), you can
o Construct a formula to concatenate the contents of each pair of
cells into a new column.
o Cut or copy the result and use Paste Special (no Formulae) to paste
it back over one of the columns.
o Empty the other column?
But you still end up with a single column of populated cells, not a
range of merged cells (if that matters).
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
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