Daily posts of Excel tips…and other stuff
Archive for the ‘Navigation’ Category.
I have never found a decent keyboard shortcut for filling a series, despite being the self-anointed king of all things keyboard. Oh sure, I could Alt+E, I, S, Enter, but it's just not satisfying. So in the vein of selecting adjacent columns, I added a macro to my Personal.xls.
Sub FillSeries()
[...]
Hi everyone,
I am busy building my very first COM addin for Excel and I've now come to the stage that I need some beta testers.
Who would be willing to run some tests on my new "Excel Formula Reference Auditing Utility" (see screenshot below)?
If interested, send me an email:
info@jkp-ads.com
What's in it for you? a free copy [...]
I had a worksheet table with blank rows separating the groups.
I needed to add another column - a formula - but wanted to retain the blank rows for formatting tidiness.
The table after adding the formula column:
Notice the formula produces zeros for the blank rows. I could just select each cell (D3, D5, D8, D10) and [...]
The Control+ArrowKey shortcut is my new favorite shortcut. I seem to be using the heck out of it lately.
In Excel (cell navigation), it works like the End key. Control+Down Arrow is the same as End, Down. Add the Shift key for a handy way to select column of data.
In Excel (cell editing), [...]
Did you know that Excel's scrollbars had a right click menu? I didn't until just recently. (Hat tip: Shane and JWalk).
I can't think of a use for these menus. My mouse is already down there, so why wouldn't I just left click on the arrow (Scroll Right), left click in the scroll area [...]
Sometimes filling a sheet full of data can be slow and painful. It's the navigating between cells that slows me down.
You know how it goes, type the First Name, (arrow right), (arrow right), (arrow right), type the Last Name, (arrow down), (arrow left), (arrow left), (arrow left), type the Occupation, etc...
Maybe you've resorted to using [...]
So Dick is the keyboard guru here, but there's a lot of people that use the mouse a lot. I know I do. And I was reading Jensen Harris' blog today about how a Paste Special operation takes 6 clicks right now, but only 3 in Office 12.
However, there are a number of [...]
I've found myself in the situation where no matter where I moved my cursor, the selection was extended. This is usually because I accidentally hit the F8 key to enter Extended Selection mode. I don't think I've ever used it on purpose.
However, in my never-ending quest to rid myself of the mouse, I [...]
