Hi,
I have a report which produces information about orders. At the bottom I have a comments section - a cell that they can type into before they print. I managed to unprotect the cell so that they could type in it. However, I am having trouble getting the cell to expand - at the moment the cell is only one line, but the comments may be bigger - if they go over one line the go on to the next line (word wrap) but the cell does not expand so they are hidden.
Any help would be appreciated.
Regards,
Teresa
Date
Votes
3 comments
-
Jet Reports Historic Posts Hey Teresa,
Do you mean you want the cell to expand vertically based on the amount of text in the cell? It sounds like you need to turn wordwrap on for the cell. You can do this by right clicking on the cell and select Format Cell. Then click on the Alignment tab. In here you should see a check box called "Wrap Text". Turn this on. You cell will now automactically expand vertically based on the text.
Let us know if this works for you. -
Jet Reports Historic Posts Hi,
Word wrap is on. When you enter more text than fits in the cell, it goes on to the next line. However, you can't see it once you exit the cell as the cell height seems to be locked. It doesn't expand automatically and you can't adjust it manually.
Thanks,
Teresa -
Jet Reports Historic Posts Hi Teresa,
Are you using Auto+Hide+Lock in cell A1 of the worksheet? If so, can you try Auto+Hide+Values instead? Let me know if this works for you. I suspect that you are using +Lock and the worksheet is locked. I think when you lock a worksheet in Excel, even if you unprotect the cells, you can't change the cell dimensions. Using +Values doesn't lock the worksheet, but does allow the report to be run by viewers.
Please sign in to leave a comment.