Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Worksheet Size

Copper Contributor

Can I set a max number of rows and columns for a worksheet that is less than the maximum supported size?

1 Reply


You cannot change the number of rows and columns (well, if you save a workbook as an Excel 97-2003 workbook, extension .xls, each sheet will have only 65536 rows and 256 columns instead of 1048576 rows and 16384 columns).

But you can hide the rows and columns that you don't need.

An extreme example: in the screenshot below, I have hidden all rows from row 13 down, and all columns from column M to the right: