![]() |
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? |
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