ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   column and row headings (https://www.excelbanter.com/excel-worksheet-functions/53850-column-row-headings.html)

Angelawith3

column and row headings
 
Using Office 2000 (Excel), how can I keep my column and row headings
stationary and still be able to scroll through the rest of my worksheet? I
would like to create a home budget in which I can track my daily spending.


Roger Govier

column and row headings
 
Hi

Place your cursor in cell B2.
WindowsFreeze Panes

Regards

Roger Govier


Angelawith3 wrote:
Using Office 2000 (Excel), how can I keep my column and row headings
stationary and still be able to scroll through the rest of my worksheet? I
would like to create a home budget in which I can track my daily spending.


Mladen_Dj

column and row headings
 
Go to Window-Freeze Panes. Excel will freeze left-columns and up-rows from
active cell. for example if your row headings are in column A, and column
headings in row 1, select cell B2,and row 1 and column A will be
unscrollable.

"Angelawith3" wrote in message
...
Using Office 2000 (Excel), how can I keep my column and row headings
stationary and still be able to scroll through the rest of my worksheet?
I
would like to create a home budget in which I can track my daily spending.





All times are GMT +1. The time now is 03:08 PM.

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