#Shortcut keys for mac excel full#

#Shortcut keys for mac excel full#

Shift + Space Bar to highlight full row.ALT + Page Up/Down to move the view horizontally by the number of rows in the view.Cntrl + Page Up/Down to move between sheets.Page Up/Down to move the view vertically by the number of rows in the view.ALT + H + 0 to increase the number of decimal places.ALT + H + 9 to reduce number of decimal places.ALT + H + K to change number to comma format.

ALT + H + FC + Arrows + Enter to select font color.ALT + H + H + Arrows + Enter to select cell highlight color.Cntrl + arrows to navigate across ranges empty and filled cells.F2 to toggle between enter and reference in a cell.This article is broken down into 2 sections for shortcuts: Windows and Mac. While you can use it on Mac, you’ll be much more limited. Mac vs WindowsĮxcel is a Microsoft application and is therefore optimized for windows operating systems. This article outlines 32 shortcuts you should start with today to use Excel without the mouse and increase your efficiency.ĭon’t forget, you can get the free Intro to Data Analysis eBook, which will ensure you build the right practical skills for success in your analytical endeavors. Once Excel is open, keep your browser open behind your Excel and look up the shortcut for any action for which you don’t immediately know the shortcut. For any action you want to take, force yourself to ignore the mouse. The key is to always look for keyboard shortcuts. Personally, I started in an analytical role with almost zero knowledge of Excel, and I became keyboard proficient in less than 6 months. That’s why learning to use Excel without a mouse is so important. In addition, the further you progress in your career, the faster you need to produce results. Nobody likes to get bogged down clicking buttons with the mouse while their train of thought moves forward. If you’re a data analyst, a business analyst, a financial professional (or anyone who uses Excel for that matter) then you know the feeling of wanting to move faster in Excel.