ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Inserting cell (https://www.excelbanter.com/excel-discussion-misc-queries/131128-inserting-cell.html)

Cynthia

Inserting cell
 
I cannot insert cells into my worksheet. Also data disappears when I cut and
paste cells. Not all data but random cells in the selection. Anyone know
why and how to fix this problem. I use Excel all the time and have never had
this problem.

joel

Inserting cell
 
Some cells may be protected. try highligh entire sheet by press the gray
button between A and 1, then go to tools menu under protection and unprotect
the sheet.

"Cynthia" wrote:

I cannot insert cells into my worksheet. Also data disappears when I cut and
paste cells. Not all data but random cells in the selection. Anyone know
why and how to fix this problem. I use Excel all the time and have never had
this problem.


Tom Ogilvy

Inserting cell
 
Why do you need to select the cells first? I have never had to do this to
protect and unprotect the sheet.

--
Regards,
Tom Ogilvy


"Joel" wrote in message
...
Some cells may be protected. try highligh entire sheet by press the gray
button between A and 1, then go to tools menu under protection and
unprotect
the sheet.

"Cynthia" wrote:

I cannot insert cells into my worksheet. Also data disappears when I cut
and
paste cells. Not all data but random cells in the selection. Anyone
know
why and how to fix this problem. I use Excel all the time and have never
had
this problem.





All times are GMT +1. The time now is 04:32 PM.

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