All articles with 'keyboard shortcuts' Tag
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 »
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, 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?
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 »
One of the regular reporting tasks I do involves a manual step I hated. It goes like this:
- Dump several columns of data in the template file.
- Hide a particular set of columns (these are not together, so must be done one at a time or with CTRL+selection)
- Save and publish the file.
After doing this manually for last few fortnights, today I wanted to automate the column hide process. I was about to write a VBA macro to clone the hide settings from one workbook to another. But then I thought, may be paste special can be of use.
And what do you know. It does exactly that.Continue »
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 »
We are on a tiki tour around NZ. So far we have been to Taupo & Rotorua. And we are doing what you do when you are on a holiday – being lazy, going on walks, swimming in lakes, eating copious amounts of food and getting lost. Of course, all this means, I have very little time to access to internet & my blog. So the updates will be slow for next two weeks. Here is a quick tip (well, two of them) to keep you busy and awesome.
How to remove ugly formatting from your workbooks?
Do you have a colleague or boss (shudder) that loves to apply their special touches to every workbook their mouse lands on? Do you constantly wince and whine when you have to work on that spreadsheet.
Here are two handy ways to restore your data to its original glory.
Simple, select the data you want formatting gone from, go to Home > Clear > Formats.
And Excel will weave an expelliformat spell at your data and make it clean.
Here is a quick demo.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.
Ever wanted to show your workbook to someone and felt that you had less screen real estate? This tip will help you get more out of your workbook.
So how to get 50% more space for your workbooks?
Simple, just follow these steps.Continue »
Learn some of the Microsoft Excel MVP’s favorite Excel Tips, Tricks, Cheats & Hacks in this post
Excel Tips, Tricks, Cheats & Hacks – Microsoft MVP Edition
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 »
This is going to be epic!!! In the 50th session of Chandoo.org podcast, we have 50 Excel tips to make you awesome.
What is in this session?
In this podcast,
- Thank you message
- Fifty tips in 5 buckets
- Shortcuts & Productivity
- Managing Data
- Using Excel better
Let’s keep this simple & short.
Whenever you are editing cells or formulas, the usual sequence is like this:
- Double click on the cell you want to edit
- For existing cells: Go to the left most / right most part and start typing
- For blank cells: start typing right away
Here is a faster sequence:
Read on…Continue »
Making your workbooks, charts, dashboards & presentations beautiful is a time consuming process. It is a mix of art & craft. Naturally, we spend hours polishing that important slideshow or visualization. But do you know about simple features in Excel that can save you a lot of time and help you create gorgeous output?Continue »
Excel has many powerful & time-saving features. Even by Excel’s standard, Flash Fill is magical. Introduced in 2013, Flash Fill is a rule engine to Excel’s fill logic. Every time you type something in a cell, Excel will try to guess the pattern and offers to fill up the rest of cells for you. That is some serious time saving magic.
Let’s understand what Flash Fill is and few sample use cases.Continue »