English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

i am making a spreadsheet, and I need the first couple of rows to stay put, so that I don't have to make a new one for the top of each page. I want to be able to scroll the rest of my list, but have those top 3 rows, for example, stay put. HELP!!!

2007-02-02 06:03:30 · 3 answers · asked by jarrett0512 1 in Computers & Internet Other - Computers

3 answers

Click on the cell where you want everything above and to the left of it to remain frozen. Then go to Window >> Freeze Panes.

2007-02-02 06:08:53 · answer #1 · answered by ms_lain_iwakura 3 · 1 0

Select the row right below the last one you want to stay put. So if you want rows 1-3 to stay put, select row 4 by clicking on the "4" to highlight the whole row. Then go up to your commands to "Window" and select "Freeze Panes". Your chosen rows will stay put while you move through all the rest!

2007-02-02 06:14:36 · answer #2 · answered by Meghan O 2 · 1 0

Freeze Panels
Rating: All

↓ Highlight the Row you want to stay still
↓ Go to Windows (Top menu)
↓ Click Freeze panels

Easy to do... you can also click to move the black lines

When you now scroll everything above the black line will stay still.

2007-02-02 06:08:26 · answer #3 · answered by Chεεrs [uk] 7 · 0 0

fedest.com, questions and answers