how can I delete the rows and column I am not using?

[edusegzy]

how can I delete the rows and column I am not using?


Thanks.

 

[edusegzy]

I mean if I am using only 10 rows and column 10, how can I delete the rest of the rows and columns in the worksheet that are not been used. (I tried highlighting column and row and deleting but it is not working.)


Thanks

 

[ninad7]

Select and Hide.

 

[bobhc]

Good evening edusegzy


Select the first column you do not need, in your example you want ten columns so click in the K column header to select the whole column, then press Ctrl + Shift + right arrow to select the rest of the sheet, it will be highlighted, then right click with the mouse and choose hide, all columns to the right of your tenth column will be hidden.For the rows do the same, select row eleven the Ctrl + Shift + down arrow, then right click and choose hide from drop down menu. You will be left with a ten by ten work sheet

 

[Faseeh]

Hi edusegzy,


I think this is what you are looking for:


"Show only few rows & columns in Excel [Quick tip] by Chandoo"

http://chandoo.org/wp/2012/07/24/show-only-few-rows-columns-in-excel/


Regards,

Faseeh