Remove Blank Cells in Excel | Excel Problem Solution

  • Thread starter Thread starter pixel01
  • Start date Start date
  • Tags Tags
    Excel
AI Thread Summary
To remove blank cells from a column in Excel, users can utilize the 'Go To' feature for efficiency. Instead of manually selecting each blank cell, navigate to 'Edit', then 'Go To', and select 'Special' to highlight all blank cells. After selecting, users can delete the blank cells and choose to shift the remaining cells up to maintain the column's continuity. This method is particularly useful when dealing with large datasets where blank cells are randomly distributed. The discussion concludes with gratitude for the assistance provided.
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: 449
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
 

Thread 'Learning Assembly and computer architecture for x86'

Dear Peeps I have posted a few questions about programing on this sectio of the PF forum. I want to ask you veterans how you folks learn program in assembly and about computer architecture for the x86 family. In addition to finish learning C, I am also reading the book From bits to Gates to C and Beyond. In the book, it uses the mini LC3 assembly language. I also have books on assembly programming and computer architecture. The few famous ones i have are Computer Organization and...
View full post »

Thread 'Learning data structures and algorithms in different programming languages'

I have a quick questions. I am going through a book on C programming on my own. Afterwards, I plan to go through something call data structures and algorithms on my own also in C. I also need to learn C++, Matlab and for personal interest Haskell. For the two topic of data structures and algorithms, I understand there are standard ones across all programming languages. After learning it through C, what would be the biggest issue when trying to implement the same data...
View full post »

Similar threads

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

Hot Threads

Recent Insights

Back
Top