We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

How do I cull rows in Excel?

wordswithfriends
on
Medium Priority
763 Views
Last Modified: 2012-05-11
At the moment I have 20 rows of data.  However when I use the vertical scroller it goes down to 1000 rows most of them blank.  When I try to delete entire rows this does not seem to reduce the number. How do I get the scroller to show a reduced number of rows?  When I copy the entire worksheet, at the moment too much blank data is included
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2008

Commented:
To reduce the used range to the actual used cells, select the first empty row below the worksheet's data, press CTRL+SHIFT+DOWN ARROW, and choose the menu command Edit->Delete. Next select the first empty column to the right of the worksheet's data, press CTRL+SHIFT+RIGHT ARROW, and choose the menu command Edit->Delete. Save the workbook to reset the scroll bars.

Kevin

Author

Commented:
Is this the same as right clicking and choosing delete?  I'm using excel 2007 and I cannot find Edit -> Delete
CERTIFIED EXPERT
Top Expert 2008

Commented:
Yes.

Kevin

Commented:
In 2007, to delete cell or rows
You need to select the Home> Cells > Delete > Delete Row

 
Also you can select Home > Editing  > Clear (rubber type icon)
A few options available there to clear the cell or row etc
choose the appropriated one.

To veryify that you have cleared the empty rows / columns, use this macro :


Sub select_everything()

    ActiveSheet.UsedRange.Select

End Sub

Open in new window

Author

Commented:
The contents get deleted but the actual rows remain

Commented:
Highlight the entire row from the left most side in the excel sheet.
Once the entire row is highlighted
Then do
 Home> Cells > Delete > Delete Row
Row will be deleted.

If you want to delete more row. Highlight them first before deleting the row.

Author

Commented:
I'm using excel 2007 I can't find "Cells" on home tab
The home tab on the ribbon contains a lot of options, which are bundled into groups.
the cells group should be the second group from the right, between 'style' & 'editing'
inside of the cells group you will find the delete option in which you select delete row
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.