You cannot remove excess rows and columns.

You can hide them from view.

You could also set the scrollarea limited to A1:F44 through VBA.


Gord Dibben MS Excel MVP

On Fri, 20 Mar 2009 11:11:01 -0700, Robert SD <Robert
wrote:

Hello,
How do I remove unwanted rows and columns from a worksheet? I'm trying to
create a form and I only want columns A through F and rows 1 through 44 to
show.