Follow the below steps to do this easily
It helps to put a limit on the number of columns available to view or enter data in. We can limit maximum columns visible or accessible to others by hiding the unused or remaining columns of the worksheet. Hiding Rows How to Limit Number of Columns It allows us to hide the irrelevant data and put a limit for entering data. We can put the row limit after a certain number of rows to remain invisible to others by hiding them easily. How to Limit Number of Rows and Column How to Limit Number of Rows We can manage to make the maximum number of columns or the maximum number of rows visible and restrict the others to add more rows or columns in the worksheet.įigure 1. But it is rare to use all of these rows and columns. How to Limit Number of Rows And Columns in Excelīy default, each worksheet contains more than 100,000 rows and 16,000 columns to input data.
