BTW... 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. Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. Top of Page Unlock ranges on a protected worksheet for users to edit To give specific users permission to edit ranges in a protected worksheet, your computer must be running Microsoft
Register To Reply 02-26-2010,10:50 PM #3 barneyruckus View Profile View Forum Posts Registered User Join Date 02-26-2010 Location Los Angeles, California MS-Off Ver Excel 2007 Posts 2 Re: Can't Select Single How did they manage that? Register To Reply + Reply to Thread « Previous Thread | Next Thread » Thread Information Users Browsing this Thread There are currently 1 users browsing this thread. (0 members and people have tried different things to make it go away...
Posts 13,686 Re: Cell freezes, workbook freezes Have you seen the information linked in the sticky post at the top of the Technical forum? BTW... Delete rows Deleting rows. Can't Select Cells In Excel 2016 Using a password allows you to see user credentials of any authorized person who edits the range.
Trying to figure out what he may have done or selected on this sheet. Any idea? 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 Delete rows is protected and Insert rows is not also protected, a user can insert rows that he or she cannot delete. http://legalofficeguru.com/reader-question-cannot-select-single-cell-row-column/ Help!
User Name Remember Me? Can't Select Cells In Excel Mac Excel Esquire Helping lawyers make the most of Excel Lawyerist The lawyering survival guide Office for Mac For all you Apple fans out there, here's help on Office for Mac Spreadsheet 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 Format cells Changing any of the options in the Format Cells or Conditional Formatting dialog boxes.
I would like to get as close to the standard OOBE Google play. http://www.excelforum.com/showthread.php?t=719802 In the Refers to cells box, type an equal sign (=), and then type the reference of the range that you want to unlock. Excel Can't Click On Anything 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. Mouse Not Working In Excel This really confused me.
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 his comment is here View the most recent issue. Here's the problem I'm having today: I'm trying to select a range of cells with my mouse, say A1:E5. Use AutoFilter Using the drop-down arrows to change the filter on ranges when AutoFilters are applied. Selected Cells Not Highlighted In Excel
If you applied conditional formats before you protected the worksheet, the formatting continues to change when a user enters a value that satisfies a different condition. Please try the request again. Originally Posted by rdw72777 ...it seems like the file is trying to do soemthing with worksheets. this contact form In previous versions of Excel you could change the colors in Windows itself; this won't really affect Excel 2007 that much.
Note Specifying a password is optional when you plan to use access permissions. Cannot Select Cells In Excel 2013 On the other, I COULD. This allows me to see how the site is used and gives me the opportunity to offer you additional content you may be interested in, depending on what tutorials you've viewed.
Thanks! Join the community Back I agree Powerful tools you need, all for free. Basically through an "over the hils and through the woods" review, I have figured out that my mouse is the actual culprit. Excel Won't Highlight Selected Cells This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables.
I'm assuming you meant disk, DiabloII, otherwise I'm not sure your suggested fix will work! What is happening? Speak your truth quietly & cearly; and listen to other, even the dull & ignorant, they to have their story TomB Reply With Quote Apr 6th, 2009,06:55 PM #8 Von Pookie http://sonoportal.net/in-excel/cannot-select-cells-in-excel-2003.html Format cells Changing any of the options in the Format Cells or Conditional Formatting dialog boxes.
Do one of the following: To add a new editable range, click New. All rights reserved. Adding or editing comments. They suggest making sure all the cables are properly connected and then restarting the computer.
Helpful Links ExcelTips FAQ ExcelTips Resources Ask an Excel Question Make a Comment Free Business Forms Free Calendars Tips.Net > Excel Home > Configuring Excel > Selected Cells Not Drag mouse to E5. 4. Delete columns Deleting columns. take your pick....
Loading ExcelTips (Ribbon Interface) This Site Got a version of Excel that uses the ribbon interface (Excel 2007 or later)?
© Copyright 2017 sonoportal.net. All rights reserved.