Views:

Deleting blank columns and rows in Excel

Hidden data in your club import's blank rows and columns will prevent your club import from being accepted by the Club Importer.

How to delete blank columns

To delete blank columns in Excel, use the following instructions:

  1. Click on cell X1
  2. Hold down SHIFT button and use the END button, then the RIGHT ARROW button to select all blank columns to the right of W
  3. Right hand click the highlighted section.
  4. A drop down list will appear.  Select Delete.
  5. A pop up window will appear.  Select Entire Column and then OK.

How to delete blank rows

To delete blank rows in Excel, use the following instructions:

  1. Click on the cell in column A which is immediately below the last row you have got text in.
  2. Hold down SHIFT button and use the END button, then the DOWN ARROW button to select all blank rows under your text
  3. Right hand click on the highlighted section.
  4. A drop down list will appear.  Select Delete.
  5. A pop up window will appear.  Select Entire Row and then OK.

Need more help? Contact support.