Fill Blank Cells in Excel Column | How To

Before you upload contact information from an Excel spreadsheet, you will need to make sure that any blank cells contain the data that is required for upload into ShippingEasy. Learn what CSV fields are required. You can use Excel's built-in Go To Special feature to fill in blank cells quickly.

To fill in blank cells in Excel:

First, you need to select all the empty cells:

  1. Select columns that contain the blank cells
    select_columns_excel.png
  2. On the Ribbon's Home tab, click Find & Select and click Go To Special
    find_and_select_go_to_special_excel.PNG
  3. In the Go To Special dialog box, click Blanks, then click OK

Next, create a formula that will copy the value from the heading above each blank cell.

  1. With the blank cells selected, type an equal sign, to start the formula. On the keyboard, press the up arrow. This enters a reference to the cell above.
    arrow_up_for_formula_excel.PNG

  2. Press the Ctrl key, then tap the Enter key to enter the formula in all the selected cells.
    enter_formula_into_all_selected_cells_excel.png
  3. Select the entire columns where you filled in the blanks with formulas
    columns_a_and_b_selected_excel.png
  4. On the Ribbon's Home tab, click Copy.
    copy_icon_excel.PNG
  5. With the columns still selected, click the drop down arrow on the Paste command, then click Paste Values.
    paste_values_excel.PNG

This will turn the formulas into values in each cell to allow for sorting and filtering.

Now,  you are ready to upload your complete CSV file. Learn how to:

Was this article helpful?
0 out of 0 found this helpful

Comments

Add a Comment

Please sign in to leave a comment.