How to delete empty columns

**Smasen91** · 05-02-2016, 07:20 PM

Hi guys!
Does anyone know how to delete the empty columns between the four different rows in the excel sheet?
See excel sheet where you have an example of how it should look like. I want all the numbers in (b70,B30,b20,s80) to stay next to each other without spaces between.

Thank you very much! :D

**shg** · 05-02-2016, 07:37 PM

Select the area, do Ctrl+G (Find), leave Find What: empty, and press Find All.

Select all of the rows in the Find list, Delete > Delete Cells, tick Shift cells up

	C	D	E	F
3	b70	s70	b20	s80
4	0.089915	-0.1526	-0.05657	-0.10935
5	-0.02474	0.018406	0.162562	-0.14284
6	0.052706	-0.05223	0.09116	0.06289
7	-0.03377	0.034475	0.14149	-0.16938
8	-0.02707	0.016557	0.173996	0.035122
9	-0.01526	0.01194	-0.11154	0.361866
10	-0.17575	0.201487	-0.12612	0.056958
11	0.09019	-0.09447	-0.34282	0.358934
12	0.057136	-0.05616	-0.36807	0.062048
13	-0.26656	0.341679	-0.21708	-0.3234
14	-0.06945	0.069374	-0.30621	0.226127
15	0.041574	-0.04517	-0.31278	0.017102
16	-0.00491	0.003601	0.003015	-0.38467

...

**Smasen91** · 05-03-2016, 02:32 AM

Hmm. SHould be easy. But does not seem to work for me. I just receive: Did not find any empty cells.
Can you or anyone else try and maybe post the excel sheet for me? :D Thanks!

**sandy666** · 05-03-2016, 03:02 AM

Read carefully what shg said. It works. Really

How to delete empty columns

LinkBack

Thread Tools

Rate This Thread

Display

How to delete empty columns

Re: How to delete empty columns

Re: How to delete empty columns

Re: How to delete empty columns

Thread Information

Users Browsing this Thread

Similar Threads

Using a Macro to Delete Empty Columns

[SOLVED] Really Delete Blank Empty Columns

Delete Empty Columns

Delete Empty Rows and empty columns from the word table

Delete row if multiple columns empty

[SOLVED] Delete rows when two columns are empty

Macro to Delete empty columns

Bookmarks

Bookmarks

Posting Permissions