I'm still learning new ones all the time, and getting recommendations is awesome.
#SELECT ROW IN EXCEL KEYBOARD SHORTCUT WINDOWS#
If your most-used shortcut keys for spreadsheets or windows are different than what I've already listed, please comment below and share.
![select row in excel keyboard shortcut select row in excel keyboard shortcut](https://res.cloudinary.com/diqqalzsx/image/upload/v1581046727/content/Excel/Insert-Row-Shortcut-in-Excel_ytz5or.png)
If you turn on "Enable compatible spreadsheet shortcuts" then you can use a lot of the same shortcuts you may be used to from Excel. Keyboard Shortcuts for Google Sheets: Open up a file in Google Sheets and go to Help > Keyboard Shortcuts.Keyboard Shortcuts in Excel - This article provides the official long list of shortcuts for Excel.The first 36 shortcuts will be displayed automatically in the Bingo sheet. You can mark your own favorites, filter, sort, or even randomize the list. Maybe you already know most of them and want a fun way to learn others.Īll you need to do is go to the Shortcuts worksheet and add your own set of shortcut keys.
#SELECT ROW IN EXCEL KEYBOARD SHORTCUT DOWNLOAD#
The Keyboard Shortcut Bingo download above can also be used to create your own custom sheet of keyboard shortcuts. Customizing the List of Keyboard Shortcuts Switch the mouse to the other side of your keyboardĪny one of these techniques will help you quickly realize how often you switch between the keyboard and the mouse.Put your mouse far out of reach so that it's a pain to use it.To force yourself to get proficient with shortcuts, try one of these ideas: That will help cement it into your long-term memory. Ctrl-Up- The shortcut moves the cursor to the first row with data before a blank row. Repeat the use of a shortcut 10-30 times to get some muscle memory, then do it again (maybe fewer repetitions) an hour later, then again once or twice a day for the next few days. Here are the keyboard shortcuts that you need: Ctrl-Down- The shortcut moves the cursor to the last row with data before the first blank row that is encountered this may be the last row in the table ideally, but only if there are not any blank rows in the table. The best way to learn keyboard shortcuts is to use them. Here is a list of my most-used ALT access keys so far: I haven't used very many of these types of shortcuts, but if I'm doing anything really repetitive it often helps to see if there is an access key sequence that can speed things up. This allows you to use commands like align center ( ALT+ H, A, C) which may not have other keyboard shortcuts defined. Then, press the sequence of keys that show up. In the newer versions of Excel, you can do pretty much anything with the keyboard if you use ALT key shortcuts to access the menu and ribbon options. Shortcuts like CTRL+ Arrow let you quickly move through text and CTRL+ SHIFT+ Arrow lets you quickly select text.Īnother combination that I use all the time to insert new rows is to first select the row with SHIFT+ SpaceBar, then insert a row with CTRL+ SHIFT+ = (or think of it as Ctrl Plus), then copy the row above with CTRL+ D (to copy formulas down). For example, when you are editing text, use a combination of the shortcuts listed on the 3rd row of the bingo sheet. Some of these keyboard shortcuts work best in combinations. If you are using a Mac, you are welcome to use the spreadsheet to modify the list and create your own hotkey bingo sheet with shortcuts for Mac. I've marked these with a ⊞ symbol and bold text (most of them are in the first 3 rows of the bingo sheet). Many of the shortcuts that you can use in Excel and Google Sheets work as general Windows hotkeys for other programs as well.
![select row in excel keyboard shortcut select row in excel keyboard shortcut](https://cdn.educba.com/academy/wp-content/uploads/2019/02/Shortcut-to-Merge-Cells-in-Excel.png)
Cross out or color in the shortcuts when you have mastered them. To help motivate you to learn more shortcuts, print this bingo-style list of shortcut keys and put it next to your computer. Most of these shortcuts will also work in Google Sheets. While not a random or complete list, if you master all of these shortcuts, you will be using about 95% of the shortcuts that I use on a regular basis. Instead, download and print a copy of my keyboard shortcut bingo sheet. Printing out a list of ALL spreadsheet shortcuts would be overwhelming. Using the keyboard efficiently can also help cut down on repetitive stress injuries that result from too much mouse use. More importantly, they make you more productive. When using the Query Editor in Power Query Online, you can navigate to the Keyboard shortcuts button in the Help tab to view the list of keyboard shortcuts.Keyboard shortcuts can save you a LOT of time. The table in this article lists all the shortcuts available in Power Query Online. For users with mobility or vision disabilities, keyboard shortcuts can be easier than using the touchscreen, and are an essential alternative to using the mouse. Keyboard shortcuts provide a quick way to navigate and allow users to work more efficiently.