When you have large worksheets in your Excel workbooks it can be cumbersome and time-consuming to move around in them.
This is a slick little trick that has existed in Excel for a very long time, but most folks do not know about it.
Follow the steps below to learn how:
- To quickly jump to the end of a range of cells, simply double-click the edge of the selected range in the direction you want to move.
- When you double-click the edge of your cell, the active cell will jump in that direction to your last cell until it comes across a blank cell. This works juts like when you hold down your CTRL key and click one of your Arrow keys.
Here’s another little trick that can be used to select a range of cells or extending a selection of cells.
- Depress your Shift key and double-click the edge of the selected range and the range will be expanded in that direction until it comes to a blank cell.
I think you have to admit that is a pretty nifty trick and it saves time and keystrokes to boot! A win – win situation if ever there was one!
—
Ctrl and an arrow key moves you to just before the next blank cell in the direction of the arrow (up, down, right, or left).
True. And Ctrl + Shift + arrow keys will select the range.
(For those who prefer keyboard shortcuts rather than mousing around).
Here’s an Excel issue I’d love to see a solution to:
I was wondering if it is possible to write an Excel macro that would not just point to a string that I am searching for in a comment, but also open the comment and leave the cursor blinking on the line where the match was found.
I have a spreadsheet with many sheets and many comments within many cells, and the default action that Excel takes by just pointing to the comment that contains the match is not good enough. I then have to open the comment and cut & paste its contents into NOTEPAD and then perform another search on the string I am after!
Since I do this a lot it turns out to be a huge consumption of my time and something a macro should be able to do, don’t you think?