(6) Rename ShortSheet to the actual name of your original sheet`. (5) Delete YourOriginalSheet (The relevant data is currently saved in ShortSheet.) (3) Press Ctrl-Shift-End to find the lower-right-hand corner of ShortSheet to make sure it contains all relevant data. (2e) Include other Paste Special options that you think might help make the sheet look better. (2) Add a new sheet named ShortSheet, put the cursor into the cell representing the upper-left-hand corner of the range being copied (probably A1), and paste like so: (1) In YourOriginalSheet, Select and Copy the range of relevant cells (don't paste anywhere yet). Let's call the other sheet ShortSheet, which will contain a copy of only relevant cells. Let's call your original sheet YourOriginalSheet (it represents the actual name of your original sheet).
There are two sheets referred to in the procedure below. ( It won't take as long as a first look might suggest and it's safe!)
How to delete unwanted rows and columns in an Excel worksheet
