ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Saving worksheet so that merge cells work in previous versions (https://www.excelbanter.com/excel-worksheet-functions/61834-saving-worksheet-so-merge-cells-work-previous-versions.html)

jimmylightning

Saving worksheet so that merge cells work in previous versions
 
When I create a worksheet, and use merge cells, then send it someone who
opens it in a previous version of Excel, the merge cells is lost.

What is the best way to handle this?

TIA.

Dave Peterson

Saving worksheet so that merge cells work in previous versions
 
Don't use merged cells.

In fact, I would think that the best way to handle it is to develop your
workbooks in the oldest version of excel that will be used. Then you'll know
for sure that you didn't use something that isn't available to all.



jimmylightning wrote:

When I create a worksheet, and use merge cells, then send it someone who
opens it in a previous version of Excel, the merge cells is lost.

What is the best way to handle this?

TIA.


--

Dave Peterson


All times are GMT +1. The time now is 03:08 AM.

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