Do one of the following: To add a new editable range, click New. If Delete rows is protected and Insert rows is not also protected, a user can insert rows that he or she cannot delete. Reason: did not spell excel right Share Share this post on Digg Del.icio.us Technorati Twitter Surrender be on good terms with all persons. Cells to the beginning of the worksheet Select the first cell, and then press CTRL+SHIFT+HOME to extend the selection of cells to the beginning of the worksheet. Check This Out
More information about worksheet elements Worksheet elements Clear this check box To prevent users from Select locked cells Moving the pointer to cells for which the Locked check box is selected Users cannot apply or remove AutoFilters on a protected worksheet, regardless of this setting. On the Protection tab, clear the Locked check box, and then click OK. Extend Selection changes the behavior of the mouse and arrow keys to enable a user to more easily select multiple cells. https://support.office.com/en-us/article/Lock-cells-in-a-worksheet-b2f833bd-9db5-48a4-9ec0-8e451ac27c3a
LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode I went to Microsoft Answers (http://answers.microsoft.com) and did a little search. I can't seem to select just 1 (one) cell at a time, nor can I select 1 (one) row at a time. That’s why it’s often better to uncheck the Locked box for everything first, before choosing the specific cells you want to lock.
Here is the FAQ for this forum. + Reply to Thread Results 1 to 4 of 4 Excel 2007 : Can't Select Single Cell or Row Thread Tools Show Printable Version Click OK two times. Users can't sort ranges that contain locked cells on a protected worksheet, regardless of this setting. Selected Cells Not Highlighted In Excel You are awesome!
Could also try Excel switches ("safe mode" etc) on the troubled machine: http://support.microsoft.com/kb/291288 0 Pimiento OP BettyBe Sep 19, 2012 at 7:24 UTC 1st Post I noticed Mouse Not Working In Excel Thanks for the tips... The problem is still there. try this Thanks!
Brian Reply Subscribe View Best Answer RELATED TOPICS: Android phone no Internet on WiFi via DHCP but works with static IP Excel spreadsheet jumps to high cell number when opening Can't Select Cells In Excel Mac This does not really fix the problem, as the it's obviously a bug that is still limiting me from using basic functions that I can use with no problem in other Using a password allows you to see user credentials of any authorized person who edits the range. Chart sheet elements Select this check box To prevent users from Contents Making changes to items that are part of the chart, such as data series, axes, and legends.
Listening / Learning should still work Some code in the macro could be bad. 0 Thai Pepper OP RSturba Aug 6, 2012 at 11:20 UTC I know you Format cells Changing any of the options in the Format Cells or Conditional Formatting dialog boxes. Excel Can't Click On Anything Share Share this post on Digg Del.icio.us Technorati Twitter Colin RAD Excel Blog Reply With Quote Apr 6th, 2009,06:40 PM #7 Diablo II Board Regular Join Date Sep 2008 Location Tampa Can't Select Multiple Cells In Excel Keyboard shortcut You can also press CTRL+1.
The chart continues to be updated when you change its source data. http://sonoportal.net/in-excel/cannot-select-cells-in-excel-2003.html This is so strange... Delete rows Deleting rows. I have no idea why it's doing this and it's driving me crazy! Can't Select Cells In Excel 2016
If Delete columns is protected and Insert columns is not also protected, a user can insert columns that he or she cannot delete. User Name Remember Me? These highlights do not appear in a printout. this contact form Click OK.
More information about worksheet elements Worksheet elements Clear this check box To prevent users from Select locked cells Moving the pointer to cells for which the Locked check box is selected Cannot Select Cells In Excel 2013 I googled and found a few.... Edit scenarios Viewing scenarios that you have hidden, making changes to scenarios that you have prevented changes to, and deleting these scenarios.
and very frustrating when I have to default to navigating the selection field using the arrow keys. The password is optional. This really confused me. Excel Can't Select Single Cell By default, users are allowed to select locked cells.
In the Enter the object names to select (examples) box, type the names of the users who you want to be able to edit the ranges. If prompted for a password, type the password that you specified. Next: Building reuseable Microsoft Word footers Previous: Want to learn about Word Styles? navigate here The chart continues to reflect changes made to its source data.
This unlocks all the cells on the worksheet when you protect the worksheet In the worksheet, select just the cells that you want to lock. Users cannot apply or remove AutoFilters on a protected worksheet, regardless of this setting. I think this is when I started experiencing this problem. The rectangular range between the active cell and the cell that you click becomes the new selection.
In the Password to unprotect sheet box, type a password, click OK, and then retype the password to confirm it. Edit objects Doing the any of the following: Making changes to graphic objects including maps, embedded charts, shapes, text boxes, and controls that you did not unlock before you protected the If you do not supply a password, then any user can unprotect the sheet and change the protected elements. Insert rows Inserting rows.
© Copyright 2017 sonoportal.net. All rights reserved.