Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    South Carolina, USA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Row Height and 3D references

    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
    <img src=/S/help.gif border=0 alt=help width=23 height=15>

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Row Height and 3D references

    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

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Row Height and 3D references

    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.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •