![]() ![]() If you set this menu to Right, Excel scrolls across the first selected row, and then wraps around to start at the first cell in the next row. In the ‘Editing options’ area, select your desired direction from the Direction drop-down menu below the ‘After pressing Enter, move selection’ label. If you want to control the direction in which Excel moves the cursor, you need to indicate your preference in the Excel Options.Ĭhoose File, Options, Advanced. ![]() When you enter data into a block of cells, you have to select the block before you start typing then, when you press Enter to complete an entry, Excel moves the cell cursor to the next cell automatically. Set the movement of the Excel cell cursor when entering data, with this Direction option. Save Keystrokes by Selecting a Range to Fill Note that this feature works with text but not with dates or numbers, and that it works only down a column. This list contains only the items you’ve entered in the column cells above the current cell. In the list that appears, click the entry to use. In the latter situation, you can make data entry easier by selecting from a list of entries you’ve used previously.Īs you are entering data, if you know that you typed the same entry earlier in the same column, press Alt-Down Arrow or right-click the cell and choose Pick From Drop-down List. Other pieces of data will require repetitive typing down a column in a single worksheet and then never appear again. Enter Repetitive Data From a Drop-Down ListĮxcel tracks the entries you make in a column, so you can access them to save typing.Some of the data you work with in Excel will need repeating time and time again. Click OK, and Excel will enter the number sequence for you. Then, click in the ‘Stop value’ box and type the last number in the series for example, to enter all the numbers up to 100, you would type 100. Click in the ‘Step value’ box, and type 1 (the difference between each two successive numbers). From the Type options click Linear, as this series is a linear one in which each number value counts for one more than the last. In the dialog box, choose either Rows or Columns, depending on whether the values should run down the column or across the row. Click in this cell, click the Home tab on the Ribbon toolbar, and click Fill, Series. To enter the series 1, 2, 3, and so on as we did earlier, type 1 into a cell. To do this, start by typing the first value into a cell. The Series dialog box lets you create your own custom series to your specifications. If you want to be more accurate, however, you can create your fill series using the Series dialog box instead. That is because you choose your fill preference only after you stop dragging, and Excel can’t know what series you plan to create. So far, in the tips where I indicate that you should use the right mouse button to drag the fill handle, you have to guess when to stop dragging. You will see the cells fill with the appropriate Monday-through-Friday dates. When you let go of the mouse button, in the shortcut menu that appears, click Fill Weekdays. You will have to guess about where to stop the tooltip won’t show the correct value because you haven’t yet chosen a fill option. Then click in that cell and drag the fill handle with the right mouse button down the column or across the row. Use the Fill Weekdays feature to fill a range with dates minus the weekends.To do that, type the first day of the week, such as, into a cell. In some situations you will need to fill a range with dates that represent the days Monday through Friday, skipping the weekends. Enter Days of the Week (and Skip Weekends) ![]() In that menu, click Fill Series, and the consecutive-number sequence will appear in the selected cells. When you let go of the right mouse button, a menu appears. When you do that, the tooltip will show the number 1 regardless of how far you drag, so you need to guess where to stop. To create a series of consecutive numbers, type 1 into a cell, but drag its fill handle using the right mouse button this time. If you type 1 into a cell and drag its fill handle, Excel will fill all the cells with the number 1, not the series 1, 2, 3, 4, and so on as you might expect it to. ![]() When you need to fill a range of cells with a series of consecutive numbers, you will find that Excel behaves unexpectedly. When entering consecutive numbers, you need to drag the fill handle with the right mouse button. ![]()
0 Comments
Leave a Reply. |