Row Height and 3D references

Topic

New Reply

I have a large workbook with 5 sheets (Excel 97). I have 3D references so when I make a change to the master sheet, the information will be updated on the other sheets. I have entered information in a cell that expands the height of the row. When the information is transfered to the corresponding cells, the height is the same as before and thus hiding some of my text. I know that I can go to each sheet and increase the height but is there a global command or something to try to make it more automated??

Any suggestions are appreciated!!

Thanks,
Deborah

Reply | Quote

Replies

Try setting the wrap text to on for the cells involved. Go to Format, Cells, select the Alignment tab, and check the Wrap Text check box.

Andrew C

Reply | Quote

If the changes on all of the sheets are the same, just select all of the sheets at the same time (hold down the Ctrl key when you click on the sheet tabs or hold down shift and click to select a range of sheets). Then any changes you make on one sheet will be made on all selected sheets.

Reply | Quote