Not just that, learning something new (like shortcuts) can make you smart & sexy (as they as in Big Bang Theory, Smart is the new Sexy). Just by learning a few handful shortcuts, you can save tons of time, work faster and create lasting impact. Shortcut key to switch between relative, absolute and mixed references. Enter data by using shortcut keys Move t o the beginning of the line, HOME Edit a cell comment, SHIFT + F2 Create names from row and column labels, CTRL +.
#SHORTCUTS FOR EXCEL 2010 HOW TO#
Keyboard shortcuts are the low hanging fruits you must pluck in your journey to of Excel awesomeland. How to select row and column by keyboard. Where shortcut keys must be pressed together they will be shown like this. Do let me know what you think in comments.Īnd I really appreciate your reviews & comments on iTunes. Below is a huge list of Excel keyboard shortcuts you can use to work faster.
Excel 2010 has over 180 shortcut keys for quick navigation.
These short format sessions will run once a month (along with longer sessions that we publish almost every week) so that you have something light & easy to chew between heavy doses of Excel awesomeness. It is a little bit irritating to be constantly stopped by the necessity to drag the mouse back and forth the mouse across the menus and ribbons to search for ordinary tasks of inserting tables or often essential actions. In the 12th session of podcast, lets get productive fast.Īnnouncement: Short format podcasts sessions once a monthīased on your feedback, I am adding short format sessions (20 mins).