![]() |
Spreadsheet won't let me merge cells. plse help.
I created a spreadsheet and had no problems adding rows and merging cells
until today. Now the Merge Cells button is grayed out on my toolbar, and the spreadsheet will not let me merge cells. I have hit "ENTER" to "exit the editing mode" as per the MS website, but that didn't do squat. Please help. |
Spreadsheet won't let me merge cells. plse help.
Is it protected?
************ Anne Troy www.OfficeArticles.com "carikermoon" wrote in message ... I created a spreadsheet and had no problems adding rows and merging cells until today. Now the Merge Cells button is grayed out on my toolbar, and the spreadsheet will not let me merge cells. I have hit "ENTER" to "exit the editing mode" as per the MS website, but that didn't do squat. Please help. |
Spreadsheet won't let me merge cells. plse help.
No, the sheet is not protected. It is on the network and 3 other people have
access to the folder and can therefore make changes. I did check and no one else is working in this file today (just me). "Anne Troy" wrote: Is it protected? ************ Anne Troy www.OfficeArticles.com "carikermoon" wrote in message ... I created a spreadsheet and had no problems adding rows and merging cells until today. Now the Merge Cells button is grayed out on my toolbar, and the spreadsheet will not let me merge cells. I have hit "ENTER" to "exit the editing mode" as per the MS website, but that didn't do squat. Please help. |
Spreadsheet won't let me merge cells. plse help.
If you have shared the workbook, from the tools menu, then I don't think you
can merge cells. To do so, you first have to unshare the workbook. -- Sincerely, Michael Colvin "carikermoon" wrote: No, the sheet is not protected. It is on the network and 3 other people have access to the folder and can therefore make changes. I did check and no one else is working in this file today (just me). "Anne Troy" wrote: Is it protected? ************ Anne Troy www.OfficeArticles.com "carikermoon" wrote in message ... I created a spreadsheet and had no problems adding rows and merging cells until today. Now the Merge Cells button is grayed out on my toolbar, and the spreadsheet will not let me merge cells. I have hit "ENTER" to "exit the editing mode" as per the MS website, but that didn't do squat. Please help. |
Spreadsheet won't let me merge cells. plse help.
Michael,
That did the trick! Thank you very much, Nancy "Michael" wrote: If you have shared the workbook, from the tools menu, then I don't think you can merge cells. To do so, you first have to unshare the workbook. -- Sincerely, Michael Colvin "carikermoon" wrote: No, the sheet is not protected. It is on the network and 3 other people have access to the folder and can therefore make changes. I did check and no one else is working in this file today (just me). "Anne Troy" wrote: Is it protected? ************ Anne Troy www.OfficeArticles.com "carikermoon" wrote in message ... I created a spreadsheet and had no problems adding rows and merging cells until today. Now the Merge Cells button is grayed out on my toolbar, and the spreadsheet will not let me merge cells. I have hit "ENTER" to "exit the editing mode" as per the MS website, but that didn't do squat. Please help. |
Spreadsheet won't let me merge cells. plse help.
Glad to be of help, Nancy. Thanks very much for the feed back.
-- Sincerely, Michael Colvin "carikermoon" wrote: Michael, That did the trick! Thank you very much, Nancy "Michael" wrote: If you have shared the workbook, from the tools menu, then I don't think you can merge cells. To do so, you first have to unshare the workbook. -- Sincerely, Michael Colvin "carikermoon" wrote: No, the sheet is not protected. It is on the network and 3 other people have access to the folder and can therefore make changes. I did check and no one else is working in this file today (just me). "Anne Troy" wrote: Is it protected? ************ Anne Troy www.OfficeArticles.com "carikermoon" wrote in message ... I created a spreadsheet and had no problems adding rows and merging cells until today. Now the Merge Cells button is grayed out on my toolbar, and the spreadsheet will not let me merge cells. I have hit "ENTER" to "exit the editing mode" as per the MS website, but that didn't do squat. Please help. |
All times are GMT +1. The time now is 04:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com