OT: Excel, otazka

[Kamil Rezac]

Treba se to nekomu hodi:

Window > Freeze panes

It's not just column titles that you can freeze in place. You can also
freeze row titles, or you can freeze both at the same time to keep
both column and row titles.

But there's a secret to success: To freeze titles, do not select the
titles themselves. To freeze:

    * Column titles    Select the first row below the titles.
    * Row titles    Select the first column to the right (for example,
to keep supplier names in sight as you scroll across the worksheet).
    * Both column and row titles    Click the cell that is both just
below the column titles and just to the right of the row titles.

If you don't get it right the first time, it's easy to unfreeze and
try again. Just click Unfreeze Panes on the Window menu.

Tip    You can freeze panes anywhere, not just below the first row or
to the right of the first column. For example, if you wanted the
information in the first three rows to stay in sight as you scroll,
you would select the fourth row and freeze.

KR

On 5/15/06, Daniel Valuch <daniel.valuch@wanadoo.fr> wrote:
> zdravim,
> mam taku blbu otazku :-) V exceli mam velmi dlhu tabulku, ktora ma
> hlavicku pre kazdy stlpec. Ked editujem spodne riadky tak sa musim
> posunut dole a nevidim uz hlavicky. Myslim ze sa tam nejak daju
> zadefinovat policka, ktore chcem stale vidiet na vrchu obrazovky aj ked
> budem scrollovat cez celu tabulku. Neviete ako sa to robi? Ja som to uz
> zabudol :-/
> Dik,
> balu
>
> _______________________________________________
> HW-list mailing list  -  sponsored by www.HW.cz
> Hw-list@list.hw.cz
> http://list.hw.cz/mailman/listinfo/hw-list
>