Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Splitting 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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Splitting Cells
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. -- Just a fellow Excel user here to help when I can..... "PAL" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Splitting Cells
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? "Red" wrote: 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. -- Just a fellow Excel user here to help when I can..... "PAL" wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Splitting Cells
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) -- Just a fellow Excel user here to help when I can..... "Red" wrote: 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. -- Just a fellow Excel user here to help when I can..... "PAL" wrote: 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Splitting Cells
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 On Fri, 29 Feb 2008 11:29:39 -0800, PAL wrote: 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? "Red" wrote: 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. -- Just a fellow Excel user here to help when I can..... "PAL" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
splitting cells | New Users to Excel | |||
Splitting cells | Excel Discussion (Misc queries) | |||
Splitting cells? | Excel Discussion (Misc queries) | |||
Splitting cells - please help! | Excel Worksheet Functions | |||
Splitting Cells | Excel Discussion (Misc queries) |