Delete unused coloumn & rows

[sanjeevi888]

how to delete unused column & rows
need to delete column G to End
Row 2000 to End.

[abousetta]

manually or using vba?

[sanjeevi888]

Any simple method..

[abousetta]

Highlight the first column or row that you want to delete then:

1) Column - Ctrl + Shift + Right arrow >> Delete

2) Row - Ctrl + Shift + Down arrow >> Delete

[sanjeevi888]

not working for me..!

[abousetta]

You have to make sure that all the rows/ columns that you want deleted are highlighted. If (for example) you highlight Column F then Ctrl + Shift >> right arrow (while Ctrl + shift are still pressed), Excel will highlight all the columns that are the same as column F. If the first cell in Column is filled then it will only highlight until the last column with something in row 1. So you may have to click the right arrow several times to get to the last column in the worksheet.

OR...

try the following:

1) highlight the first column to be deleted

2) Ctrl + Shift + End

3) without letting go of the Ctrl + Shift + End keys, press the down arrow

4) With all the columns selected, click on the delete button if you want to just clear the cells OR right click in the highlighted area >> Delete (this will delete the columns, not just clear the information... no formatting, etc. will remain).

abousetta

[sanjeevi888]

please upload any sample..

[ChemistB]

Hi Sanjeevi,
What abousetta was explaining was that when you delete the columns, other columns take their place. Excel has a certain number of columns and rows. It doesn't change.

What you can do, is follow Abousetta's directions but instead of hitting delete, right click and hit "Hide" The rows and columns are still there but hidden from view.