ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   How to keep first row in spreadsheet (https://www.excelbanter.com/setting-up-configuration-excel/5062-how-keep-first-row-spreadsheet.html)

Misstory888

How to keep first row in spreadsheet
 
How can I keep my first row on my spreadsheet? For instance, row 1 will
always stay on even when I'm scrolling down it.

RWN

Select A2 and "Window-Freeze Panes"

--
Regards;
Rob
------------------------------------------------------------------------
"Misstory888" wrote in message
...
How can I keep my first row on my spreadsheet? For instance, row 1 will
always stay on even when I'm scrolling down it.




Gord Dibben

Select A2 and click on WindowFreeze Panes" to freeze Row 1

To freeze column A also select B2.


Gord Dibben Excel MVP

On Fri, 7 Jan 2005 10:25:03 -0800, "Misstory888"
wrote:

How can I keep my first row on my spreadsheet? For instance, row 1 will
always stay on even when I'm scrolling down it.



Jack in the UK


Misstory888 wrote:
*How can I keep my first row on my spreadsheet? For instance, row 1
will
always stay on even when I'm scrolling down it. *


If you prefer you can always split the screen

Jack



--
Jack in the UK
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message1335086.html





All times are GMT +1. The time now is 01:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com