Faster At Excel

  • Home
  • Book: Excel Shortcut Bible

  • Shortcuts
  • Blog
  • Archives
  • Links
  • My Account
  • Login
  • About
  • Contact

Excel Formatting Shortcuts

September 4, 2015 by terp Leave a Comment

The Basics Of Excel Formatting Shortcuts

Formatting is a common task in Excel.  So what are some good formatting shortcuts to increase your speed?

Excel-Formatting-Shortcuts

First, memorize these shortcuts for opening up the Format Cells dialog box (shown below):

Format Cells Dialog Box (keyboard): Ctrl+1

Format Cells Dialog Box (hybrid): Right Click+F*

(*Note: this won’t work if you have copied something into the clipboard since at that point “F” will activate the paste Formulas option instead).

format-cells-dialog-box-excel

You can switch between tabs in the dialog box with your mouse or by typing the first letter for tab (e.g., “F” for Font).

Second, there are some common formats with easy shortcuts:

Bold (keyboard): Ctrl+B –or– Ctrl+2

Italics (keyboard): Ctrl+I –or–Ctrl+3

Underline (keyboard): Ctrl+U –or– Ctrl+4

[Read more…]

Filed Under: Format Cells, Formatting, Paste Special Tagged With: Excel Shortcuts, Format Cells, Format Painter, Paste Formats, Paste Special, Quick Access Toolbar - QAT

Excel Paste Special Shortcuts To Make You Faster

September 2, 2015 by terp Leave a Comment

Basic Paste

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.

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.

Excel-Paste-Special-Basics

[Read more…]

Filed Under: Convert Text To Numbers, Copy & Paste, Excel Shortcuts, Paste Special, Paste Values Tagged With: Excel Shortcuts, Menu Key, Paste Special, Paste Values

Excel Shortcuts: Mouse-Keyboard Hybrids

August 2, 2015 by terp Leave a Comment

Keyboard Or Mouse?

What’s faster?  The mouse or the keyboard?  That is the question when it comes to speed and Excel shortcuts.

Like most people, I employ both types — I am a “hybrid” user.

In theory, a keyboard-only approach is fastest.  However, for most people (including me), a keyboard-only approach is a bridge too far, requiring too much memorization.  Moreover, the mouse is comfortable and, in many cases, actually faster than the keyboard.  So I typically use keyboard shortcuts involving only those keys reachable by the left hand (without looking at the keyboard).  I keep the right hand on the mouse unless putting it on the keyboard will clearly save me a lot of time (e.g., navigating and selecting large ranges).

Hybrid Excel Shortcuts

One great example of a fast hybrid shortcut is right clicking the mouse, then typing the shortcut key with your left hand.  Beginning an action with the mouse doesn’t require you to finish it that way.

[Read more…]

Filed Under: Excel Shortcuts, Keyboard Shortcuts, Right Click Tagged With: Excel Keyboard Shortcuts, Excel Mouse Shortcuts, Excel Shortcuts, Format Cells, Paste Special

  • « Previous Page
  • 1
  • …
  • 9
  • 10
  • 11

Post Categories

Tags

Alt Shortcuts Books challenges Charts comments cut copy paste data Double Click Excel Formulas Excel Keyboards Excel Keyboard Shortcuts Excel macros Excel Mouse Shortcuts Excel Shortcuts Excel Speed Tricks F-Key Shortcuts Filter Find & Replace Font format Format Cells Format Painter Formatting freeze panes Hybrid Shortcuts Menu Key Open Paste Formats Paste Special Paste Values Products Quick Access Toolbar - QAT save Selection and Navigation Sort

Recent Posts

  • 3 Ways To Convert Text To Numbers In Excel
  • 5 Quick Data Set Up Excel Shortcuts
  • Excel Shortcut Bible: Comprehensive Excel Shortcut Book
  • 7 Easy Excel Speed Tips
  • Basic Excel Macros: Part 3 Of 3, Personal.xlsb & Adding A Macro To Your Quick Access Toolbar

© 2016 Faster At Excel