Most Helpful Excel Shortcuts for Digital Marketers
Do you spend your days trying to figure out how to spend LESS time in Excel? Then we have the cheat sheet for you! Click here for great Excel shortcuts!
Excel is used all the time, if not everyday by PPC managers, knowing the Excel shortcut keys has often helped cut down the time spent looking for the function or formula while working in Excel. Whether you are analyzing data or putting together a report, utilizing the shortcut keys comes in handy if you want to save the time and headache from searching in the drop down menus.
Here are some of the most commonly used shortcuts for your reference, and even if you are an experienced Excel user, this list can serve as a refresher for some1 that you might have forgotten about.
Ctrl+A: Quickly Select All Of The Cells With Data
Ctrl+B: Quickly Bold The Text In Selected Cell(S)
Ctrl+C: Quickly Copy The Text In The Selected Cell(S)
Ctrl+D: Quickly Fill Data From The Cell Above In The Selected Cell
Ctrl+F: Quickly Access The Find Option For Data Search
Ctrl+H: Quickly Access The Replace Option For Data Replacement
Ctrl+I: Quickly Italic The Text In The Selected Cell(S)
Ctrl+K: Quickly Insert Hyperlink In The Selected Cell
Ctrl+N: Quickly Open A New Excel Workbook
Ctrl+O: Quickly Access The Open Options
Ctrl+P: Quickly Access The Print Options
Ctrl+R: Quickly Fill Data To The Selected Cell On The Right
Ctrl+S: Quickly Access The Save Option
Ctrl+U: Quickly Underline The Text In The Selected Cell(S)
Ctrl+V: Quickly Paste The Text Copied In The Selected Cell(S)
Ctrl+W – Close: Quickly Access The Close Option
Ctrl+X – Cut: Quickly Cut The Data In The Selected Cell(S) To Paste In A Different Cell
F2: Quickly Edit Data In The Selected Cell(S)
F7: Quickly Spell Check The Worksheet
F12: Quickly Access Save As Option
Ctrl+: Quickly Insert Current Date
Ctrl+”: Quickly Copy Value From Cell Above
Ctrl Shift +: Quickly Insert New Row Or Column
Ctrl+Spacebar: Quickly Select The Entire Column
Shift+Spacebar: Quickly Select The Entire Row
Ctrl+Shift+L: Quickly Apply Filters To The Top Row
Ctrl+Alt+V: Displays The Paste Special Dialog Box
*Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program.