excel keyboard shortcuts cheat sheet 2013

#Excel keyboard shortcuts cheat sheet 2013 for free#
#Excel keyboard shortcuts cheat sheet 2013 full#
#Excel keyboard shortcuts cheat sheet 2013 plus#

Alt + D + G + S – Show Grouped Rows / ColumnsĪpart from the above, here are few others shortcuts that you might find useful.Alt + D + G + H – Hide Grouped Rows / Columns In this state, you generally have to use the function key (Fn) when using function keys (F1, F2, etc.) Click here for more information.Alt + D + G + U – Ungroup Rows / Columns.This is useful if you need to routinely working with columns and rows and Excel formulas. Alt + H + L + C + S – Delete Conditional Format.Alt + E + S + V – Paste Values (after Ctrl + C ) * F4 repeats the same action to other cells after pasting once.Alt + E + S + T – Paste Formatting (after Ctrl + C ) * F4 repeats the same action to other cells after pasting once.Our friends over at have provided a handy Excel Shortcut info-graphic going over some popular Excel shortcuts. Alt + E + S + F – Paste Formula (after Ctrl + C ) * F4 repeats the same action to other cells after pasting once 6 Comments / Workbook/Reference Lessons / By cobainbc15.Alt + H + B + P – Top Border *for adding lines.

#Excel keyboard shortcuts cheat sheet 2013 full#

If your Excel sheet is full of color you might want to master this section of keyboard shortcuts.

Ctrl + Home – Move to Cell A1 (top left).

Ctrl + Pageup / Pagedown – Move to Next / Previous Worksheet Tab.

We take your privacy seriously, and well never share your email - ever.

#Excel keyboard shortcuts cheat sheet 2013 for free#

Well email you the cheatsheet for free and let you know when ever there are any updates.

Ctrl + Minus (# pad) – Delete Row / Delete Column Please enter your first name and email address.

#Excel keyboard shortcuts cheat sheet 2013 plus#

Ctrl + Plus (# pad) – Insert Row / Insert Column which means press Alt and H together, then release those keys and press A, then C.

Ctrl + Arrowkey – Jump to Edge of Content.

Navigating through Excel spreadsheet could be time-consuming, especially if you are dealing with a large data-set.

Ctrl + Alt + V – Paste special, will trigger the prompt for more options.

Alt + W + Q – Zoom in (type in % zoom, helpful with large dataset).Alt + H + 9 – Remove one decimal * requires pressing all keys at the same time.Alt + H + 0 – Add one decimal * requires pressing all keys at the same time.F2 + F9 – Show as input number *useful for checking numbers but press ESC after (or you’ll change formulas into an input).F2 – Edit Cell, Show Formula (avoiding double-click).The key is to minimize the use of the mouse and do as much as you can with the keyboard to save you time and improve accuracy. Start with some basic and most frequently used ones in all kind Excel workflow. Some laptops have Fn Lock Mode so that you don't have to press Fn with the the function keys.Ĭheckout our post on the Best Keyboards for Excel Keyboard Shortcuts to learn more.If you work with Excel on a daily basis, it’s worth spending an extra 10 minutes to sharpen and improve on your shortcut games, because this 10 minutes investment will pay back exponentially in no time. You might also need to press the Fn (function) key in combination with the function keys F1 to F12. Laptop keyboards tend to have smaller keyboards and don't always contain keys like Page Up, Page Down, Menu, etc. If you are using a laptop keyboard then you might be limited on the some of the shortcuts you can press. Here’s the Excel Keyboard Shortcuts Cheat Sheet with 82 shortcuts that you can use in your daily work and below are the top 10 out of them: Ctrl + Shift + (Applies the currency format) Ctrl + (Open the format option dialog box) Control + T (Applies the Excel table to the selected data. Press & release Alt, then press & release E, then press & release S. For example, to press the shortcut Alt,E,S to open Paste Special, you will: The, (comma) between keys means press & release each key in order. Press & hold Ctrl, then press & hold Shift, then press L. For example, to press the shortcut Ctrl+Shift+L to Toggle Filters, you will: The + (plus) between keys means press & hold the keys together in order. There are two ways to press the shortcut keys depending on the separator character used in the sequence.