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

Popular posts from this blog

How to Use the FILTER Formula

Skill Matrix Tool & Excel Format

Using Flash Fill in Excel