<< Chapter < Page | Chapter >> Page > |
The data that we input into a spreadsheet can be numbers, text, dates, or times and we have several options for entering data in Excel.
This feature creates a series that produces the same results as dragging the fill handle in "Fill Series" procedure and is useful when we want to enter months, days and dates in general.
Initial selection | Extended series (example) |
---|---|
1, 2, 3 | 4, 5, 6,... |
1:00 | 2:00, 3:00, 4:00,... |
Monday | Tuesday, Wednesday, Thursday,... |
Jan | Feb, Mar, Apr,... |
When we enter data in a column, typing the first few letters in a cell will suggest the existing value. Using this technique will eliminate typing errors.
When we enter data in a column, right-clicking the first blank cell will trigger a shortcut menu list. Selecting "Pick from List" option lists existing values and we can choose one of the values. By using this technique we can eliminate typing errors.
Notification Switch
Would you like to follow the 'Engineering computation with spreadsheets' conversation and receive update notifications?