On Tuesday, January 02, 2007 11:20 AM [GMT+1=CET], david potter
<[EMAIL PROTECTED]> wrote:
Hi,
I used Microsoft Excel until I retired 11 years ago. I now have a
need to use spreadsheets again and have downloaded the free version
of Open Office. Generally I am finding it great but obviously there
are differences. Some I am managing to work out but others prove
refractory.
1.. On thing I would like to be able to do is to fix the column
headings in a spreadsheet i.e. so that they stay at the top of the
screen when I scroll down. Is it possible to do this please? It is
something I used to be able to do in Excel.
2.. The second thing is an observation. I wanted to highlight
text. I went to the Help facility and found a familiar icon
(superscript ab with below a diagonal pen leading to a coloured line
at the bottom). I could not find this icon on any of the toolbars in
Calc. that I looked at (those that by name seemed relevant). By
examining the icons on the Formatting Toolbar I soon found one with
what looked like paint being poured from a pot. It highlighted any
cell or selection of cells that I wanted but would not highlight a
selection of words from a sentence in a cell. This is fine as you
can do the latter by changing the text colour and I really wanted to
colour the background to words as you would in a text document. I
wonder if this information about the icon and how to use it in a
spreadsheet could be included in the Help function? Or, maybe it is
there but I was unable to find it. I notice that the familiar Icon
that I found in help was in the Writer section. I had tried looking
in several other highlight help areas but without success.
Regards,
Dave Potter
1. Menu item Window>Freeze. Click in A2 and then Window>Freeze to freeze
row 1; click in B1 and then Window>Freeze to freeze column 1; click in
B2 and then Window>Freeze to freeze row 1 *and* column 1.
2. As far as I know Calc only has Cell and Page styles; seems you can't
go to a lower level of detail than the cell.
Harold Fuchs
London, England
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]