Daily posts of Excel tips…and other stuff
Archive for the ‘Navigation’ Category.
Surely you know that you can Windows - Arrange to put two workbooks side-by-side or top-to-bottom. But sometimes I have a bunch of workbooks open and only want to look at a couple of them. If I minimize the windows I don’t want, I can arrange the non-minimized.
In this video I want to [...]
The problem with posts about keyboard shortcuts is that I list ten or twenty of them and exactly none of them stick. So I’m just doing one.
If you have to select a long column of data, using the mouse can take a while. And if I’m sitting behind you in your office trying [...]
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 [...]
