![]() ![]() ![]() If you have clicked on an empty cell, then the shortcut will take you to the end of the spreadsheet. Shortcut Description ctrl + → Takes you to the right-most column of data if you have clicked a data cell. We’ll go ahead and use the PC “ctrl” key, for these examples but Mac users will know to replace this with the command ⌘ key. To navigate data only, we use the ctrl + arrow keys (⌘ + arrow keys, for Mac). We quite often find ourselves in a position where we need to quickly get to the start or end of data in a row or column or an entire document. Shift + mouse wheel 1.2 Top, Bottom, Beginning, End You know how you can scroll up and down your screen by using that handy dandy scroll wheel on your mouse? What if I told you that you could do the same horizontally (or left to right)?Īll you need to do is hold down shift while using the mouse wheel. It is a universal tool for all your programs and apps. This first one is not exclusive to Google Sheets. There are some infinitely better ways for you to navigate around your data in Google Sheets than clicking and dragging the scroll bar or… gasp!!!…using your arrow keys on each and every cell. Duplicating Formulas Down a Row or Column 3.4 Selecting All Data Ranges and Whole Sheets. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |