All articles in 'Keyboard Shortcuts' Category
The other day, I found myself making copies of a templated report worksheet. After trying the usual route of “right click on source sheet, select move or copy, check create a copy and press OK” a few times, I thought “well that is asinine.” So I figured, may be CTRL+Drag will create a copy. And what do you know, it does.
So that is our quick tip for the day. Whenever you need to make a copy of something, simply hold CTRL key and drag the thing.
It works for charts, drawing shapes, worksheets and even ranges.Continue »
At Chandoo.org, we are big believers of keyboard shortcuts. There are several posts (1,2,3,4, more and even more) discussing useful Excel shortcuts. Today I want to introduce a new kind of keyboard shortcuts. One hand shortcuts.
One hand shortcuts – Half the work, double the fun
The idea is simple. When you can use only one hand to complete the shortcut key presses, it is called as a one hand shortcut.Continue »
Let’s kick start our Awesome August 2016 with a simple but very useful set of shortcuts. 5 shortcuts, one for each weekday.
- Monday ALT + M N: Open name manager. Very handy, if you have quite a few range names and want to edit / manage them. Remember, this is a sequence shortcut, that means, you press ALT M, let go of both keys and then press N.
- Tuesday CTRL + T: Create a new table from data in current region. For more on tables, check out our Introduction to Excel Tables page.
- Wednesday CTRL + W: Close the current workbook, while keeping Excel open.
- Thursday ALT + T O: Opens Excel options. Very easy to remember too.
- Friday CTRL F: Fridays can be hard to concentrate. Use CTRL+F to find what you want in the current workbook. Use CTRL+H if you wish to do a find replace.
Let’s say you have data in a worksheet in various ranges, and you want sum up each range at the bottom.
Something like this:
How to do all this one shot?
Simple. We use multi-select & ALT=Continue »
Analyst’s life is busy. We have to gather data, clean it up, analyze it, dig the stories buried in it, present them, convince our bosses about the truth, gather more evidence, run tests, simulations or scenarios, share more insights, grab a cup of coffee and start all over again with a different problem.
So today let me share with you 25 shortcuts, productivity hacks and tricks to help you be even more awesome.Continue »
A lot of analysts swear strong allegiance to keyboard shortcuts. But when it comes to formatting a spreadsheet, these shortcuts go for a toss as formatting is a mouse-heavy activity.
But we can use a few simple & effective shortcuts to zip through various day to day formatting tasks. Let me share my favorite formatting shortcuts.Continue »
Few weeks back I have invited all of you to share your excel keyboard shortcuts in a open thread. More than 50 people commented on that post and shared a hundred excel keyboard shortcuts with us. There were so many wonderful keyboard shortcuts and tricks buried in the comments section of that post. During the […]Continue »