answersLogoWhite

0

Unfortunately, there is no single command to delete empty rows. Your only option is to deleted them manually. HOWEVER - you can delete more than one row at once - even if they're not adjacent. Simply hold down the CTRL key, and left-click each empty row in turn - there will be a highlighted box in each row as you progress. Once you get to last one, right-click, select Delete and choose Entire row. Click OK and you're done. This will remove every row you highlighted.

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

How do you delete text documents on open office for Ubuntu?

You don't delete them from OpenOffice; you delete them by right-clicking them in Nautilus (the folder explorer) and selecting delete.


How does one delete files in Windows 8?

There are many ways to delete files on Windows 8. This includes selecting the file and using the delete key, as well as right clicking the object and selecting delete.


How do I delete an item from the Office Clipboard How do I delete all the items from the Office Clipboard?

1. How do I delete an item from the Office Clipboard? How do I delete all the items from the Office Clipboard?


How do you delete on excel?

It depends on what you want to delete. Deleting what is in cells can be done by selecting them and pressing the Delete key. You can also delete charts by selecting them and pressing the Delete key. To delete full rows and columns, you can select them and use the menu/ribbon options to remove them completely.


Can you delete my facebook profile?

YOU can delete your own profile, by selecting "Account Settings", "Delete Account" and confirming it.


How do i delete address from s gps?

You can delete address from a gps by press the Menu button and then select Go To followed by selecting Address Book and then select the address you want to remove and finally select Delete. Confirm the removal by selecting Yes.


How do you delete a toolbar?

You cannot delete a toolbar but you can hide it by right clicking on the Menu Bar a selecting that toolbar in the menu that pops up.


List 2 things you should NOT do when deleting data in Excel?

You should not delete data that is crucial to the working of the spreadsheet. You should not delete data that will interfere with how formulas work.


How do you delete an individual item from the office clipboard in word 10?

click the arrow next to the item, then choose the item you want to delete


How can you delete your gazelle account?

You can delete your Gazelle account by logging into your account and selecting the remove account option. It will provide a confirmation prompt before deleting.


How do you delete myspace without password?

password delete


How can you reduce the number of cells in an Excel spreadsheet?

While the size of the entire worksheet will always remain the same, you can delete cells completely or just their content. Select the cells you want to delete. To delete their content only, just press the Delete key. To delete the cells completely, right click, select Delete... and choose the appropriate option, to either delete cells and move cells up or left, or to delete and entire row or column.