ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel help (https://www.excelbanter.com/excel-worksheet-functions/201942-excel-help.html)

jbneedanswer

Excel help
 
Is it possible to simultaneously freeze two or more separate columns, rows,
etc.?

smartin

Excel help
 
jbneedanswer wrote:
Is it possible to simultaneously freeze two or more separate columns, rows,
etc.?


Place the cursor in the cell below and to the right of the rows/columns
you want to freeze and select Window | Freeze Panes.

Sheeloo

Excel help
 
You can not freeze separate columns (or rows).

Only adjacent columns (and/or rows) can be frozen.

"jbneedanswer" wrote:

Is it possible to simultaneously freeze two or more separate columns, rows,
etc.?


Sheeloo

Excel help
 
You can split Windows and open the same file in both windows to simulate the
effect you want

"jbneedanswer" wrote:

Is it possible to simultaneously freeze two or more separate columns, rows,
etc.?



All times are GMT +1. The time now is 10:18 AM.

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