ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   freeze horizontal and vertical panes at the same time in Excel (https://www.excelbanter.com/excel-worksheet-functions/49473-freeze-horizontal-vertical-panes-same-time-excel.html)

Bridgette

freeze horizontal and vertical panes at the same time in Excel
 


David McRitchie

Hi Bridgette,

see http://www.mvps.org/dmcritchie/excel/freeze.htm

To free both row 1 and column A, you select a cell that is
one past each so select cell B2 and then Window (menu), Freeze Panes.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bridgette" wrote in message ...





All times are GMT +1. The time now is 06:16 AM.

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