ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Unable to select an Excel cell (https://www.excelbanter.com/excel-worksheet-functions/125749-unable-select-excel-cell.html)

Kevin

Unable to select an Excel cell
 
I am required to use a spreadsheet designed by someone else, and there is one
cell that I cannot select, which means I cannot enter any data in that spot.
How can I select such an unselectable cell?

Don Guillett

Unable to select an Excel cell
 
Perhaps you need to ask the author to change it.

--
Don Guillett
SalesAid Software

"Kevin" wrote in message
...
I am required to use a spreadsheet designed by someone else, and there is
one
cell that I cannot select, which means I cannot enter any data in that
spot.
How can I select such an unselectable cell?




Gord Dibben

Unable to select an Excel cell
 
Kevin

Sounds like the sheet is protected and that one cell is locked and when
protecting the sheet the designer unchecked "select locked cells".

ToolsProtectionUnprotect sheet.

You may have to supply a password if that's the case.


Gord Dibben MS Excel MVP

On Thu, 11 Jan 2007 06:53:00 -0800, Kevin
wrote:

I am required to use a spreadsheet designed by someone else, and there is one
cell that I cannot select, which means I cannot enter any data in that spot.
How can I select such an unselectable cell?




All times are GMT +1. The time now is 01:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com