Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple cell selection
All of a sudden, when selecting a single cell, three are selected. This is a
problem on the spreadsheet that I have been using and not on others. Apparently, I created this option on this spreadsheet only. How can I change it back and select only one cell at a time? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple cell selection
Any macro ?
Regards. Daniel "Joe Palazzo" a écrit dans le message de news: ... All of a sudden, when selecting a single cell, three are selected. This is a problem on the spreadsheet that I have been using and not on others. Apparently, I created this option on this spreadsheet only. How can I change it back and select only one cell at a time? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple cell selection
No, just a simple spreadsheet. The most complicated function is SUM.
I was copying cells with Ctrl-c and pasting with Ctrl-v when this change took place. I may have changed some default select function, but I can't find any way to change it back. "Daniel.C" wrote: Any macro ? Regards. Daniel "Joe Palazzo" a écrit dans le message de news: ... All of a sudden, when selecting a single cell, three are selected. This is a problem on the spreadsheet that I have been using and not on others. Apparently, I created this option on this spreadsheet only. How can I change it back and select only one cell at a time? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple cell selection
That's what I tried. I thought that I may have corrupted it in some way, so
I tried copying a section at a time to a blank worksheet and tested the new worksheet along the way. Everything copied and the problem is gone on the new worksheet. I am still mystified, though -- never have seen anything like this. Thanks, Joe "Daniel.C" wrote: Maybe, the workbook is corrupted. Try to copy yours sheets to a new workbook. Daniel "Joe Palazzo" a écrit dans le message de news: ... No, just a simple spreadsheet. The most complicated function is SUM. I was copying cells with Ctrl-c and pasting with Ctrl-v when this change took place. I may have changed some default select function, but I can't find any way to change it back. "Daniel.C" wrote: Any macro ? Regards. Daniel "Joe Palazzo" a écrit dans le message de news: ... All of a sudden, when selecting a single cell, three are selected. This is a problem on the spreadsheet that I have been using and not on others. Apparently, I created this option on this spreadsheet only. How can I change it back and select only one cell at a time? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple cell selection
Joe
If using Excel 2007, try setting the Zoom a little lower. Gord Dibben MS Excel MVP On Thu, 9 Oct 2008 11:48:05 -0700, Joe Palazzo wrote: That's what I tried. I thought that I may have corrupted it in some way, so I tried copying a section at a time to a blank worksheet and tested the new worksheet along the way. Everything copied and the problem is gone on the new worksheet. I am still mystified, though -- never have seen anything like this. Thanks, Joe "Daniel.C" wrote: Maybe, the workbook is corrupted. Try to copy yours sheets to a new workbook. Daniel "Joe Palazzo" a écrit dans le message de news: ... No, just a simple spreadsheet. The most complicated function is SUM. I was copying cells with Ctrl-c and pasting with Ctrl-v when this change took place. I may have changed some default select function, but I can't find any way to change it back. "Daniel.C" wrote: Any macro ? Regards. Daniel "Joe Palazzo" a écrit dans le message de news: ... All of a sudden, when selecting a single cell, three are selected. This is a problem on the spreadsheet that I have been using and not on others. Apparently, I created this option on this spreadsheet only. How can I change it back and select only one cell at a time? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple cell selection
I am using Exel 2007. I'll try it, but can you tell me why you think that
zoom would matter in this instance? "Gord Dibben" wrote: Joe If using Excel 2007, try setting the Zoom a little lower. Gord Dibben MS Excel MVP On Thu, 9 Oct 2008 11:48:05 -0700, Joe Palazzo wrote: That's what I tried. I thought that I may have corrupted it in some way, so I tried copying a section at a time to a blank worksheet and tested the new worksheet along the way. Everything copied and the problem is gone on the new worksheet. I am still mystified, though -- never have seen anything like this. Thanks, Joe "Daniel.C" wrote: Maybe, the workbook is corrupted. Try to copy yours sheets to a new workbook. Daniel "Joe Palazzo" a écrit dans le message de news: ... No, just a simple spreadsheet. The most complicated function is SUM. I was copying cells with Ctrl-c and pasting with Ctrl-v when this change took place. I may have changed some default select function, but I can't find any way to change it back. "Daniel.C" wrote: Any macro ? Regards. Daniel "Joe Palazzo" a écrit dans le message de news: ... All of a sudden, when selecting a single cell, three are selected. This is a problem on the spreadsheet that I have been using and not on others. Apparently, I created this option on this spreadsheet only. How can I change it back and select only one cell at a time? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple cell selection
The multiple cell selection is a bug in Excel 2007.
The zoom-changing appears to fix it. I don't have 2007 but many postings have made the suggestion and it seems to work. Gord On Thu, 9 Oct 2008 12:57:02 -0700, Joe Palazzo wrote: I am using Exel 2007. I'll try it, but can you tell me why you think that zoom would matter in this instance? "Gord Dibben" wrote: Joe If using Excel 2007, try setting the Zoom a little lower. Gord Dibben MS Excel MVP On Thu, 9 Oct 2008 11:48:05 -0700, Joe Palazzo wrote: That's what I tried. I thought that I may have corrupted it in some way, so I tried copying a section at a time to a blank worksheet and tested the new worksheet along the way. Everything copied and the problem is gone on the new worksheet. I am still mystified, though -- never have seen anything like this. Thanks, Joe "Daniel.C" wrote: Maybe, the workbook is corrupted. Try to copy yours sheets to a new workbook. Daniel "Joe Palazzo" a écrit dans le message de news: ... No, just a simple spreadsheet. The most complicated function is SUM. I was copying cells with Ctrl-c and pasting with Ctrl-v when this change took place. I may have changed some default select function, but I can't find any way to change it back. "Daniel.C" wrote: Any macro ? Regards. Daniel "Joe Palazzo" a écrit dans le message de news: ... All of a sudden, when selecting a single cell, three are selected. This is a problem on the spreadsheet that I have been using and not on others. Apparently, I created this option on this spreadsheet only. How can I change it back and select only one cell at a time? |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple cell selection
Thanks, Gord. I always get my answer here.
Joe "Gord Dibben" wrote: The multiple cell selection is a bug in Excel 2007. The zoom-changing appears to fix it. I don't have 2007 but many postings have made the suggestion and it seems to work. Gord On Thu, 9 Oct 2008 12:57:02 -0700, Joe Palazzo wrote: I am using Exel 2007. I'll try it, but can you tell me why you think that zoom would matter in this instance? "Gord Dibben" wrote: Joe If using Excel 2007, try setting the Zoom a little lower. Gord Dibben MS Excel MVP On Thu, 9 Oct 2008 11:48:05 -0700, Joe Palazzo wrote: That's what I tried. I thought that I may have corrupted it in some way, so I tried copying a section at a time to a blank worksheet and tested the new worksheet along the way. Everything copied and the problem is gone on the new worksheet. I am still mystified, though -- never have seen anything like this. Thanks, Joe "Daniel.C" wrote: Maybe, the workbook is corrupted. Try to copy yours sheets to a new workbook. Daniel "Joe Palazzo" a écrit dans le message de news: ... No, just a simple spreadsheet. The most complicated function is SUM. I was copying cells with Ctrl-c and pasting with Ctrl-v when this change took place. I may have changed some default select function, but I can't find any way to change it back. "Daniel.C" wrote: Any macro ? Regards. Daniel "Joe Palazzo" a écrit dans le message de news: ... All of a sudden, when selecting a single cell, three are selected. This is a problem on the spreadsheet that I have been using and not on others. Apparently, I created this option on this spreadsheet only. How can I change it back and select only one cell at a time? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple selection from and into validated cell. | Excel Discussion (Misc queries) | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
Multiple cell selection | Excel Discussion (Misc queries) | |||
Excel-can't turn off multiple cell selection or add text/numbers | Excel Discussion (Misc queries) | |||
limit cell list selection based on the selection of another list | Excel Worksheet Functions |