1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Problem: Excel 2007 Guru's Required

Discussion in 'Microsoft Office Specialist (MOS)' started by craigie, Jul 28, 2010.

  1. craigie

    craigie Terabyte Poster

    3,020
    173
    155
    We have a user who is using Excel 2007, and they are trying to use a Text Box with two columns.

    The issue is when text goes into the second column, you click anywhere else on the spreadsheet the information in the text box cannot be read.

    To replicate this:

    Excel > Insert > Text Box > Right Click Text Box > Format Shape > Text Box > Columns > Number = 2

    Type some blurb into the left hand column, then click any cell in spreadsheet, you can still see the text.

    Now put some text in the right hand column, then click any cell in the spreadsheet and the text is gone.

    It works without any dramas in Excel 2010, any ideas on how to fix this in Excel 2007?
     
    Certifications: CCA | CCENT | CCNA | CCNA:S | HP APC | HP ASE | ITILv3 | MCP | MCDST | MCITP: EA | MCTS:Vista | MCTS:Exch '07 | MCSA 2003 | MCSA:M 2003 | MCSA 2008 | MCSE | VCP5-DT | VCP4-DCV | VCP5-DCV | VCAP5-DCA | VCAP5-DCD | VMTSP | VTSP 4 | VTSP 5
  2. beaumontdvd

    beaumontdvd Kilobyte Poster

    487
    3
    32
    Just a guess mate but can you send the textbox behind the text? Think its called send to back or something?
     
    Certifications: 070-271, 070-272, (MCDST)Level 1,2,3 NVQ
    WIP: 070-270, A+, N+, S+,MCDST 7 Upgrade
  3. craigie

    craigie Terabyte Poster

    3,020
    173
    155
    That's the first thing I looked for mate, you don't have that option under format.
     
    Certifications: CCA | CCENT | CCNA | CCNA:S | HP APC | HP ASE | ITILv3 | MCP | MCDST | MCITP: EA | MCTS:Vista | MCTS:Exch '07 | MCSA 2003 | MCSA:M 2003 | MCSA 2008 | MCSE | VCP5-DT | VCP4-DCV | VCP5-DCV | VCAP5-DCA | VCAP5-DCD | VMTSP | VTSP 4 | VTSP 5

Share This Page

Loading...