ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   move to adjacent cell with panes frozen (https://www.excelbanter.com/excel-discussion-misc-queries/112962-move-adjacent-cell-panes-frozen.html)

Aaron

move to adjacent cell with panes frozen
 
If you've got panes frozen, is it possible to move from a cell in the frozen
area to the adjacent visible cell - so if you've frozen to column C for
example and the cell next to column C that is visible is in column M, can
you move directly to that cell using the keyboard without having to arrow
across all the columns in between?

Carim

move to adjacent cell with panes frozen
 
Hi,


With Windows split, F6 does the job ...
With Freeze panes, I do not know ... probably to be coded in VBA and
then assigned to a function key ...

HTH
Cheers
Carim



All times are GMT +1. The time now is 05:25 PM.

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