Microsoft Office Tutorials and References
In Depth Information
Taking the Drudgery out of Data Entry
A tale of two edits: Cell versus Formula bar editing
Excel gives you a choice between editing
a cell’s contents either in the cell or on the
Formula bar. Whereas most of the time, editing
right in the cell is just fine, when dealing with
really long entries (like humongous formulas
that go on forever or text entries that take up
paragraphs), you may prefer to do your editing
on the Formula bar. This is because Excel 2013
automatically adds up and down scroll arrow
buttons to the end of the Formula bar when a
cell entry is too long to display completely on a
single row. These scroll arrow buttons enable
you to display each line of the cell’s long entry
without expanding the Formula bar (as in earlier
versions of Excel) and thereby obscuring the
top part of the Worksheet area.
To edit the contents in the Formula bar rather
than in the cell itself, use the appropriate scroll
arrow button to display the line with the
contents that needs editing and then position the
I-beam mouse pointer at the place in the text or
number(s) that requires modification to set the
insertion cursor.
Taking the Drudgery out of Data Entry
Before leaving the topic of data entry, I feel duty-bound to cover some of the
shortcuts that really help to cut down on the drudgery of this task. These
data-entry tips include the AutoComplete, AutoFill, and Flash Fill features as
well as doing data entry in a preselected block of cells and making the same
entry in a bunch of cells all at the same time.
I’m just not complete without you
The AutoComplete feature in Excel 2013 is not something you can do
anything about, just something to be aware of while you enter your data. In an
attempt to cut down on your typing load, our friendly software engineers at
Microsoft came up with the AutoComplete feature.
AutoComplete is like a moronic mind reader who anticipates what you might
want to enter next based on what you just entered. This feature comes into
play only when you’re entering a column of text entries. (It does not come
into play when entering values or formulas or when entering a row of text
entries.) When entering a column of text entries, AutoComplete looks at the
kinds of entries that you make in that column and automatically duplicates
them in subsequent rows whenever you start a new entry that begins with
the same letter as an existing entry.
Search JabSto ::

Custom Search