Ask Your Question

Is it possible to impose a limit (columns and rows) on spreadsheet size? [closed]

asked 2013-05-05 15:58:14 +0100

TonyS gravatar image

Imposing a limit on spreadsheet size

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-31 04:07:46.886337


Could you please describe how this would be helpful or why exactly do you need it?

mahfiaz gravatar imagemahfiaz ( 2013-05-05 16:35:45 +0100 )edit

Thanks mariosv, that prevents me from selecting a cell I don't wish to use but unfortunately it does not prevent me scrolling too far down or right, beyond the area I am using. I was hoping to be able to limit how far I can scroll down or right to, for example: column M and row 52.

TonyS gravatar imageTonyS ( 2013-05-05 18:36:18 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2013-05-05 18:11:32 +0100

m.a.riosv gravatar image

Hi TonyS,

there is a way, that I hope will be enough for you.

Set up the cells in the range what you want use as unprotected.
Select the range, Crtl+1 - Cell protection tab - uncheck Protected.

Set up the sheet as protected with select protected cell disable.
Menu/Tools/Protect document/Sheet
- blank key is Ok
- uncheck Select protected cells.

edit flag offensive delete link more


Thanks your answer worked for me

achurcheh gravatar imageachurcheh ( 2014-09-11 15:27:27 +0100 )edit

answered 2013-05-05 17:43:59 +0100

TonyS gravatar image

updated 2013-05-05 17:44:22 +0100

Yes, I am always accidentally scrolling way over to the right of my spreadsheets even when they are only, say, 10 columns wide . I do a similar thing when scrolling down, when dragging ranges especially. If I could limit the size to the number of columns and rows I am using I would never be able to accidentally scroll beyond the extent of the columns and rows I am actually using. It is particularly easy to accidentally do with, an an irritable aspect of, Apple's 'magic' mouse.

edit flag offensive delete link more

Question Tools


Asked: 2013-05-05 15:58:14 +0100

Seen: 11,796 times

Last updated: May 05 '13