Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unable to select cell
Hello, I have a weird one. I have set up a multiple sheet workbook that uses the first worksheet to retrieve values from the other sheets. When I attempt to edit a link I am unable to click on any values within certain areas of the other worksheets. The areas that will not allow me to click show the arrow cursor and those areas where I can click show a cross (wide plus sign). I am able to manually enter the cell references and the link will work. There is no protection on the cells or worksheet/workbook, the EXT is not showing in the lower right corner (extension is off). The problem started when I cut and pasted portions of the workbook in an effort to create small information grids. If anyone can point me in the right direction so that I can remove whatever is blocking those cells it would make my job of creating this spreadsheet for my boss almost bearable. Thanks -- dbjk ------------------------------------------------------------------------ dbjk's Profile: http://www.excelforum.com/member.php...o&userid=26078 View this thread: http://www.excelforum.com/showthread...hreadid=573003 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unable to select cell
It kind of sounds like you have some sort of shape over those cells that you
can't select. Edit|goto|special|check objects And tab through all the shapes. (Hit the delete key if you want to delete the selected shape.) (Just a guess, though.) dbjk wrote: Hello, I have a weird one. I have set up a multiple sheet workbook that uses the first worksheet to retrieve values from the other sheets. When I attempt to edit a link I am unable to click on any values within certain areas of the other worksheets. The areas that will not allow me to click show the arrow cursor and those areas where I can click show a cross (wide plus sign). I am able to manually enter the cell references and the link will work. There is no protection on the cells or worksheet/workbook, the EXT is not showing in the lower right corner (extension is off). The problem started when I cut and pasted portions of the workbook in an effort to create small information grids. If anyone can point me in the right direction so that I can remove whatever is blocking those cells it would make my job of creating this spreadsheet for my boss almost bearable. Thanks -- dbjk ------------------------------------------------------------------------ dbjk's Profile: http://www.excelforum.com/member.php...o&userid=26078 View this thread: http://www.excelforum.com/showthread...hreadid=573003 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unable to select cell
You're a genius. It was the Box and Shadow I placed around the data to make it look pretty. I removed the box and now everything is back to normal. Thanks:) :) :) -- dbjk ------------------------------------------------------------------------ dbjk's Profile: http://www.excelforum.com/member.php...o&userid=26078 View this thread: http://www.excelforum.com/showthread...hreadid=573003 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unable to select cell
Woohoo!
dbjk wrote: You're a genius. It was the Box and Shadow I placed around the data to make it look pretty. I removed the box and now everything is back to normal. Thanks:) :) :) -- dbjk ------------------------------------------------------------------------ dbjk's Profile: http://www.excelforum.com/member.php...o&userid=26078 View this thread: http://www.excelforum.com/showthread...hreadid=573003 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to point to (select) a cell to the left from a cell where I enter the = equal sign? | Excel Discussion (Misc queries) | |||
select a cell and the one next to it | Excel Discussion (Misc queries) | |||
copying cell names | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Unable to set the active cell from VBA | New Users to Excel |