1. How to enter soft break in EXCEL
ALT+ENTER
2. How to fill an Excel column with consecutive numbers without typing each one separately?
Put 1 in the first row, first column.
Put 2 in the 2nd row, first column.
Highlight both. Then drag your cursor down. They will auto-number themselves.
or
Click and drag the first value that enter into the first cell.
Then go to Edit / Fill / series .. and click on "step value" and enter 1.
ALT+ENTER
2. How to fill an Excel column with consecutive numbers without typing each one separately?
Put 1 in the first row, first column.
Put 2 in the 2nd row, first column.
Highlight both. Then drag your cursor down. They will auto-number themselves.
or
Click and drag the first value that enter into the first cell.
Then go to Edit / Fill / series .. and click on "step value" and enter 1.
No comments:
Post a Comment