targetspeedsite.blogg.se - Change cursor direction in excel for mac

Specify whether the range has header cells or not, and click OK.

To create a table, select the existing data and do the following: Simply convert the input range to a table and Excel will control data input as above - simply press Tab to move from cell to cell, within the table range. My third data input trick is to use Excel's Table feature (Excel 2003 doesn't support this feature). This quick selection tip makes quick work of on-the-fly data input tasks. After typing the first date, you press Tab to select B29, enter the data and press Tab again. At this point, when you press Enter, Excel will move the cursor to the left-most column in the next row.įor instance, in the sheet below, you'd select A29:B33 to enter the next five records. Excel will move the cursor from column to column until you reach the right-most column in the selection. Simply select the data input range and start entering data. The second trick I have in mind is temporary. This is a permanent change, but it's easy to reset, so don't let that stop you from using it to your advantage.

In Excel 2003, the option is Move Selection After Enter. You can choose Right, Left, Up, and Down. In the Editing Options section, choose Right from the Direction dropdown under the After Pressing Enter, Move Selection option, as shown.In Excel 2003, choose Options from the Tools menu. In Excel 2007, click the Office button, and then click Excel Options. Click the File tab and then click Options (under Help).Pressing Tab is a bit easier than stretching for the right arrow key, but perhaps the easiest solution is to change the cursor movement as follows: Now, you can press the right arrow key instead of Enter, but doing so will slow you down. If you're entering data from column to column, it can be downright infuriating. That's not always the direction you'll want to go. Fortunately, you can get Excel to work with you instead of against you, if you know these quick tips for controlling the cursor's movements.įirst, Excel moves the cursor down to the next cell when you press Enter. Data entry can be a thankless job and if Excel doesn't cooperate, it can be a hateful job.