Deleting rows

J

Joey

Hi all

How can I delete rows below my work area?

Someone's selected loads of rows (upto 6000) and saved the workbook.

Any advice would be appreciated
Joe
 
L

Lady Layla

Select entire row directly below your work area, Hit the delete key, save file.

Though this will not actually delete the rows, it will reset the last row number
used to assist in scrolling through your work area


: Hi all
:
: How can I delete rows below my work area?
:
: Someone's selected loads of rows (upto 6000) and saved the workbook.
:
: Any advice would be appreciated
: Joey
:
:
: ---
:
:
 
F

Freemini

Select the entire row immediately under your data, press CTRL+Shift+En
together. This will highlight all rows to the end of the worksheet.

Right click the mouse and choose delete.

Move to the top of you sheet.

Finally save the file, you should now get a longer scroll bar whic
will take you down to the end of you data.

The same process can be used to delete unwanted columns.

hth

Mik
 
F

Freemini

Select the row immediately below your data.

Hold down CTRL+Shift+End together, this will highlight all the row
below your data which are part of the sheet.

Choose Edit, Delete

Now move back to the top part of your data.

Save the file. You will now see the scroll bar has grown, pulling i
down will take you to the bottom of your data.

The same process can be used to get rid of empty columns.

hth

Mik
 
Top