ExcelBanter - how can I limit the number of rows and colums

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how can I limit the number of rows and colums (https://www.excelbanter.com/excel-discussion-misc-queries/121831-how-can-i-limit-number-rows-colums.html)

May

how can I limit the number of rows and colums

Hi,
I want to limit the number of rows and colums
e.g. I want to display only 20 rows and 10 colums..so i can't scroll more
then that
..
Thank You

Gary''s Student

how can I limit the number of rows and colums

Select the rows or columns you do not need and

format column hide
or
format row hide
--
Gary's Student

"may" wrote:

Hi,
I want to limit the number of rows and colums
e.g. I want to display only 20 rows and 10 colums..so i can't scroll more
then that
.
Thank You

All times are GMT +1. The time now is 02:32 AM.