Choosing certain cells in column to format - shortcut?

[Louise99]

I have cells in a column from F19 to F3205 to reformat. When I use the shortcut Shift Ctrl Down-arrow I only get to the next blank cell (F401)instead of the end of my data in that column (F3205). Any ideas for a shortcut?



Thanks!

 

[SkipVought]

Hi,

If you have empty cells in the range, you cannot use the END key to navigate to the extremities.

Select the cell at one extreme, hold down your SHIFT key and drag the scrollbar until you get to the intended row and then select the cell at the other extreme.

Skip,

_[red][/red]

 

[cresbydotcom]

I usually do this in VBA - inspect each cell and if empty look at the one (say) 10 higher and, if also empty, check if the intervening are empty. If not, keep looking.

Depends on the size of the gaps of course. The macro can then have formatting code added as necessary - with choices if wanted.

I use the record function a lot to see how Micr$soft would do it - especially if VBA help is not loaded.

 

[GlennUK]

Keyboard tricks that might speed up what you want ...

Ctrl Space - select entire column for the currently active cell

Ctrl . ( Ctrl full-stop [period in USA] ) - navigate the active cell to the "next" corner of the current selection

so, if you wanted to navigate quickly to the last filled cell in a column you could do Ctrl Space, Ctrl . ( once or twice, depending on where your active cell navigates to ) to get to row 65536 of the current column, and then press Ctrl UpArrow, and there you are. I navigate around my sheets using keyboard a lot.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.