 |
 | 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 / Worksheet Functions / February 2008Splitting Cells
I am working on putting together a cheat sheet. I guess you could describe it as a dashboard. I was wondering if you could combine then split cells. I would like to go from 3 cells to 2 cells. I don't want to affect the entire column as I will have a table below that needs the 3 columns. I know you can do this in a Word table. Is that the best way to do this? Thanks. You can combine cells. In your case, you'll just need to hilight the cells you want to combine, then go to Format / Cells. On the alignment tab check "Merge Cells" at the bottom and then press Ok. Those cells now have been put together. One note though, merging cells can have a negative impact when trying to use the data in a merged cell in a formula. Hope this helps.  SignatureJust a fellow Excel user here to help when I can..... > I am working on putting together a cheat sheet. I guess you could describe > it as a dashboard. I was wondering if you could combine then split cells. I [quoted text clipped - 4 lines] > > Thanks. Yes, I can do that, but if I want to adjust the width, I must do it for the entire column and for the individual cell? > You can combine cells. In your case, you'll just need to hilight the cells > you want to combine, then go to Format / Cells. On the alignment tab check [quoted text clipped - 14 lines] > > > > Thanks. Row heights and column widths are properties of the entire row and column. Be careful if you go with the "merged cells". They cause no end of problems with copying, sorting, filtering, pasting and a host of others that escape me right now. They should be avoided if at all possible. Center Across Selection can be useful in most cases. Gord Dibben MS Excel MVP >Yes, I can do that, but if I want to adjust the width, I must do it for the >entire column and for the individual cell? [quoted text clipped - 17 lines] >> > >> > Thanks. Yes that is correct. The cell width will be the same as the two original cells together. Word allows you to adjust the individual cell borders, but Excel does not (to my knowledge) SignatureJust a fellow Excel user here to help when I can..... > You can combine cells. In your case, you'll just need to hilight the cells > you want to combine, then go to Format / Cells. On the alignment tab check [quoted text clipped - 14 lines] > > > > Thanks. |
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.