ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Unmerge to all cells possible? (https://www.excelbanter.com/excel-worksheet-functions/91360-unmerge-all-cells-possible.html)

Dan von InfoPath

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!

Marcelo

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!


Marcelo

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!



All times are GMT +1. The time now is 08:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com