I want user cnt scroll down unused cells.
2006-07-28 01:28:24 · 7 answers · asked by debajitbasu 2 in Computers & Internet ➔ Programming & Design
1) Go to tools and select "protection" and then "protect sheet". The first two choices you have are to let the user select locked and unlocked cells. These two are normally checked.
2) Uncheck the one that says "select locked cells"
3) set your password (optional)
4) Select the range of cells that you want to be locked.
5) Go to Format-Cells, and click the "protection" tab. Check the "locked" option (in my case it's checked by default).
6) Make sure that the cells that you want the user to be able to select and modify (if that's the case) DONT have the "locked" checked as well (uncheck that option if it's checked by default).
2006-07-28 01:43:00 · answer #1 · answered by Patricia V 3 · 0⤊ 0⤋
If you mean "delete", then do what the guy above said. If you really mean "deactivate", I think that Excel keeps those empty rows there on purpose, just to let you know that if you need to do more, the program has the capacity. There is no data in there, and when you save a spreadsheet, Excel doesn't save a 200 x 200 table. It only saves what you use.
2006-07-28 01:34:39 · answer #2 · answered by Ogelthorpe13 4 · 0⤊ 0⤋
Wjhat do you mean by deactivate. Do you want that data other than yours can not be put in or changed?but then the date put in by you in columns can be altered easily so for your purpose whole page with blank and written columns should be deactivated
This can be done by saving the file and emailing it to your own Inbox ( This can not be opened without your Email add.or Password) The data in your Inbox isauthentic and original.
2006-07-28 01:54:57 · answer #3 · answered by shribharatpshubh 3 · 0⤊ 0⤋
variety with suggestions from columns a and b. which will line everyone up... so that you'll have all the... women who stated no women who stated sure adult males who stated no adult males who stated sure. then you somewhat can run a subtotal count number for each substitute in column b, count number column a. Edit: second technique yet another technique ought to be to position in cellular c2 (as i assume you've column headers) that states =if(a2="lady",b2,"") This formulation will merely positioned column b's outcomes if the guy is lady. In column D you could positioned =if(a2="Male",b2,"") to get the male outcomes besides. then you somewhat will be able to better visualize the outcomes. And in case you choose a count number of all the Trues from women, you could positioned; =countif(c2:c500, "actual") which will merely count number actual outcomes.
2016-11-26 20:31:08 · answer #4 · answered by minissale 4 · 0⤊ 0⤋
Right click on the header of either a column or row and then click on Delete.
2006-07-28 01:31:06 · answer #5 · answered by They call me ... Trixie. 7 · 0⤊ 0⤋
toggle the view page options under the tool bar
2006-07-28 01:32:35 · answer #6 · answered by J 4 · 0⤊ 0⤋
talk to microsft about that
2006-07-28 01:31:18 · answer #7 · answered by Anonymous · 0⤊ 0⤋