Faster At Excel

Excel Magic: 4 Clever Shortcuts To Copy And Paste Simultaneously

by Leave a Comment

Ready For Some Magical Excel Shortcuts?

Did you know you can copy and paste simultaneously in Excel?

Just use Ctrl+D, Ctrl+R, Ctrl+Enter or Autofill.

excel-copy-paste-ctrl-d-r-enter-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…]

Double-Click Excel Shortcuts

by Leave a Comment

What are some great double-click Excel shortcuts?

Double-clicking in Excel is like lighting dynamite — it tends to “explode” or expand things.

ExcelDoubleClickDynamite

Here are my favorite double-click shortcuts — what about you?

AutoFit: Double click on the edge of a column (or row) to automatically resize it to the widest (or tallest) column (or row) (you can do a similar thing with the bottom of the formula bar) [Read more…]