Not an IT pro? Learn More. Internet Explorer TechCenter. Sign in. United States English. Ask a question. Quick access. Search related threads. Remove From My Forums.
Answered by:. Archived Forums. Excel IT Pro Discussions. This forum is for general questions and feedback related to Microsoft Excel all versions as they pertain to the IT Pro community.
Sign in to vote. When I am working with Excel , I try to select a single cell however multiple cells get highlighted. It will highlight usually the next cells in the same row. If I click the cell and it does its highlighting thing, I usually have to click away in another cell and then re-click the first one to get it to go away.
Also, if I just try to ignore the highlighted cells and try to work as normal, when I try to tab to the next cell in the row, it will only let me tab between the cells in the column that are highlighted. It is not a mouse problem, I am not accidentally selecting multiple cells, and it happens on documents I created as well as documents others have created. It will also happens on a new, blank document or others completely stripped of any kind of potentially hidden formatting. I have not tried to re-install Office yet, but that will be next step if no one has a solution.
Tuesday, November 23, PM. Wednesday, November 24, AM. Monday, December 6, PM. That forwards to another site. This seems to be a bug. Wednesday, May 25, PM. I just want to thank the person who wrote about this issue and the person s that had the answer.
It's been driving me crazy, but the F8 toggle did the trick! Wednesday, September 14, PM. The F8 toggle doesn't always work.
This is a bug with Excel and Microsoft is aware of it but doesn't seem to know how to fix it. Friday, February 10, PM. Doesn't work for mine either Tried the f8, same results Any updates on this yet??? Monday, April 9, PM. I am having the same problem in MS Excel and F8 does not solve it.
Thursday, April 26, PM. I I first came across this problem today and it would appear that the only other potential fix is to use the zoom feature in the bottom rhs of the screen and zoom out and then back in to your original size and this seems to cure the problem. Good luck. Thursday, May 31, PM. Good Luck! Proposed as answer by weaver Sunday, April 26, AM. Monday, July 2, PM. It seems to happen when I scroll to a part of the sheet that was previously off-screen.
Zooming seems to fix it for now. Tuesday, July 3, PM. I have this same issue. F8 has nothing to do with it. Thursday, October 18, AM.
F8 did not help me at all. It only made the two highlighted cells go to 6 cells. And I thank the people who suggested that!! That was driving me crazy. Wednesday, November 7, PM. I've been dealing with this also. As soon as I do that I started getting random multiple cells being highlighted. I see in other replys that decreasing the zoom seems to help some people with this issue.
It is just annoying anyway you look at it. Hold down your Shift key, and then click that cell. Now, hold down the Ctrl key and click to select additional cells. You can also use your Ctrl key to deselect an already selected cell—even from a selection range. If you know the exact range of cells you want to select, using the name box is a useful way to make the selection without any clicking or dragging. You may need to select an entire row of cells at one time—perhaps to apply formatting a header row.
Sometimes, you may want to select multiple entire rows cells. Continuing to hold down your mouse button, drag your cursor across all the rows you want to select. Or, if you prefer, you can hold down your Shift key and click the bottom-most row you want to select. Then hold down your Ctrl key while clicking the row numbers of additional rows you want to add to the selection.
And, just like with individual cells, you can also use the Ctrl key to deselect rows from a selected range. Sometimes, you may want to select an entire column of cells. In fact, it works exactly like selecting rows. You can also select multiple columns by clicking and dragging or by using the Shift key, just like with rows.
The Ctrl key also works for selecting noncontiguous columns or for deselecting columns from a selected range. Browse All iPhone Articles Browse All Mac Articles Do I need one? Browse All Android Articles Browse All Smart Home Articles Customize the Taskbar in Windows Enter your address and click "Subscribe. Your e-mail address is not shared with anyone, ever. Maximum image size is 6Mpixels. Images larger than px wide or px tall will be reduced. Up to three images may be included in a comment.
All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted. There are currently no comments for this tip. Be the first to leave your comment—just use the simple form above! This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface. View the most recent newsletter. Toggle navigation.
Selecting Multiple Cells by Mistake. Author Bio. Excluding Some Data from a Chart Excel is a whiz at creating charts from your worksheet data. Discover More. In this case, Extend Selection or Add to Selection is displayed on the status bar status bar: A horizontal bar at the bottom of the screen that displays information about the current condition of the program, such as the status of items in the window, the progress of the current task, or information about the selected item.
If this is happening to you, you may have hit the F8 Key accidentally. Before I learned about this, the onlyl thing that worked for me was to save my spreadsheet, close it and re-open the spreadsheet. Sorry it did not work for you. What Excel version are you on and what type of computer are you using Mac or Windows? Had been in Page Layout view. Normal view worked like a charm! Thanks thanks. Thank you. Switching to Normal View did the trick. I am having trouble just selecting a straight row or simple print area.
0コメント