Hi!
For the 1.question. Just like in Excel select row below headings and
under Window chose Freeze.
For the 2.question. First of all text formatting capabilities in
openoffice.org calc are much better than in excel, even in new versions.
I don't think it is possible to easily change background for certain
words in 1 cell, you can change background for the whole cell by
choosing icon Background color (move cursor over icons and if you have
default settings you will see title of the icon. It is possible to
change color of certain words or letters inside the cell by selecting
those words or letters and pressing icon Font color (next to right side
after Background color icon). There are also help texts available
describing functions of these icons.
Andis
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
D & SA Potter.
221 Borden Lane,
Sittingbourne,
Kent. ME9 8HR.
Tel: +44 (0)1795 473302
Email: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
