Help on adjusting # of rows

[backthatthangup]

I am creating a workbook for my estimating company. To link jobs
together throughout the different spreadsheets, i have clicked on the
column, copied it , and paste specialed a link to the other spreads.
The only problem with this is that it has made the size of my document
28 MB... My question is, is there any way that you can manually adjust
the amount of rows in a spreadsheet, or even more helpful, is there a
way that you can only print cells that have actual text inside of the
cell. If this is not possible, I have to manually go in and highlight
what i want to print, and deal with the 28 mb file... Not really what I
want... Thank you for your help

 

[Dave Peterson]

I find that the easiest thing for me to do is to apply Data|Filter|Autofilter.

Then I can use the arrow to show the fields that I want (like non-blank). (some
of the options under Custom are very handy, too.)

 

[Otto Moehrbach]

Your file is 28 megs because when you linked the whole column you put
formulas in all 65,536 cells in that column! Copy/link just the cells you
want.
Given that you have linked entire columns and you want to repair that,
rather than start over, do this: Say your last row of useful data is row
100. In the name box, type "101:65536", without the quotes, and hit Enter.
This selects all the rows from 101 down. Do Edit - Delete. Save the file.
In some versions of Excel, it may be necessary to close and reopen the file.
Done HTH Otto