F14 is the Scroll Lock key. It wasn't till I looked for 'Scroll Lock' that I finally found the solution. My arrow keys stopped working in Excel and I followed all of the examples here. Hopefully this helps someone else.You can always use the arrow keys to move up and down in the cells. You won’t want to use a mouse or trackpad all the time to move through the cells. If you put in a character, it is erased and the cursor is at the TextBox.Video: 30 popular Excel shortcuts in 12 minutes Display the Paste Special dialog boxTo quickly get things done, its important to learn the navigation shortcuts in Excel. This has been a terrible annoyance.How to create a file picker interface in EXCEL VBA with browse button in 3.
![]() The first time you use Control + A, the table data is selected. But if the cursor is in a group of contiguous cells, Control + A will select the entire group of cells instead.The behavior changes again when the cursor is in an Excel Table. If the cursor is in an empty cell, Control + A selects the entire worksheet. However, in Excel, this shortcut behaves differently in different contexts. Rather than scroll up, down, right and left, manually just put your cursor into the data and use Control + Arrow key to move in any direction to the edge of the data range (On a Mac you can use Command or Control). Move to edge of data regionThis shortcut sounds boring but it is vital if you routinely work with big lists or tables. Finally, the third time you use Control + A, the entire worksheet is selected. Extend selection to the edge of dataNavigating at high speed through a large table is great fun, but what really makes this idea powerful is selecting huge swaths of cells at the same time. You're never going to beat it scrolling. If we figure there are about 6 rows in an inch, then:1,048,576 rows / 6 = 174,763 inches / 12 = 14,564 feet / 5280 = 2.76 miles2.76 miles in 1 second * 60 = 165.6 miles per minute * 60 = 9,936 miles per hour.Since it really takes less than a second to travel more than 1 million rows, let's just call it 10,000 miles per hour. If you put your cursor in A1 and press Control + down arrow, you'll be past the millionth row in less than a second. If you start in an empty cell, the behavior is reversed - the cursor will move to the first cell with content and stop.Modern Excel has more than 1 million rows. Even though the cursor is moving at great speed, it will stop on a dime at the edge of a data region.Select right = Shift + Control + Right arrowSelect left = Shift + Control + Left arrowSelect down = Shift + Control + Down arrow Move to first cell in worksheetNavigating larger worksheets can get really tedious. The best part about using Shift + Control + Arrow is that your selections are perfectly accurate. A really long time.To save your sanity and avoid all that scrolling, just add the Shift key to the Control + Arrow shortcut, and you will *extend* the current selection to include all the cells along the way. What is the last cell? Good question. Move to last cell in worksheetIn a similar way, you can jump to the "last cell" in a worksheet using Control + End (Mac: Fn + Control + Right arrow). This will bring you straight back to cell A1, no matter how far you've wandered. If you just want to get back to the first screen in a worksheet, use the keyboard shortcut Control + Home (Mac: Fn + Control + left arrow). ![]() For example, if the cursor is in row 10 and you press Shift + Space, row 10 will be selected. To select a column, use Control + Space.Once you have a row or column selected, you can hold down the shift key and extend your the selection by using the appropriate arrow keys. To select a row, use Shift + Space. Select row / select columnBoth rows and columns can be selected with keyboard shortcuts. On Windows, this will open the find and replace dialog with with Replace selected. Rufus dmgJust select the first cell (or cells) then hold down the control or command key and click other cells to add them to your selection. This is easily done using Control + Click (Mac: Command + Click). You might want to enter the same data to several cells (see Control + Enter) change formatting, or even use the status bar to get an on-the-fly SUM for a group of random cells. Add non-adjacent cells to selectionYou'll often need to select cells that aren't next to one another. ![]() Here is the answer revealed: Alt + Enter (Mac: Control + Option + Return) will add a new line inside a cell. This is often a puzzle to Excel users (for obvious reasons) and I have no doubt that this puzzle has resulted in hundreds of thousands, if not millions, of Google searches. Control + G is still a worthy shortcut, however, because Go To Special is the gateway to many tricky and powerful features.Chandoo has a good article that explains Go To Special in detail here.Video: Go To Special to delete blank rowsVideo: Go To Special to weed out rows that are missing values ENTERING DATA Start a new line in the same cellThis is not so much a shortcut as something you simply must know to enter multiple lines in a single cell. From there, you need to click the Special button to get all the way to Go To Special. (See the previous shortcut for selecting non-adjacent cells.)Control-enter also has another use: use it when you want to enter a value into a cell and stay in that same cell after hitting return. You can even use Control + Enter to enter data into non-contiguous cells. This is a great way to save keystrokes when you want to enter the same value or formula in a group of cells. Use Control + Enter when you want to enter the same value in multiple cells at once.
0 Comments
Leave a Reply. |
AuthorClaire ArchivesCategories |