move to adjacent cell with panes frozen

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

Carim

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
cells are frozen 1
Comments partially hidden due to "frozen" columns 2
Drop down list & frozen panes 3
Formula - Is it possible to... 3
cell size and font size 1
Excel 2003: Freeze Pane with List boxes 2
Need macro to move to first blank cell in column 6

Top