 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2007Selecting rows of cells
Need Help, sometimes when I try to select a row of cells, Excel also selects a row or two below the row I am trying to select. What causes this problem and what can I do about it. It only happens sometimes and at other times it works like it is supposed to. The only way I can get it to stop is to close the file then the Excel program and restart it. Most of the time this works. Any help would be appreciated. Thanks! Ed Hawley When it happens do you see EXT at the bottom of the screen? If so you are in extended mode. To get out od extended mode press the function key F8  SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > Need Help, sometimes when I try to select a row of cells, Excel also > selects a row or two below the row I am trying to select. What causes this [quoted text clipped - 5 lines] > Thanks! > Ed Hawley Thanks Sandy, I will give that a try. I am using Excel 2007, I forgot to tell you that. It is maddening to have to deal with this issue. Am I doing something that causes the program to go into Extended mode? One minute it is working fine the next time I go to select a row, I get the problem. The issue is very inconsistent. Have a great day! Ed Hawley > When it happens do you see EXT at the bottom of the screen? If so you are > in extended mode. To get out od extended mode press the function key F8 [quoted text clipped - 8 lines] >> Thanks! >> Ed Hawley > I will give that a try. I am using Excel 2007 Try it anyway but with XL2007 all bets are off <g> SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > Thanks Sandy, > [quoted text clipped - 19 lines] >>> Thanks! >>> Ed Hawley I bet you have merged cells in that range that you're trying to select. Each version of excel treats merged cells differently. With xl2003, I don't see that behavior. But I think that's the way xl97 worked (and I don't recall the other versions behaviors). So you may have at least a couple of choices. #1. Upgrade to a different version--although that may not help depending on what you're going to do with those selected rows. #2. Get rid of all the merged cells Select all the cells format|cells|alignment tab|uncheck Merge cells (xl2003 menu system) > Need Help, sometimes when I try to select a row of cells, Excel also selects > a row or two below the row I am trying to select. What causes this problem [quoted text clipped - 5 lines] > Thanks! > Ed Hawley SignatureDave Peterson Dave, Thanks for the response, I am using Excel 2007 and as far as I know, I have never merged or separated these particular cells. It will be working just fine then the next time I try, I have the problem. I will try Sandy's suggestions using the F8 the next time it occurs and see if that helps. Thanks Again! Ed Hawley >I bet you have merged cells in that range that you're trying to select. > [quoted text clipped - 29 lines] >> Thanks! >> Ed Hawley
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.