At 21:53 27/06/2011 -0700, John Jason Jordan wrote:
Is there any way to punch just the formatting through from Sheet 1
to Sheets 2-12?
Yes:
o Copy Sheet 1.
o In the new sheet, click the upper left cell (where the row and
column headers meet) to select all of the sheet.
o Press Backspace to
On Mon, 27 Jun 2011 18:53:37 -0400
Richard Detwiler dijo:
>On 6/27/2011 5:57 PM, John Jason Jordan wrote:
>>
>
>> I finished 1996 and there are 35
>> rows. I tried to use Sheet 2 for 1997, but couldn't figure out how to
>> transfer the row and column formatting from Sheet 1 (1996), so I gave
On 6/27/2011 5:57 PM, John Jason Jordan wrote:
I finished 1996 and there are 35
rows. I tried to use Sheet 2 for 1997, but couldn't figure out how to
transfer the row and column formatting from Sheet 1 (1996), so I gave
up and decided just to use Writer tables. It took me a lot of work to
On Mon, 27 Jun 2011 14:57:19 -0700
John Jason Jordan dijo:
>How can get the data into Writer as text or as a Writer table?
Never mind. Paste Special > Unformatted text. Oddly, the first time I
tried this it didn't work. Now it does. Oh well. Just pay no attention
to anything said here by the blo
Dennis Marks yahoo.com> writes:
>
> I have 81 noncontiguous cells. ... Is there any way to paste initial
values into those cells by just using copy (from another sheet) and paste?
>
Yes, but you'd have to copy and paste all intervening cells as well. Dare I
say "Macro, anyone?"
Martin S gmail.com> writes:
>
> When copying (selecting text) and pasting (Unix third button pasting) the
> selection directly into a cell in Calc I lose my text formating for that
> cell. When pasting the text in the "edit box" (where you enter formula etc)
> the text formating of the cell is re