Faster At Excel

  • Home
  • Book: Excel Shortcut Bible

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

Lazy Cheating Bum’s Guide To Excel Shortcuts

January 19, 2016 by terp Leave a Comment

How Can I Become A Lazy, Cheating Bum With Excel Shortcuts?

Excel shortcuts are for “lazy” people (actually, for smart and efficient people).  But I’d like to take laziness to another level — and show you how to be lazy about being lazy.

excel-shortcuts-cheating

Excel provides some easy ways to discover shortcuts, or remind yourself of them if you’ve forgotten.  These methods work with some types of shortcuts, and only in some situations.  However, they can be very useful, especially while you’re learning shortcuts.  Or, if you’re too lazy to remember shortcuts, this is your easy way out.
[Read more…]

Filed Under: Alt Shortcuts, Cut Copy Paste, Delete, Excel Shortcuts, Menu Key, Paste Values Tagged With: Alt Shortcuts, Excel Shortcuts, Format Painter, Paste Values

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

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