Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Excel selects multiple cells in spreadsheet instead of single


(!)

eliztur's Avatar
eliztur eliztur is offline
Computer Specs
Junior Member with 3 posts.
THREAD STARTER
 
Join Date: May 2010
Experience: Intermediate
05-May-2010, 12:33 PM #1
Unhappy Excel selects multiple cells in spreadsheet instead of single
I am working in a very large spreadsheet and am having a problem with selecting individual cells. If I put my cursor in one cell it selects 6 more cells to the right as if they were merged while they are not. I am unable to copy formulas out of the single cell as it wants to select all 7. I don't know if it is a bug or what, but it is my 5 year financials and can't start all over. Does anyone have any ideas of what might be wrong? Please help!
etaf's Avatar
etaf   (Wayne) etaf is offline
Computer Specs
Moderator with 51,605 posts.
 
Join Date: Oct 2003
Location: Surrey, UK
05-May-2010, 01:09 PM #2
Is this on 2007 - theres quite a lot of this problem report across the web, cells above or below being selected and also cells left and right being selected , and does not seem to have a final answer, that I have found. I have no problem with 2003 at all - but do not have 2007 anymore available.

a work around I saw was to:
right click and the menu pops up and then immedaitely left click then just the one cell is selected
__________________
Wayne
Please let us know what the final solution was to any problem posted
eliztur's Avatar
eliztur eliztur is offline
Computer Specs
Junior Member with 3 posts.
THREAD STARTER
 
Join Date: May 2010
Experience: Intermediate
05-May-2010, 01:18 PM #3
Thanks. I will try it. Yes it is in 2007 and doesn't happen everywhere in the sheet. Sometimes in other areas it will select 3 cells and always on a horizontal path to the right. If anyone does hear about a fix please post.

Thanks again!
WendyM's Avatar
Trusted Advisor with 3,995 posts.
 
Join Date: Jun 2003
Location: Northern California
05-May-2010, 01:44 PM #4
Another workaround I've seen is to change the view from Page Layout to Normal. Good luck!
etaf's Avatar
etaf   (Wayne) etaf is offline
Computer Specs
Moderator with 51,605 posts.
 
Join Date: Oct 2003
Location: Surrey, UK
05-May-2010, 01:46 PM #5
eliztur's Avatar
eliztur eliztur is offline
Computer Specs
Junior Member with 3 posts.
THREAD STARTER
 
Join Date: May 2010
Experience: Intermediate
05-May-2010, 04:29 PM #6
Excel selects multiple cells in spreadsheet
Thanks everybody. This is incredible help and it is a shame that Microsoft doesn't acknowledge the problem.
Email This Email  Print This Print  Add to Favorites Favorites  Tweet This Send to Facebook Send to MySpace Send to StumbleUpon Digg This | More Services More
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 


Similar Threads
Title Thread Starter Forum Replies Last Post
Solved: HTML radio buttons are allowing multiple instead of single selection andynic Web Design & Development 5 08-Apr-2010 11:10 AM
PowerPoint 2003 in Vista: Prob selecting multiple objects mottafamily Business Applications 1 10-Nov-2009 06:15 AM
Solved: Excel 2007- Two formulas in one cell (Please Help) cyrus123 Business Applications 8 21-Jan-2009 11:42 AM
Excel Macro which Selects Last cell in a Row? NortonPkg Business Applications 6 18-Jan-2008 01:29 PM
Excel Macro Selecting Multiple Cells wolfo Business Applications 4 30-Sep-2006 04:01 PM

WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑