Can you set the max number of rows for a spreadsheet?

  • Thread starter Thread starter Gren Goodwin
  • Start date Start date
G

Gren Goodwin

I am wanting to have a sheet that allows only 200 rows and
36 columns. is this possible?
Help appreciated
 
Hi Gren!

One way. You can hide all columns to the right of column AJ and south
of row 200.

Note the quick method of selecting columns to the right inclusive of a
selected column is to select first column to be hidden and then use
Ctrl + Shift then press the right arrow. Similarly with rows.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Monday 4th August 2003: British Virgin
Islands, Dominica, Eire, Montserrat, St. Kitts & Nevis, St. Vincent &
Grenadines, UK (August Holiday), Anguilla (Carnival), Bahamas
(Emancipation Day), Barbados (Kadooment), Burkina Faso (Revolution
Day), Canada (British Columbia Day, New Brunswick Day, Natal Day),
China (Chinese Valentine's Day), Cook Islands (Constitution Day), El
Salvador (Transfiguration Day), Guyana (Freedom Day), Iceland (Workers
Day), Peru (Anniv Huancavelica), Zambia (Farmer's Day)
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Thanks Norman,
I'll do that :)
-----Original Message-----
Hi Gren!

One way. You can hide all columns to the right of column AJ and south
of row 200.

Note the quick method of selecting columns to the right inclusive of a
selected column is to select first column to be hidden and then use
Ctrl + Shift then press the right arrow. Similarly with rows.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Monday 4th August 2003: British Virgin
Islands, Dominica, Eire, Montserrat, St. Kitts & Nevis, St. Vincent &
Grenadines, UK (August Holiday), Anguilla (Carnival), Bahamas
(Emancipation Day), Barbados (Kadooment), Burkina Faso (Revolution
Day), Canada (British Columbia Day, New Brunswick Day, Natal Day),
China (Chinese Valentine's Day), Cook Islands (Constitution Day), El
Salvador (Transfiguration Day), Guyana (Freedom Day), Iceland (Workers
Day), Peru (Anniv Huancavelica), Zambia (Farmer's Day)
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.



.
Click to expand...
 
Back
Top