Splitting rows and columns

[Rochelle <rh...@gmail.com>]

I have a very complex spreadsheet on which to input much data.
When working on a spreadsheet (calc) in AOO,  how does one freeze the
headers of the row or column so that one can scroll to up and down, or
right and left and keep track of the correct title of that cell so
appropriate data is entered?   This is particularly needed when the
spreadsheet involves multiple pages and columns.


Rochelle

Re: Splitting rows and columns

[Rochelle <rh...@gmail.com>]

Fabulous, thank you so much.  Someone also wrote to me off list and
explained how to use the help text, that's the "?" on the tool bar.  Very
useful info, I'll be using in future.

Rochelle


On Thu, Aug 28, 2014 at 7:13 PM, Martin Groenescheij <
Martin@groenescheij.com> wrote:

> Place your cursor in the cell below / right of the row / column you want
> to freeze
> then go to Window --> Freeze
>
>
> On 29-8-2014 14:16, Rochelle wrote:
>
>> I have a very complex spreadsheet on which to input much data.
>> When working on a spreadsheet (calc) in AOO,  how does one freeze the
>> headers of the row or column so that one can scroll to up and down, or
>> right and left and keep track of the correct title of that cell so
>> appropriate data is entered?   This is particularly needed when the
>> spreadsheet involves multiple pages and columns.
>>
>>
>> Rochelle
>>
>>
>

Re: Splitting rows and columns

[Martin Groenescheij <Ma...@Groenescheij.COM>]

Place your cursor in the cell below / right of the row / column you want 
to freeze
then go to Window --> Freeze

On 29-8-2014 14:16, Rochelle wrote:
> I have a very complex spreadsheet on which to input much data.
> When working on a spreadsheet (calc) in AOO,  how does one freeze the
> headers of the row or column so that one can scroll to up and down, or
> right and left and keep track of the correct title of that cell so
> appropriate data is entered?   This is particularly needed when the
> spreadsheet involves multiple pages and columns.
>
>
> Rochelle
>