• Contact
  • Homelab
Dimitris Tonias
  • Management
  • Monitoring
  • Cloud
  • Virtualization
  • Networking
  • Productivity
No Result
View All Result
  • Management
  • Monitoring
  • Cloud
  • Virtualization
  • Networking
  • Productivity
No Result
View All Result
Dimitris Tonias
No Result
View All Result

Delete multiple blank rows and columns in Excel

Dimitris Tonias by Dimitris Tonias
August 29, 2017 - Updated on April 21, 2024
in Productivity
Reading Time: 2 mins read
A A
0
Share on FacebookShare on Twitter

A common occurrence with copying – pasting data to Excel is adding blank lines or columns between your data. When it comes to just a few lines/columns, the deletion process can be done easily by just hitting the Delete option when you right-click on a selected row or column.

Delete multiple blank rows and columns in Excel

But what can you do when it comes to dozens, hundreds, etc., lines or columns? How do you delete all blanks by keeping only the essential information in Excel?

There is a solution and it can be applied in bulk without having to delete items one by one. Let’s see how you can do it by following the next steps.

Delete multiple blank rows and columns in Excel

In the figure below, it appears that there are empty lines between our data and we want to delete them to keep only the lines containing records.

Delete multiple blank rows and columns in Excel

From the Home tab, locate the Find & Select menu, and then click Go To Special.

Delete multiple blank rows and columns in Excel

In the window that appears, select Blanks, and then click OK.

Delete multiple blank rows and columns in Excel

As you will see, all lines that are empty are now selected.

Delete multiple blank rows and columns in Excel

Without clicking anywhere else, find the Delete menu on the Home tab, and then click Delete Sheet Rows or Delete Sheet Columns, depending on what you want to delete in bulk.

Delete multiple blank rows and columns in Excel

That’s it! Within a minute you’ve managed to delete all blank lines or columns of an Excel spreadsheet without much effort.

Delete multiple blank rows and columns in Excel

Tags: ExcelMicrosoft Office
ShareTweetPin
Previous Post

Show battery percentage in Windows 10 taskbar

Next Post

Install VMware Workstation on Windows

Related Posts

Check word count on Google Docs
Productivity

Check word count on Google Docs

Visio 2016, can't open files and stencils from older versions
Productivity

Visio 2016, can’t open files and stencils from older versions

Xiaomi Temperature Humidity Sensor Review
Productivity

Xiaomi Temperature Humidity Sensor Review

Speed up a slow opening Downloads folder
Productivity

Speed up a slow opening Downloads folder

Change network connection priority on Windows 10
Productivity

Change network connection priority on Windows 10

Show or hide app list in Windows 10 Start menu
Productivity

Show or hide app list in Windows 10 Start menu

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

No Result
View All Result
Zabbix server: More than 75% used in the trends cache
Monitoring

Zabbix server: More than 75% used in the trends cache

In Zabbix, "trends" are a type of data storage representing aggregated historical data. Zabbix monitors and collects a vast amount...

Read moreDetails
Check word count on Google Docs

Check word count on Google Docs

Zabbix server: More than 75% used in the configuration cache

Zabbix server: More than 75% used in the configuration cache

Approve updates in WSUS 2016

Approve updates in WSUS 2016

Configure Group Policy to deploy updates using WSUS 2016

Configure Group Policy to deploy updates using WSUS 2016

Configure computer groups in WSUS 2016

Configure computer groups in WSUS 2016

The initial configuration of WSUS 2016

The initial configuration of WSUS 2016

Get more stuff

Subscribe to our mailing list and get interesting stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.

we respect your privacy and take protecting it seriously

  • Contact
  • Homelab

© 2024 Dimitris Tonias

No Result
View All Result
  • About
  • Contact
  • Free Tools
  • Home
  • Homelab

© 2024 Dimitris Tonias

This website uses cookies. By continuing to use this website you are giving consent to cookies being used.