Skip to main content

How to Delete Blank Rows in Microsoft Excel quickly

The technique of deleting blank rows in Microsoft Excel sheet in the quickest way is easy though you must watch out for unintended consequences.

Blank rows are useless in most of the Microsoft Excel Sheets. Though blank rows are not that bad for most of the sheets, they are unnecessary and undesirable, so it is better to get rid of them all. Excel access blank rows as data ranges, and if blank rows exist in the wrong place, then it could inhibit many built-in features.


The good news is that the quick and easy way to delete blank rows from a data range in Microsoft Excel sheet is available. With the following easy technique, you can remove empty rows, but you must be careful too because it has the potential to destroy data. Once you select the data range, follow the below steps:


  1. Use keyboard and Press “F5.”
  2. Now go to Dialog Box, and then tap on “Special.”
  3. Tap on Blanks option and then click on “OK.”Now you must select the blank cells like A7: E7 and A10: E10.
  4. Now go to the “Home” tab and then click on the “Delete dropdown” available in Cells groups.
  5. Now choose “delete cells”. A dialogue box will appear on the screen with the Delete Cells Up option selected. 
  6. Now tap OK or to use the shortcut key, press (Ctrl)+ (-). Once you click OK button, then the selected range will automatically be deleted.


When you choose “Delete Cells”, it will delete the blank cells only that you chosen previously. In step 4 if you will select “Delete Sheet Rows”, it can destroy your all data to the right that you may not able to detect at that moment. Be careful while using the delete option because it is easy to choose the wrong option of Delete cells replacing with Delete Sheet Rows.


Author bio :-


Denver Miller is a self-professed security expert, He Has been expertise in making people aware of the security threats. He just love to write about, cryptography, malware,Cyber security social engineering, internet. He writes for Norton Products at


Popular posts from this blog

   5 Tips for Guiding Your Child Through an Escape Room   The most distinguishable characteristics of children are how immensely full of energy and curiosity they are! Compared to adults, they are far more willing to start thinking out of the box and be creative. These factors seemingly make them one of the best players to enjoy an escape room experience.    Taking your child to one of the escape rooms in Prescott this weekend can be a memorable experience for them. Visiting the escapades also undeniably offers you one of the best ways to spend quality time with your family. Furthermore, it also allows your child to test their creativity and problem-solving skills and even enhance their motor skills.    Now, while you take your kid to an escape room game anytime soon, here are 5 essential tips that you need to keep in your mind: 1.    Do your homework! It is always better to prepare yourself before entering the escape room game. So, instead of randomly choosing and

What Is Digital Marketing?

 What Is Digital Marketing? Digital marketing is that the use of the social media, Internet, search engines, mobile devices, and other channels to succeed in consumers. Some consider digital marketing to be entirely new which needs a replacement way of understanding that how customers behave and new ways of approaching the purchasers compared to the normal marketing. Digital Marketing Channels 1. Website Marketing 2. Pay-Per-Click (PPC) Advertising 3.Content Marketing 4.Email Marketing 5.Social Media Marketing 6.Affiliate Marketing 7.Video Marketing 8.SMS Messaging Digital Marketing As A course and Career The Digital Marketing course will transform you into a complete digital marketer with expertise in the top eight digital marketing domains — search engine optimization, social media, pay-per-click, conversion optimization, digital analytics, content, mobile, and email marketing. Fast-track your career in digital marketing today with practical training you can appl

What is the ideal profile for a digital marketing consultant? Find out here

Running a business is not a simple task, and it is usually not a task for just one person. In general, a good entrepreneur needs to have notions and financial management, people management, marketing, and sales management, among other basic knowledge. For this reason, as the company develops, it becomes essential to hire specialist professionals in each specific area. However, even these managers do not always master all the technologies and knowledge of their areas of expertise, as is the case with digital marketing, and this is where consultants enter. According to the best digital marketing company in Udaipur, a company seeks the assistance of a digital marketing consultancy in the following situations: 1. Carrying out a diagnosis of the current situation of a certain sector or project of the company. 2. Lack of time for company employees to develop a specific project. 3. To solve a specific problem that requires the knowledge of a specialist in the area to minimize the possibility