Of course there is, You can write a simple macro to do this job for you.įor eg. Shouldn’t there be a better way to merge cells without losing data?!? It only works for cells in a single column, if the cells are spread across several columns, justify will not work.It doesnt work if the selected cells have numbers or formulas.See this simple animation aside to understand how it works.īut wait, this technique has some limitations, If you see the text spreading 2 rows, just make the column wider and repeat the process. The text from selected cells will be magically re-arranged in top-most cell.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |