Excel 2016 Introduction

Excel 2016

Lesson – Using Basic Workbook Skills

Text is always entered into the Active Cell . Therefore, you should be sure that the appropriate cell is active before you start typing. If you press the [Enter] key when you finish typing an entry, the next cell down is automatically selected as the Active Cell .

Entering text into a worksheet

NOTE When you are entering or editing cell data, the worksheet is in Enter or Edit mode, respectively. Pressing the [Enter] key (to retain your changes to the cell) or the [Esc] key (to revert to the previous cell entry) returns the worksheet to Ready mode. The current mode appears in the status bar on the left at the bottom of the application window. You can also click the checkmark in the Formula Bar instead of pressing [Enter] (to retain changes) or the X instead of pressing [Esc] (to revert to the previous cell entry) to return to Ready mode. Clicking the checkmark or the X , however, does not activate the next cell down. If you don’t want Excel to select the next cell down when you press [Enter] , hold [Ctrl] while you press Enter .

Excel must be in Ready mode in order for you to perform any action other than entering or editing the contents of the active cell.

OFFICEPRO, Inc.

Page 45