| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why can i not delete cells in my workbook?
I am trying to do a monthly update on a spreadsheet that i keep. For some
reason this time it will not let me delete cells. I.e normally i would right click, select delete then select shift cells up right etc. The only option that it is giving me is delete row which i do not want to do. All other workbooks etc are working fine its just this one that seems to of gone a bit nuts. I've checked to make sure its not some been set up as shared work book which it is not and i've un-hidden all collumns and rows, now i'm stuck for ideas as to what is preventing me from doing this. Please help. Thanks Ben |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why can i not delete cells in my workbook?
Try this
Go to tools | customize | command tab | categories : edit | Commands | delete option drag it to toolbar ... On Sep 10, 5:38*am, Ben wrote: I am trying to do a monthly update on a spreadsheet that i keep. For some reason this time it will not let me delete cells. I.e normally i would right click, select delete then select shift cells up right etc. The only option that it is giving me is delete row which i do not want to do. All other workbooks etc are working fine its just this one that seems to of gone a bit nuts. I've checked to make sure its not some been set up as shared work book which it is not and i've un-hidden all collumns and rows, now i'm stuck for ideas as to what is preventing me from doing this. Please help. Thanks Ben |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why can i not delete cells in my workbook?
If there was a problem with Delete being removed it would occur on all
workbooks. -- Jim "muddan madhu" wrote in message ... Try this Go to tools | customize | command tab | categories : edit | Commands | delete option drag it to toolbar ... On Sep 10, 5:38 am, Ben wrote: I am trying to do a monthly update on a spreadsheet that i keep. For some reason this time it will not let me delete cells. I.e normally i would right click, select delete then select shift cells up right etc. The only option that it is giving me is delete row which i do not want to do. All other workbooks etc are working fine its just this one that seems to of gone a bit nuts. I've checked to make sure its not some been set up as shared work book which it is not and i've un-hidden all collumns and rows, now i'm stuck for ideas as to what is preventing me from doing this. Please help. Thanks Ben |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why can i not delete cells in my workbook?
Thanks for the responce guy's. I've managed to sort it, there was stealthy
filter on that had escaped my notice. Couldnt see the Wood for trees type scenario. Stupid boy, lol. Ben "Jim Rech" wrote: If there was a problem with Delete being removed it would occur on all workbooks. -- Jim "muddan madhu" wrote in message ... Try this Go to tools | customize | command tab | categories : edit | Commands | delete option drag it to toolbar ... On Sep 10, 5:38 am, Ben wrote: I am trying to do a monthly update on a spreadsheet that i keep. For some reason this time it will not let me delete cells. I.e normally i would right click, select delete then select shift cells up right etc. The only option that it is giving me is delete row which i do not want to do. All other workbooks etc are working fine its just this one that seems to of gone a bit nuts. I've checked to make sure its not some been set up as shared work book which it is not and i've un-hidden all collumns and rows, now i'm stuck for ideas as to what is preventing me from doing this. Please help. Thanks Ben |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete cells from one workbook to another | Excel Worksheet Functions | |||
| How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
| Manually delete cells not being used at ends of workbook | Excel Discussion (Misc queries) | |||
| how do you delete a workbook | Excel Discussion (Misc queries) | |||
| Delete contents of unprotected cells in workbook | Excel Worksheet Functions | |||
Hybrid Mode
