#1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 162
Default Deleting Rows

Is there a way to delete rows quickly in a spreadsheet which have data that I
don't need? For example, rows 1 - 10 & 35-45 I don't need. However, I do
need 11-34 and 46-50. How can I just get the rows I need by doing the least
amount of manual work?
Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 10,593
Default Deleting Rows

Select all of those rows and then EditDelete selecting the entire row
option.

You can select multiple ranges by selecting one range, then click-select a
second etc.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Daren" wrote in message
...
Is there a way to delete rows quickly in a spreadsheet which have data
that I
don't need? For example, rows 1 - 10 & 35-45 I don't need. However, I do
need 11-34 and 46-50. How can I just get the rows I need by doing the
least
amount of manual work?
Thanks.



  #3   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 162
Default Deleting Rows

Bob, thanks. Is there a way to row automate row deletion in Excel so I don't
have to manually select those rows?

"Bob Phillips" wrote:

Select all of those rows and then EditDelete selecting the entire row
option.

You can select multiple ranges by selecting one range, then click-select a
second etc.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Daren" wrote in message
...
Is there a way to delete rows quickly in a spreadsheet which have data
that I
don't need? For example, rows 1 - 10 & 35-45 I don't need. However, I do
need 11-34 and 46-50. How can I just get the rows I need by doing the
least
amount of manual work?
Thanks.




  #4   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 10,593
Default Deleting Rows

How would it know which rows you want to delete?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Daren" wrote in message
...
Bob, thanks. Is there a way to row automate row deletion in Excel so I
don't
have to manually select those rows?

"Bob Phillips" wrote:

Select all of those rows and then EditDelete selecting the entire row
option.

You can select multiple ranges by selecting one range, then click-select
a
second etc.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Daren" wrote in message
...
Is there a way to delete rows quickly in a spreadsheet which have data
that I
don't need? For example, rows 1 - 10 & 35-45 I don't need. However, I
do
need 11-34 and 46-50. How can I just get the rows I need by doing the
least
amount of manual work?
Thanks.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
deleting rows H. Excel Discussion (Misc queries) 9 May 4th 06 03:22 PM
Help!! I have problem deleting 2500 rows of filtered rows!!!! shirley_kee Excel Discussion (Misc queries) 1 January 12th 06 03:24 AM
rows that need deleting LtFass Excel Worksheet Functions 4 November 7th 05 05:06 PM
deleting hidden rows so i can print only the rows showing?????? jenn Excel Worksheet Functions 0 October 6th 05 04:05 PM
Need help deleting Rows Roberto Excel Discussion (Misc queries) 3 December 9th 04 12:09 AM


All times are GMT +1. The time now is 01:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"