W
windyhill
We're using Excel to document technical issues regarding our biz processes.
Right now there are 50 rows of issue records. One of the columns is called
'Update' where it describes the steps taken to resolve the issue. This column
is getting too long and there are columns to each side of it so it can't be
widened anymore as the spreadsheet gets printed for mgmt rpts.
Is there a way to show the 1st sentence of each Update and then have it
display on another worksheet somehow? Or otherwise make the column smaller?
(Have tried font, etc, to no avail).
Any help or ideas at all are appreciated. Am only versed in basic Excel.
Thank you.
Right now there are 50 rows of issue records. One of the columns is called
'Update' where it describes the steps taken to resolve the issue. This column
is getting too long and there are columns to each side of it so it can't be
widened anymore as the spreadsheet gets printed for mgmt rpts.
Is there a way to show the 1st sentence of each Update and then have it
display on another worksheet somehow? Or otherwise make the column smaller?
(Have tried font, etc, to no avail).
Any help or ideas at all are appreciated. Am only versed in basic Excel.
Thank you.