Is there a way to limit the number of rows and columns in an excel sheet?

The number of rows is limited to 65536 and the number of columns is limited to
256.

You can hide the ones you're not using, but you can't get rid of them.

You can make it so that users can't scroll off the area that you set, though.
But it requires a small macro:

Option Explicit
Sub auto_open()
With Worksheets("sheet1")
.ScrollArea = "a1:g55"
End With
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


dgreenbergreps wrote:

Is there a way to limit the number of rows and columns in an excel sheet?

--

Dave Peterson