Excel 2016 Introduction

Lesson – Using Basic Workbook Skills

Excel 2016

Use Pick From drop-down list

NOTE The AutoComplete and Pick From Drop-down List features only work in columns containing text entries. If there is a blank row between entries in a column, the AutoComplete and Pick From Drop-down List features for that column must be rebuilt for cells below the blank row by typing the entries again. Or, enter a space in the empty cells to continue the list in a column. If you are making an entry that is different from the AutoComplete option that is appearing, simply continue typing your new entry, e.g. New Hampshire and New York. From that point forward, AutoComplete will only appear when you reach the unique portion of an entry, e.g. New H or New Y. If your new entry is shorter than the AutoComplete suggestion, press the Delete key on the keyboard to complete your new entry, e.g., Old when Olde is suggested. You can disable the AutoComplete feature by deselecting the Enable AutoComplete for cell values option in the Editing options section of the Advanced page in the Excel Options dialog box.

Page 64

OFFICEPRO, Inc.