Did you know you can copy and paste simultaneously in Excel?
Just use Ctrl+D, Ctrl+R, Ctrl+Enter or Autofill.
These magic tricks don’t fit every situation. But when they do fit, they’re lightning fast.
Below is a magic show — and after that the magic tricks are discussed. [Read more…]
If you want to enter something in cell A1, and have the same value or formula extend down to A20, how would you do it? Here are three methods that are commonly used:
Here’s a fourth one that’s simple, yet not as commonly used — and you’ll see that it’s also faster and more flexible:
4. Ctrl+Enter
So how does Ctrl+Enter work?
Simple: just select your whole range BEFORE you start typing. Then, after you’re done typing, hit Ctrl+Enter instead of Enter.
Here’s my FREE one-hour course: Basic Excel Shortcuts For 11 Everyday Tasks: Get 65% Faster
I’ll teach you 16 basic Excel shortcuts to get 65% faster at 11 everyday tasks: Save, Copy, Paste, Cut, Undo, Redo, Bold, Italics, Underline, Find and Replace.
I’ll also show you how to memorize shortcuts — plus some neat tricks to make Excel remind you what the shortcuts are.
If you’re slow at Excel and want to become more productive, this course is custom made for you! It’s easy to follow, and you only need to be a beginner in Excel.
The course has 9 lectures.
Get 65% faster at basic Excel tasks — in less than an hour!
Sign up now — before it’s no longer free!
Say you have 1000 rows of data, with 15 hidden rows. You’ve hidden those 15 rows because you don’t want to copy them. You select the 1000 rows with Ctrl+A, then you do Ctrl+C to copy, and then Ctrl+V to paste. Your selection (before you paste) looks like this:
You’re moving fast and you think you’re a shortcut genius. But to your chagrin, they hidden cells get copied anyway.
Why? Because you selected them (even if you didn’t know it).
So how do you solve this problem without slowing down?
Simple: Alt+; [Read more…]
The fastest way to cut, copy and paste is by using the keyboard shortcuts Ctr+X, Ctr+C and Ctr+V. Ctrl+V performs the basic paste operation — and includes the formulas and formatting, if any. But sometimes you want to do more — or less — when pasting. And pasting can be used in ways you’ve never imagined. Enter Paste Special.
The animation below shows some of the neat things Paste Special can do in Excel: pasting just values (no formatting or formulas), pasting a picture (that you can move around) and pasting formatting onto other numbers.
