cut rows without cutting hide rows

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

Guest

Hi
I an trying to cut rows in excel but since I have hide rows in the sheet the
it cutting the hide rows as well.

Hoe can I cut only the rows I see on screen?

thank you
Michal
 
try selecting the rows you want to cut,
edit-goto-special-visible cells only
then delete rows
 
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

Excel Unable to insert cut rows into Excel online anymore? 0
Cannot remove empty rows 8
Re: Cut and "insert cut cells" in Excel 2007 doesn't work. 9
Deleting blank rows 4
Excel 2007 Data Filter - When using cut it clears all data 2
text is getting cut off when printed due to row ht. 1
Cut Non Adjacent Rows in Excel 2007 1
Macro Help 6

Back
Top