Page 112 - Excel 2013 All-in-One For Dummies

94 Data Entry 101
If you have more than one cell selected (see Book II, Chapter 2 for more on this) and then press Ctrl+Enter to complete the data entry that you’re making in the active cell of this selected range, Excel simultaneously enters that data entry into all the cells in the selection. You can use this technique to enter a single label or value in many places in a worksheet at one time.
If you have more than one worksheet selected (see Book II, Chapter 4) at the time that you make an entry in the current cell, Excel makes that entry in the corresponding cells of all the selected worksheets. For example, if you enter the heading Cost Analysis in cell C3 of Sheet1 when Sheet1 through Sheet3 are selected, Excel enters Cost Analysis in cell C3 of Sheet2 and Sheet3 as well.
Doing data entry with the Touch keyboard
If you’re running Excel 2013 on a touchscreen device that lacks any kind
of physical keyboard, you need to open the Touch keyboard and use it to input your spreadsheet data. To open the Touch keyboard, simply tap the Touch Keyboard button that appears on the right side of the Windows 7 or 8 taskbar. Doing this displays the Touch keyboard floating undocked at the bottom of the Excel program window.
To dock the Touch keyboard beneath the Excel 2013 program window, click the Dock button that appears to the immediate left of the Close button in the upper-right corner of the keyboard. Figure 1-6 shows you how your touch- screen looks after docking the Windows 8 Touch keyboard.
Figure 1-6:
A Windows 8 touch- screen after displaying and docking the Touch keyboard beneath the Excel 2013 program window.