Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
cherry
 
Posts: n/a
Default Is there a way to delete multiple lines at the same time beside u.

Please let me know if there is other ways to delete multiple lines at the
same time without using the Ctl key. Thank you.
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi Cherry

are the lines adjacent to one another? if so just drag down the row numbers
and then right mouse click & choose delete .. .if they're not adjacent and
you don't want to use the Ctrl key to select them, how are you going to
identify which rows you want to delete?

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"cherry" wrote in message
...
Please let me know if there is other ways to delete multiple lines at the
same time without using the Ctl key. Thank you.



  #3   Report Post  
David McRitchie
 
Posts: n/a
Default

Hi Cherry,
You can type into the name box to left of the formula bar something like

10:10, 12:15, 18:18
which is a lot harder than using the Ctrl key.

You could use a filter to delete rows, see Debra Dalgleish's site at
contextures.com look for advanced filters.

Or you can just keep things up in the air by not explaining
why we must guess at why you can't just do the things the
obvious way.



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
Can you delete multiple worksheets with one command? pebel Excel Worksheet Functions 2 March 18th 05 01:58 AM
HOW CAN I TYPE MULTIPLE LINES IN A CELL brewster Setting up and Configuration of Excel 1 February 11th 05 11:46 AM
How do I delete filtered lines in Excel 2000? Nicola H Excel Worksheet Functions 1 February 8th 05 03:47 PM
how do I enter multiple lines in a cell in Excel asowles Excel Discussion (Misc queries) 2 February 3rd 05 07:47 PM
vlookup with multiple lines of same value lostinexcel Excel Worksheet Functions 1 December 17th 04 02:06 PM


All times are GMT +1. The time now is 12:43 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"