Repeat All Items Labels by using Ctrl + Enter
Example Walkthrough:
For Employee Code:
- Select the range in column A (from A2 to A6).
- Use Go To Special, choose Blanks, and click OK.
- Type 36122044 and press Ctrl + Enter to fill the blank cells.
For Employee Name:
- Select the range in column B (from B2 to B6).
- Use Go To Special, choose Blanks, and click OK.
- Type Employee-31 and press Ctrl + Enter.
Sample Picture:
This method is very efficient for filling large datasets with missing values.
Comments
Post a Comment