Remove Blank Cells in Excel | Excel Problem Solution

  • Thread starter Thread starter pixel01
  • Start date Start date
  • Tags Tags
    Excel
Click For Summary

Discussion Overview

The discussion revolves around a problem related to removing blank cells in an Excel column. Participants explore various methods to achieve this, focusing on practical solutions and user experiences.

Discussion Character

  • Technical explanation
  • Homework-related

Main Points Raised

  • One participant describes a method of selecting cells and using the "delete" function to remove blank cells, suggesting that users can choose how to shift remaining cells.
  • Another participant reiterates the same method but acknowledges the difficulty of selecting blank cells when they are numerous and randomly distributed.
  • A different approach is proposed, where users can utilize the 'Go To' feature to select 'Blank Cells' specifically, followed by deletion and shifting of remaining cells.

Areas of Agreement / Disagreement

Participants generally agree on the methods to remove blank cells, but there is no consensus on the best approach, as different methods are suggested and discussed.

Contextual Notes

Some participants mention the challenge of selecting blank cells when they are scattered throughout a large dataset, indicating a potential limitation in the proposed methods.

Who May Find This Useful

This discussion may be useful for Excel users facing challenges with managing blank cells in their spreadsheets, particularly those looking for efficient methods to streamline their data.

pixel01
Messages
688
Reaction score
1
Hi all,

I have this excel problem: In a column, there are entries (can be characters or number), but there are also some blank cells. How could I remove all the blank cells so that the column is shorter.
Here I attached an illustration

Thanks for any comments
 

Attachments

  • excel 1.JPG
    excel 1.JPG
    10.6 KB · Views: 468
Technology news on Phys.org
Simple, select the cells to be removed. Use shift or control for multiple selections; go drop menu point "edit" and find function "delete". You will be prompted what to do with the remaining cells, to move up or left, etc.

Success
 
Andre said:
Simple, select the cells to be removed. Use shift or control for multiple selections; go drop menu point "edit" and find function "delete". You will be prompted what to do with the remaining cells, to move up or left, etc.

Success

Thanks Andre.
The thing is that in case there are hundreds of cells, to select blank cells is not simple.
Blank cells appear randomly.
 
To select just the blank cells, you can go to 'Edit', then 'Go To', click 'Special', and then select 'Blank Cells'. After that, delete them just like Andre said. You'll want to shift the remaining cells up, since you're removing blank cells in columns. Hope that helps.

Josh
 
Thank you Josh, it seems I have solved the problem.
Once again thanks Andre and Happy New Year to all of you
 

Similar threads

Should Excel macros self-adjust when you delete lines above the affected cells?
  • · Replies 27 ·
Replies
27
Views
4K
How to concatenate columns in Excel
  • · Replies 2 ·
Replies
2
Views
1K
My Website For Creating Interactive Visuals Linked To Equations
  • · Replies 4 ·
Replies
4
Views
4K
MCNP always saying my codes missed a cell
  • · Replies 4 ·
Replies
4
Views
1K
How to disable access to old data with newest version of software?
  • · Replies 8 ·
Replies
8
Views
1K
Excel Macros & VBA | Learn Programming Basics
  • · Replies 18 ·
Replies
18
Views
6K
Fortran {FORTRAN}How can i read blank steps without using iostat
  • · Replies 6 ·
Replies
6
Views
2K
A little help in programming docx to Excel
  • · Replies 6 ·
Replies
6
Views
2K
Extracting data from a spectrometer to Excel
  • · Replies 7 ·
Replies
7
Views
7K
How to have "Excel for Mac 2016" Auto-convert entry of yymmdd to yyyy-mm-dd
  • · Replies 9 ·
Replies
9
Views
2K