ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   set up (https://www.excelbanter.com/setting-up-configuration-excel/168643-set-up.html)

robush3

set up
 
how would I set up a spreadsheet that uses names such debt, credit balance,
that will always be displayed at the top of the spreadsheet no matter what
row os shown?


Gord Dibben

set up
 
Enter those titles across row 1

Select A2 and WindowFreeze Panes.

The freezing rules are..............

Everything left of and above the selected cell will remain in view when freezing
panes.

B2 to freeze row 1 and column A

C3 to freeze columns A & B and rows 1 & 2


Gord Dibben MS Excel MVP

On Wed, 5 Dec 2007 15:39:01 -0800, robush3
wrote:

how would I set up a spreadsheet that uses names such debt, credit balance,
that will always be displayed at the top of the spreadsheet no matter what
row os shown?




All times are GMT +1. The time now is 08:09 AM.

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