Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unmerge to all cells possible?
Hello,
If I have a merged cell with the value of "January", and it is a merged cell from A1-A100, can I unmerge it into all cells? Giving A1-A100 each the value of "January"? Seems like it would be simple, but I haven't found any information on this in my searches. Thanks in advance! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unmerge to all cells possible?
Hi Dan,
go to Format | cell | click on the Merge box, you will have January just in the 1st row, compy tit down to all cells as your convinience regards from Brazil Thanks for the feedback Marcelo "Dan von InfoPath" escreveu: Hello, If I have a merged cell with the value of "January", and it is a merged cell from A1-A100, can I unmerge it into all cells? Giving A1-A100 each the value of "January"? Seems like it would be simple, but I haven't found any information on this in my searches. Thanks in advance! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unmerge to all cells possible?
sorry for the mistake "copy it down"
;-) "Marcelo" escreveu: Hi Dan, go to Format | cell | click on the Merge box, you will have January just in the 1st row, compy tit down to all cells as your convinience regards from Brazil Thanks for the feedback Marcelo "Dan von InfoPath" escreveu: Hello, If I have a merged cell with the value of "January", and it is a merged cell from A1-A100, can I unmerge it into all cells? Giving A1-A100 each the value of "January"? Seems like it would be simple, but I haven't found any information on this in my searches. Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |