Is there a way to delete multiple lines at the same time beside u.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please let me know if there is other ways to delete multiple lines at the
same time without using the Ctl key. Thank you.
 
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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to search for multiple items at the same time? 1
How do I look at two worksheets in one Excel workbook at same time 2
How to create multiple bar charts at the same time? 0
Formating the same cells in multiple worksheet at the same time? 3
How do I delete multiple cell styles? 5
Conditional Formatting 3
How to Migrate IMAP Email to Office 365 Easily 1
Excel spreadsheet is corrupted with multiple text boxes? 1

Back
Top