1. Format, Print Ranges, Edit, "Rows to repeat". 2. You need button that has "ab" on it with a marker and yellow coloring. It might be not visible, so you need to show it via View, Toolbars, Customize, Formatting and putting checkmark next to "Highlighting" (it should be close to the end of the list).
P.S. See if you can help OO by registering at http://www.openoffice.org/servlets/Join and vote for the following issues: http://www.openoffice.org/issues/show_bug.cgi?id=24969 http://www.openoffice.org/issues/show_bug.cgi?id=1035 http://www.openoffice.org/issues/show_bug.cgi?id=51564 http://www.openoffice.org/issues/show_bug.cgi?id=29807 http://www.openoffice.org/issues/show_bug.cgi?id=7357 http://www.openoffice.org/issues/show_bug.cgi?id=70753 http://www.openoffice.org/issues/show_bug.cgi?id=15220 http://www.openoffice.org/issues/show_bug.cgi?id=10931 http://www.openoffice.org/issues/show_bug.cgi?id=35579 http://www.openoffice.org/issues/show_bug.cgi?id=32785 http://www.openoffice.org/issues/show_bug.cgi?id=67838 http://www.openoffice.org/issues/show_bug.cgi?id=39527 http://www.openoffice.org/issues/show_bug.cgi?id=64785 Thanks a lot. WBR, K. Palagin. > -----Original Message----- > From: david potter [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 02, 2007 2:21 PM > To: [email protected] > Subject: [users] How to fix column headings in calc. > > 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 > > > 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]
