|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 22nd, 2004, 11:54 PM
|
|||
|
|||
I dont want to copy hidden rows
Hi All,
I have a spreadsheet that depending on what is entered in to cell A1 it hides certain rows from row 20 through to row 300, what I want to now do is copy what rows are left unhidden and paste them onto another sheet.. How would I do this cos every time I have tried it I paste all 300 rows? Many Thanks Mark 
|
|
#2
June 23rd, 2004, 12:06 AM
|
|||
|
|||
|
I dont want to copy hidden rows
Once you have selected all 300 rows , including the hidden
ones, go to EDIT GOTO SPECIAL VISIBLE CELLS ONLY OK This will unselect hidden rows, then copy and paste... Regards JS -----Original Message----- Hi All, I have a spreadsheet that depending on what is entered in to cell A1 it hides certain rows from row 20 through to row 300, what I want to now do is copy what rows are left unhidden and paste them onto another sheet.. How would I do this cos every time I have tried it I paste all 300 rows? Many Thanks Mark .
|
|
#3
June 23rd, 2004, 12:29 AM
|
|||
|
|||
|
I dont want to copy hidden rows
simple when you know how!!
Many Thanks Mark "Juan Sanchez" wrote in message ... Once you have selected all 300 rows , including the hidden ones, go to EDIT GOTO SPECIAL VISIBLE CELLS ONLY OK This will unselect hidden rows, then copy and paste... Regards JS -----Original Message----- Hi All, I have a spreadsheet that depending on what is entered in to cell A1 it hides certain rows from row 20 through to row 300, what I want to now do is copy what rows are left unhidden and paste them onto another sheet.. How would I do this cos every time I have tried it I paste all 300 rows? Many Thanks Mark .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
