Share via

Fill empty cells with the previous value

jm saf 166 Reputation points
2020-07-30T09:22:19.83+00:00

Hi group!
In the attached example I would need to know if there is any way to fill the empty cells of the cod office field with the value of the last cell with value so that the result would be.

14529-imagen.png

14530-imagen.png

I need this because I have to do it for the whole year and for all the staff. I'm doing it by hand but it would be very useful to do it automatically.

Thank's in advance

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,742 questions
Accepted answer
  1. Emily Hua-MSFT 27,676 Reputation points
    2020-07-31T05:09:22.773+00:00

    Hi jm saf,

    I made gif below and I would give a explain.

    14726-8.gif

    1. Select range with non-empty cells and empty cells . In gif, I select cells from A2 to A27.
    2. Press Ctrl and G, open Go To > choose "Special" > Blanks > OK.
    3. Enter the name of the previous cell in the first blank cell. In gif, the first empty cell is A5, so I enter "=A4" in it.
    4. Press Ctrl and Enter.
    6 people found this answer helpful.

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. jm saf 166 Reputation points
    2020-07-31T06:47:13.443+00:00

    Hi Emilyhua!

    Your proposal solves my problem.

    Thank you for your help and your time

    Regards

  2. Nobuko Ichimaru 316 Reputation points
    2020-10-09T15:18:18.007+00:00

    Hi! @jm saf
    one of ways,
    When you enter the data in Sheet1,
    The value is automatically displayed on the filled sheet
    After completing the input of Sheet1,
    Copy column C of filled Sheet,
    Paste the value in column C of Shhet1

    https://1drv.ms/x/s!At950JyIeN6wgehxzAx-jytM8K7hQw?e=LA4cIM
    hope its helpful

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.