As just mentioned, never try to put data into one cell which should be split into two cells.
You aren't saving space; you are just potentially causing issues down the line with any data analysis.
For example, iif you have to enter full names into a spreadsheet, put the first name and last name in two cells, not one. It's easier to join them together than split them apart at a later stage, (easier but not impossible).
When typing data into a cell get into the habit of pressing 'Enter' rather than just moving to the next cell. In most cases this isn't a problem. However if you're typing a formula you could risk amending that formula by moving to another cell without properly exiting the cell.
Press 'Escape' on the keyboard to cancel editing a cell or entering data into it.
If you've started to accidentally overtype the contents of a cell, simply press 'Escape' to come out of the cell and leave the original contents.
Autofill
Knowing about Excel's autofill functionality you can really speed up data entry.
Say you had a list of numbers to generate. You can enter the first 3 number.
Select those 3 numbers and hover your mouse over the bottom right-hand corner.
The cursor will change to look like this:
Click and drag the mouse down to the number that you nedd. In this case we want a list of 10.
Release the mouse and Excel will autofill the numbers.
You can also do this with dates. Enter the first date in a cell - can you then use autofill to copy down and create a list of dates.
You only need to do the first date in this case and Excel will recognise that you are trying to do a list of dates.
If you want to list the months of the year, enter Jan and Feb, so Excel understands that you want the list to be the first of every month.
Then drag the bottom right-hand corner down to December.
With autofill you are asking Excel to logically fill in the remaining cells, with Ctrl+D you are asking Excel to copy the top data into the below cells.
0 개의 댓글:
댓글 쓰기