Is there some way to set, or limit, the number of columns and rows
that I want for a spreadsheet.
All XL worksheets have 256 columns and 65,536 rows. You can't change
that.
You can hide columns and rows. For instance, to show only 10 columns,
enter "K:IV" (without the quotes) in the name box in the formula bar.
Hit enter to select the columns, then choose Format/Column/Hide.
You can do the same thing with rows, for instance, enter 51:65536 in the
name box, to hide all but rows 1:50.
You can then limit selection of hidden cells by unlocking the visible
cells (Format/Cells/Protection...), protecting the sheet
(Tools/Protection/Protect Worksheet), and using something like this
macro, placed in the ThisWorkbook code module:
Private Sub Workbook_Open()
Worksheets(1).EnableSelection = xlUnlockedCells
End Sub
Save and close the workbook, then reopen it in order to disable
selection of the hidden cells.
