Removing Unwanted Cells

Hi all,

I've inhereted a spreadsheet off a colleague, and there are LOTS of empty rows with formatting but no information (the rows with data go down to 240, but I actually have around 4,000 rows!).

I've been able to remove the formatting, but actually reducing the number of rows is another thing all together. I've tried simly going to the bottom, selecting the empty rows and *Right-Click*>Delete, and also *Right-Click*>Clear Contents. Neither of which seem to work.

This is really a problem of aesthetics, it would just be nice to lean up the spreadsheet a bit.

Any ideas?

TIA,

SamuelT

Hi Samuel

Try going to the row after the last row of data that you require to keep.
Click on the row number to highlight the row.
Hold down Ctrl+Shift and press the down arrow, and this should select all of
the rows down to 65536.
Right click>Delete.
Save the file, close and re-open.

If that doesn't work post back, as there is probably some VBA code somewhere
setting the formatting.

Regards

Roger Govier


SamuelT wrote:
> Hi all,
>
> I've inhereted a spreadsheet off a colleague, and there are LOTS of
> empty rows with formatting but no information (the rows with data go
> down to 240, but I actually have around 4,000 rows!).
>
> I've been able to remove the formatting, but actually reducing the
> number of rows is another thing all together. I've tried simly going to
> the bottom, selecting the empty rows and *Right-Click*>Delete, and also
> *Right-Click*>Clear Contents. Neither of which seem to work.
>
> This is really a problem of aesthetics, it would just be nice to lean
> up the spreadsheet a bit.
>
> Any ideas?
>
> TIA,
>
> SamuelT
>
>

Selecting and deleting the empty rows should sort the problem. That said, I
have a sheet where I can not delete some empty columns at the end. I even
tried selecting more columns beyond the used range, but that just increased
the last column, rather than reducing it.

If it's a fairly straightforward sheet, try selecting the cells you want and
copy them to a new sheet.

--
Ian
--
"SamuelT" <[email protected]> wrote in
message news:[email protected]...
>
> Hi all,
>
> I've inhereted a spreadsheet off a colleague, and there are LOTS of
> empty rows with formatting but no information (the rows with data go
> down to 240, but I actually have around 4,000 rows!).
>
> I've been able to remove the formatting, but actually reducing the
> number of rows is another thing all together. I've tried simly going to
> the bottom, selecting the empty rows and *Right-Click*>Delete, and also
> *Right-Click*>Clear Contents. Neither of which seem to work.
>
> This is really a problem of aesthetics, it would just be nice to lean
> up the spreadsheet a bit.
>
> Any ideas?
>
> TIA,
>
> SamuelT
>
>
> --
> SamuelT
> ------------------------------------------------------------------------
> SamuelT's Profile:
> http://www.excelforum.com/member.php...o&userid=27501
> View this thread: http://www.excelforum.com/showthread...hreadid=479727
>

Hi,

The delete, close and save worked a treat.

Thanks very much!

SamuelT