+ Reply to Thread
Results 1 to 3 of 3

blue border round data

  1. #1
    Registered User
    Join Date
    01-19-2009
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2003
    Posts
    1

    blue border round data

    Hi
    I created an address list in IrisCard Pro 4 and exported it to Excel (I am using 2003). The data shows up fine, however, there is a heavy blue border round all the columns and it seems to stop me from moving the columns around. I have checked the security and made sure it isn't locked, but the heavy blue border is still there. tx.
    L

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372
    Hi,

    Excel probably recognised that your data is a list and made it into an Excel list, which has certain features and possibilities. To remove the blue border and convert the data back into "normal" Excel cells do

    - click inside the list so you see the blue border
    - click the Menu "Data" then "List"
    - select "Convert to range"
    - click Yes

    Now your data should behave like normal and you can add and delete columns

    HTH

  3. #3
    Registered User
    Join Date
    12-16-2008
    Location
    Santa Cruz, CA
    MS-Off Ver
    Office 2003
    Posts
    3

    Re: blue border round data

    I had this same problem. Your solution worked great. Thank you, teylyn.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1