move to adjacent cell with panes frozen

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Date Setting 1
Unable to freeze panes 16
Drop down list & frozen panes 3
cells are frozen 1
Comments partially hidden due to "frozen" columns 2
Sorting issue with frozen panes 11
Pane row and column freeze 1
Excel 2007 - freeze multiple panes? 2

Back
Top