Forum Home
Press F1
 
Thread ID: 91990 2008-07-25 01:40:00 Naming columns in openoffice calc (or excel) how do i do this? Morgenmuffel (187) Press F1
Post ID Timestamp Content User
691879 2008-07-25 01:40:00 Basically I want to have a name at the top of each column that doesn't disappear as i scroll down the page

It must be doable, surely I'm not the only one that has to scroll up to figure out which column is which
Morgenmuffel (187)
691880 2008-07-25 01:49:00 Click the first cell in the corner of the range (see ss) and click Window>Freeze Panes.

Click here... www.imagef1.net.nz
Result... www.imagef1.net.nz

(in Excel 2007, but similar result across all versions of Excel)

OOo probably has a similar function.
jwil1 (65)
691881 2008-07-25 02:22:00 ...and in OOo Calc it's Window>Freeze. jwil1 (65)
691882 2008-07-25 06:19:00 Thanks that's exactly what I was after,

my mouse scrolling finger thanks you
Morgenmuffel (187)
1