answersLogoWhite

0


Best Answer

Worksheets are a fixed size, so you cannot delete rows completely, only their contents or formatting. When you delete a row and it moves a row up, it will add one at the very bottom, so there are always the same amount in it. The spreadsheet will only print the area that is used. Using the Print Area option on the File Menu, you can specify the area you want to print to limit it even further.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you Delete empty rows at end of worksheet?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Does Excel automatically renumber cells when a cell is deleted?

Sort of... but, you don't actually delete a cell. You can delete either a row or column, but not a single cell. When you delete either a row or column, the remaining rows and columns (as appropriate for your actions) automatically renumber to reflect the missing row or column. If you delete row 6, then row 7 automatically becomes row 6, and so on to the end of the rows. If you delete the contents of a cell, the cell becomes blank, but no other cells are renumbered.


Can you enter formulas at the bottom of columns and at the end of rows?

A formula can be in the last cell of a row or column, but not actually outside of the worksheet itself. Formulas must be in actual cells.


How do you delete empty paragraphs in Microsoft word using find and replace?

The special symbol for the paragraph-end-marker is ^p. Find for ^p^p, and replace it by ^p.


When did Empty Stares end?

Empty Stares ended in 1997.


a farmer has 10 trees and needs to PLANT them in 4 even rows so how does he do that?

4 Even rows, you'd end up with 2 rows of 3, and another 2 of 2.


Where can you find the horizontal split bar on Microsoft Word screen?

It allows you to split the window into two separate panes, aligned horizontally. This allows you to see two different areas of the worksheet at the same time. It can be accessed from the menus or dragged on and off the worksheet from the end of the scrollbar.


How do you end a document in Microsoft Excel so no more rows are visible and only gray space is visible?

Click on Page Break View in the View section. This will display only what you plan to print and leave the rest of the worksheet background gray. You can drag the borders to any print range you like.


How often is a worksheet usually prepared?

At the end of the fiscal year


How do you lock a Microsoft Excel workbook to always open on the same worksheet and cell instead of on whichever worksheet or cell you were on when you last saved the file?

Private Sub Workbook_Open() Worksheets(1).Activate End Sub In VB worksheet


When did Empty Nest end?

Empty Nest ended on 1995-04-29.


When did Empty - TV series - end?

Empty - TV series - ended on 2008-04-03.


Does The word wrap feature eliminate the need to press the Enter key at the end of a paragraph?

You need to press the Enter key at the end of a paragraph to separate the paragraph from the next paragraph. One or more empty rows are generally placed between the two paragraphs. So, Word wrap will continue until the Enter key is pressed.