➔To prevent yourself or other users of a worksheet from entering invalid data, including blank cells, create
data validation rules; see “Restricting and Validating Data Entry for a Cell or Range,” p. 662.
■To make it easier to enter data, freeze the worksheet panes just below the header row.
➔For instructions on how to freeze worksheet panes, see “Locking Row and Column Labels for Onscreen
Viewing,” p. 659.
To resize a list, click anywhere within the list and choose Data, List, Resize List. Drag the
selection to add or remove rows or columns. Your selection must start with the existing
header row and ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.