fbpx
Search
Close this search box.

All articles in 'Keyboard Shortcuts' Category

35 shortcuts & tricks to make you an #AWESOME Data Analyst

35 shortcuts & tricks to make you an #AWESOME Data Analyst

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 35 shortcuts, productivity hacks and tricks to help you be even more awesome.

Continue »

Top 5 keyboard shortcuts for Excel Charts

Published on Apr 24, 2018 in Charts and Graphs, Keyboard Shortcuts
Top 5 keyboard shortcuts for Excel Charts

We all know that learning a few keyboard shortcuts can speedup your Excel game. Most pro users rely on a handful shortcuts when working with large spreadsheets. But when it comes to charting, we automatically reach for mouse. But do you know that you can use few simple shortcuts to do most day to day chart related things?

Ready for top 5 keyboard shortcuts for Excel charts? Read on.

Continue »

Copy Paste Visible Cells only (Two more ways to do it)

Published on Aug 28, 2017 in Excel Howtos, Keyboard Shortcuts, Learn Excel
Copy Paste Visible Cells only (Two more ways to do it)

Last week, we talked about how to copy and paste visible cells alone (ie exclude any filtered rows or hidden columns etc.) In the comments section many of you suggested two more ways to deal with this annoying problem. Let’s take a look them.

Continue »

Copy & paste visible cells only [Excel Trick]

Published on Aug 24, 2017 in Keyboard Shortcuts, Learn Excel
Copy & paste visible cells only [Excel Trick]

Here is something annoying with Excel.

Open any Excel file with few columns of data. Hide some of those columns (select the columns and press CTRL+0). Now, copy a few rows of data. Paste it else where. Excel will paste the values in hidden columns too. We thought Excel would omit the values in hidden columns.

What the filter Excel?!? I thought we were friends, but you annoy me with some of these quirks.

Continue »

Jo’s first keyboard shortcut

Published on Jun 12, 2017 in Keyboard Shortcuts

Jo, my lovely wife quit her job as my partner in crime at Chandoo.org recently and took up a lucrative position at NZ govt. agency. The other day I asked her “how was your day?” when she got home. She smiled and said, “I learned my first Excel shortcut!”.
Guess what it is?

F4.

That is right. The mighty F4 key. You can use it to repeat any action.

Jo was using it to insert rows in her workbook. After inserting first row (using CTRL+ of course), she would press F4 to add more rows as needed.

Continue »

Use CTRL to make copies of worksheets quickly

Published on Feb 15, 2017 in Keyboard Shortcuts, Learn Excel
Use CTRL to make copies of worksheets quickly

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 »

Weekend open mic – Share your one hand Excel shortcuts

Published on Aug 12, 2016 in Keyboard Shortcuts
Weekend open mic – Share your one hand Excel shortcuts

At Chandoo.org, we are big believers of keyboard shortcuts. There are several posts (1,2,3,4more 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 »

5 Shortcuts for you, one for every weekday [Awesome August]

Published on Aug 1, 2016 in Keyboard Shortcuts, Learn Excel
5 Shortcuts for you, one for every weekday [Awesome August]

Let’s kick start our Awesome August 2016 with a simple but very useful set of shortcuts. 5 shortcuts, one for each weekday.

  1. 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.
  2. Tuesday CTRL + T: Create a new table from data in current region. For more on tables, check out our Introduction to Excel Tables page.
  3. Wednesday CTRL + W: Close the current workbook, while keeping Excel open.
  4. Thursday ALT + T O: Opens Excel options. Very easy to remember too.
  5. 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.
Continue »

Autosum many ranges quickly with Multi-select & ALT= [quick tip]

Published on Feb 26, 2016 in Keyboard Shortcuts, Learn Excel
Autosum many ranges quickly with Multi-select & ALT= [quick tip]

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 »

Are you an analyst? Use these 25 shortcuts & tricks to boost your productivity

Published on Jul 7, 2015 in Keyboard Shortcuts, Learn Excel
Are you an analyst? Use these 25 shortcuts & tricks to boost your productivity

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 »

Formatting shortcuts for keyboard junkies

Published on Mar 17, 2015 in Charts and Graphs, Keyboard Shortcuts, Learn Excel
Formatting shortcuts for keyboard junkies

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 »

Comprehensive List of Excel Keyboard Shortcuts

Published on Feb 22, 2010 in Featured, Keyboard Shortcuts, Learn Excel
Comprehensive List of Excel Keyboard Shortcuts

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 »