 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008Merge Cells Option Grayed Out
Using Excel 2007 and the Merge Cells Option is grayed out. I read the help and said this may occur if cells are within a table, but they are not. The spreadsheet is also showing SHARED, how can this be removed. Is this the problem. The spreadsheet is not on a network? In versions earlier than 2007 you could not merge cells in a shared workbook. Maybe same in 2007? Not having the ability to merge cells is a good thing. They cause no end of problems with copying, sorting, filtering, pasting, autofitting and a host of others that escape me right now but will become apparent to you as you attempt to work with merged cells. They should be avoided if at all possible. Center Across Selection can be useful in most cases. Gord Dibben MS Excel MVP >Using Excel 2007 and the Merge Cells Option is grayed out. I read the help >and said this may occur if cells are within a table, but they are not. The >spreadsheet is also showing SHARED, how can this be removed. Is this the >problem. The spreadsheet is not on a network? LOL, the world would be a better place. --JP > In versions earlier than 2007 you could not merge cells in a shared workbook. > [quoted text clipped - 11 lines] > > Gord Dibben MS Excel MVP Can't find the link right now, but you can't edit/create merged cells in a shared workbook. HTH, JP > Using Excel 2007 and the Merge Cells Option is grayed out. I read the help > and said this may occur if cells are within a table, but they are not. The > spreadsheet is also showing SHARED, how can this be removed. Is this the > problem. The spreadsheet is not on a network? How do you change the workbook to non-shared in Excel 2007 ? Thanks. Can't find the link right now, but you can't edit/create merged cells in a shared workbook. HTH, JP On Mar 18, 4:19 pm, "Al Franz" <alb...@nospam.netmation.com> wrote: > Using Excel 2007 and the Merge Cells Option is grayed out. I read the help > and said this may occur if cells are within a table, but they are not. The > spreadsheet is also showing SHARED, how can this be removed. Is this the > problem. The spreadsheet is not on a network? Here's what I found on http://tinyurl.com/3xtaqb. You would just reverse the sharing. Open your Excel workbook. On the Review tab, in the Changes group, click Share Workbook. On the Editing tab, place a check beside the option to Allow changes by more than one user at the same time. This also allows workbook merging. Click the Advanced tab and under Update Changes select Automatically every. You can use the default value of 15 minutes or change this. Click OK. HTH, JP > How do you change the workbook to non-shared in Excel 2007 ? Thanks. > [quoted text clipped - 3 lines] > HTH, > JP
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.