This is a newbie question, but it's driving me nuts.
How do I delete the empty but invisible active cells at the end of an Excel spreadsheet? How do I even know the cells are there? Here's why it's a problem: A co-worker sends me Excel spreadsheets that have to be imported into FileMaker Pro. I can do that, and if I get lost, I can get help from my husband, who is a FileMaker wizard. However, the guy who sends me the Excel spreadsheets is NOT a wizard. He sends spreadsheets with empty but active cells at the END of the spreadsheets. When the spreadsheets are imported into FileMaker, this results in a lot of blank records. This is a BIG problem, because when you delete a FileMaker record, the INDEX NUMBER of that record is PERMANENTLY lost from that database. For example, after deleting records 21-30, the order of the FileMaker records would go 19, 20, 31, 32, 33, etc. This wouldn't bother me, but the person I send the records on to next HAS TO HAVE THE RECORDS IN UNBROKEN NUMERICAL ORDER. A database with the numbers 19, 20, 31, 32, 33, etc. confuses her TERRIBLY. Since she's of managerial rank, I have to do what she wants. So please-does anyone know what to do with the empty cells at the end of an Excel document? The only thing I could think of to do was to copy the cells that I knew were active and put them into another, new spreadsheet. I'll do this if I have to, but it adds another task to an already busy and confusing day. (BTW, did I mention that I'm looking for a new job?) --Constance Warner ************************************************************************* ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *************************************************************************
