decimate rows in Excel 2007

A

Alistair

I have a large spreadsheet, about 23000 rows. I want to reduce this to about
700 rows by decimating the sheet and keeping, say, every 40th row. How can I
do this?
Look forward to hearing from you.
 
B

Bruce Sinclair

I have a large spreadsheet, about 23000 rows. I want to reduce this to about
700 rows by decimating the sheet and keeping, say, every 40th row. How can I
do this?
Look forward to hearing from you.
Click to expand...

As an aside, 'decimate' means to lose 1 out of 10. :)
 

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

Easiest Way to Delete Rows 4
How to filter rows data based on background color of individual cells 1
Deleting/removing unused rows in a worksheet 3
Gridlines won't show up in excel 2007 6
I cannot delete the extra rows or columns in Excel 2007 2
How do I sort blocks of information in Excel? 1
pivot tables 1
How do I, not print hidden rows (Excel) 2

Top