Home > In Excel > Can't Select Cells In Excel

Can't Select Cells In Excel

Contents

In the Allow all users of this worksheet to list, select the elements that you want users to be able to change. To enable cells to be edited while leaving only some cells locked, you can unlock all the cells and then lock only specific cells and ranges before you protect the worksheet. and very frustrating when I have to default to navigating the selection field using the arrow keys. You can also go to "File" >> "Info" and see if there is anything showing under the "protect workbook" if there's not then you can select "Check for Issues" and see weblink

Uncheck the Select Unlocked Cells option. Members List Calendar Forum Rules Dashboard Commercial Services Advanced Search Forum Microsoft Office Application Help - Excel Help forum Excel General Excel 2007 : Can't Select Single Cell or Row To By default, users can select unlocked cells, and they can press the TAB key to move between the unlocked cells on a protected worksheet. Send No thanks Thank you for your feedback! × English (United States)‎ Contact Us Privacy & Cookies Terms of use & sale Trademarks Accessibility Legal © 2016 Microsoft {{offlineMessage}} Store Store

Can't Select Cells In Excel

By default, users are allowed to select locked cells. Sort Using any commands to sort data (Data tab, Sort & Filter group). Check the FAQ's to see how. My conclusion is this: If all I have to do to fix this problem is make sure I'm at %100...

In the Refers to cells box, type an equal sign (=), and then type the reference of the range that you want to unlock. Make sure that you choose a password that is easy to remember, because if you lose the password, you cannot gain access to the protected elements on the worksheet. 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 Selected Cells Not Highlighted In Excel Share Share this post on Digg Del.icio.us Technorati Twitter Using Excel 2016 Reply With Quote « Previous Thread | Next Thread » Like this thread?

Make sure that you choose a password that you can remember, because if you lose the password, you cannot gain access to the protected elements on the worksheet. Insert rows Inserting rows. In the Title box, type the name for the range that you want to unlock. I use the word "appear", as I am fairly sure there is no protection in place that should prevent me from using said cells.

I can't seem to select just 1 (one) cell at a time, nor can I select 1 (one) row at a time. Can't Select Cells In Excel 2016 To prevent that, you can lock them out of certain cells and then protect the worksheet. To modify an existing editable range, select it in the Ranges unlocked by a password when sheet is protected box, and then click Modify. By default, users can select unlocked cells, and they can press the TAB key to move between the unlocked cells on a protected worksheet.

Can't Select Multiple Cells In Excel

Format cells Changing any of the options in the Format Cells or Conditional Formatting dialog boxes. Zoom Slider Based on this reader's description of her problem, I had assumed she had stumbled across Extend Selection Mode. Can't Select Cells In Excel I don't think Excel changed the scroll area property through the VBE per se. Excel Can't Click On Anything Reason: A simple solution has been found...

To see how user names should be entered, click examples. have a peek at these guys If you have formulas you want to protect, you can use the Hidden check box in this dialog box to hide the cells with formulas. If you notice some weird selection behavior going on with your mouse in Excel, take a look at the Status Bar — you might see something toward the left end that Do one of the following: To add a new editable range, click New. Mouse Not Working In Excel

Delete columns Deleting columns. On the other hand, the setup I'm suggesting creates an easy-to-follow data entry map. If Delete columns is protected and Insert columns is not also protected, a user can insert columns that he or she cannot delete. http://outwardsound.com/in-excel/how-to-lock-cells-in-excel-2010.html Powered by vBulletin® Version 4.1.8 Copyright © 2012 vBulletin Solutions, Inc.

Sometime increase or decrease the Zoom this also worked. 0 Pimiento OP nehagoel Nov 29, 2015 at 4:31 UTC 1st Post Thanks Rajesh it was helpful. 0 Excel Won't Let Me Select Multiple Cells Insert hyperlinks Inserting new hyperlinks, even in unlocked cells. Insert rows Inserting rows.

Nice job sleuthing that out.

Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals. Delivered Daily Subscribe Best of the Week Our editors highlight the TechRepublic articles, galleries, and videos that you absolutely cannot miss to stay current on the latest IT news, innovations, and If prompted for a password, type the password that you specified. Cannot Select Cells In Excel 2013 Users cannot apply or remove AutoFilters on a protected worksheet, regardless of this setting.

Click OK. Insert rows Inserting rows. Format rows Using any of the row formatting commands, including changing row height or hiding rows (Home tab, Cells group, Format button). http://outwardsound.com/in-excel/cannot-open-excel-97-2003-worksheet-in-excel-2013.html Now, you can choose the cells you specifically want to lock.

On the Review tab, in the Changes group, click Protect Sheet. Insert hyperlinks Inserting new hyperlinks, even in unlocked cells. Format columns Using any of the column formatting commands, including changing column width or hiding columns (Home tab, Cells group, Format button). Home × Post-SpiceWorld Community release is out: Check it out!

You are awesome! On the Home tab, in the Font group, click the Format Cell Font dialog box launcher.