Hi there
Usually when I am running these reports and I have a lot of text in a cell and I have expanded the cell to as wide and large as it can be, usually I'd only have a handful of rows with this issue in a field, my usual quick fix is to insert a row below where the large is cell is, merge each column and then I have 2 rows merged to work with and expand and this usually works (equates to too much manual effort and I feel excel would be smart enough to have a quick fix whether it be a macro or something else).
I am now looking at a report that has a similar issue with too much text and I can't expand it any further. I'm sending to a client and have been advised they wish to print it which means I need all cells and text visible.
This report has 8000 rows (waste of paper for printing I know!!).
I wondered if anyone knows of a macro to auto insert a blank row after each existing row then merge it with the one above to give the ability to expand further?
I'm not sure if any of this makes sense, but if it does to somebody and somebody knows a macro that could solve my problem please let me know!!
Any help is greatly appreciated!
Usually when I am running these reports and I have a lot of text in a cell and I have expanded the cell to as wide and large as it can be, usually I'd only have a handful of rows with this issue in a field, my usual quick fix is to insert a row below where the large is cell is, merge each column and then I have 2 rows merged to work with and expand and this usually works (equates to too much manual effort and I feel excel would be smart enough to have a quick fix whether it be a macro or something else).
I am now looking at a report that has a similar issue with too much text and I can't expand it any further. I'm sending to a client and have been advised they wish to print it which means I need all cells and text visible.
This report has 8000 rows (waste of paper for printing I know!!).
I wondered if anyone knows of a macro to auto insert a blank row after each existing row then merge it with the one above to give the ability to expand further?
I'm not sure if any of this makes sense, but if it does to somebody and somebody knows a macro that could solve my problem please let me know!!
Any help is greatly appreciated!
