iheartopk.blogg.se

Press Option+Return to create a line break following the cursor’s position.

Line breaks are clumsy to perform using a touchscreen, but with a keyboard, it becomes super-easy. If a single cell has a list of multiple items, Excel for iOS lets you move the cursor to the beginning of the cell (Command+Up Arrow), to the end of the cell (Command+Down Arrow), to the beginning of the line (Command+Left Arrow) or end of the current line (Command+Right Arrow) using your keyboard quite easily.

Instead, the Left Arrow and Right Arrow directional keys are always there to help you easily go about your business.Įven better, you can move the cursor faster using the Option+Left Arrow or Option+Right Arrow shortcuts. IOS is still pretty weak when it comes to moving the cursor around - using touch, and you waste precious seconds even to move it. Instead of wasting time with touch gestures, hold down Shift key and use the arrow keys to select multiple cells in the respective direction. The tiny cells can pose a huge problem when it comes to selecting multiple items to either merge, fill, or perform any other task. You can also perform this shortcut to immediately return to the beginning of the next row, which is pretty useful when you’ve covered a fair distance using the Tab key. Once you are done with a cell, press the Return key to drop down to the cell below.

While you can also use the Right Arrow key to achieve the same purpose, the Tab key is a tad better at maintaining your flow. When you want to focus on just a row at a time, you can also use the Tab key to keep moving by one cell to the right. Instead, hold down the Command (⌘) key along with the relevant directional arrow key to instantly move over to the next occupied cell in a jiffy. What if there are multiple vacant cells in between the cells that you want to move to? It’s not a fun experience to repeatedly press the arrow keys to get there. Just use the Left, Right, Up, and Down directional arrow keys to easily navigate a spreadsheet. The solution - arrow keys on the keyboard. Further, the chances of performing the wrong gesture and messing things up can feel even more disconcerting. Selecting cells by tapping the screen can often be hit or miss, especially when it comes to a tightly-packed spreadsheet. Navigational Shortcuts Move Between Cells Note: On your Bluetooth Keyboard meant for Windows-based devices, use the Windows logo key in the place of Command and ALT in the place of Option key for shortcuts.