OT: Excel, otazka
Kamil Rezac
krezac@gmail.com
Pondělí Květen 15 15:49:45 CEST 2006
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
>
Další informace o konferenci Hw-list