How to Remove Rows/Columns from Worksheet?

[troymet]

Is there another way to remove rows/columns from a worksheet instead of selecting the respective rows/columns and hiding them?
Thx.

 

[Datsmart]

You can select the row or column and hit Ctrl-- (Ctrl and Minus sign) to delete the row or column entirely.
Ctrl-+ will insert a row/column above/left of the Row/column you have selected.

 

[troymet]

Thanks John, another question:

How about it you don't want a new row/column to be added after you delete one. For example, you only want 150 rows and 150 columns visible in the worksheet. Again, I would want to delete the extra columns or rows, not hide.

Thanks,

 

[Datsmart]

You cannot delete the total rows and columns of your worksheet. You will always have 65536 Rows and 256 Columns, but you can hide the ones you don't use.

See this post for code to easily do so.
http://www.mrexcel.com/board2/viewtopic.php?t=279873