Results 1 to 9 of 9
  1. #1
    Copying table into MS Excel for Mac

    Member Since
    Feb 11, 2009
    Posts
    403
    Copying table into MS Excel for Mac
    Switched to Mac and MS Office. In the PC version copying tables from a browser and pasting into Excel is easy, but it doesn't seem to work well in Excel for Mac.

    Here is a table I wanted to paste into Excel for Mac:
    ATA Quarterly Cost Index: U.S. Passenger Airlines

    It just didn't work so I had to use a PC.

    Anybody able to enlighten me on how I can do it in the future on a Mac?

  2. #2
    Copying table into MS Excel for Mac
    EvenStranger's Avatar
    Member Since
    Dec 09, 2010
    Location
    Virginia
    Posts
    844
    Specs:
    Currently 13" Late 2010 MBA, 4GB/128GB; Early 2011 13" MBP, dual core i7 2.7ghz, 4gb ram, 500gb hd
    Except for the headers being slightly off, it seems to have worked fine for me. The trick I think is to ignore the framework, set your cursor just before the first character you want to copy and highlight down to the last character you want. Command-C to copy, open Excel, and Command-V to paste.

  3. #3
    Copying table into MS Excel for Mac
    toMACsh's Avatar
    Member Since
    Jul 30, 2009
    Location
    Wisconsin
    Posts
    5,828
    Specs:
    Mac Mini Core 2 Duo
    Quote Originally Posted by EvenStranger View Post
    The trick I think is to ignore the framework, set your cursor just before the first character you want to copy and highlight down to the last character you want.
    Agreed. I always do that when copying. Fewer things to fix that way.

  4. #4
    Copying table into MS Excel for Mac

    Member Since
    Feb 11, 2009
    Posts
    403
    I tried to do that but when pasted into Excel the data is simply pasted into 1 cell.

    I am using Firefox 5.0.1 and Excel 12.3.0

    Edit: Well it seems that Safari works but Firefox doesn't...I guess I could have tried that earlier

  5. #5
    Copying table into MS Excel for Mac
    toMACsh's Avatar
    Member Since
    Jul 30, 2009
    Location
    Wisconsin
    Posts
    5,828
    Specs:
    Mac Mini Core 2 Duo
    That's strange. Its seem to me that it would be more a function of Excel than the browser.

    Firefox 6.0 is out. Does that run on your OS?

  6. #6
    Copying table into MS Excel for Mac

    Member Since
    Feb 11, 2009
    Posts
    403
    Thanks for reminding me about the update for Firefox.

    Just checked in Firefox 6.0 but still the same: all copied data is pasted into 1 cell in Excel.

  7. #7
    Copying table into MS Excel for Mac
    toMACsh's Avatar
    Member Since
    Jul 30, 2009
    Location
    Wisconsin
    Posts
    5,828
    Specs:
    Mac Mini Core 2 Duo
    Well, Firefox doesn't work for you. There are other browsers you could try besides Safari. Have a look at Chrome, Opera, Thunderbird...(oops!)

  8. #8
    Copying table into MS Excel for Mac
    chscag's Avatar
    Member Since
    Jan 23, 2008
    Location
    Fort Worth, Texas
    Posts
    45,190
    Specs:
    27" iMac i5, 3.2 GHz, iPad 3, iPhone 5c, iPhone 6+, 3 iPods, Yosemite
    Just a slight correction on the above.... Thunderbird is not a browser. It's an email client and newsreader. (Published by the same folks who do Firefox.)

  9. #9
    Copying table into MS Excel for Mac
    BrianLachoreVPI's Avatar
    Member Since
    Feb 24, 2011
    Location
    Maryland
    Posts
    3,733
    Specs:
    March 2011 15" MBP 2.3GHz i7 Quad Core 8GB Ram | Mid 2011 27" iMac 3.4 GHz i7 16 GB RAM 2 TB HDD
    I just gave it a shot in Safari 5.1 on SL - and while obviously no formatting comes along - cmd-V worked just fine for me. Having said that - there are definitely things in the Mac version of Excel that don't quite work the same way or as well as the Windows version. Just have to work around them.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How do I copy table table as plain text?
    By craftydad in forum Switcher Hangout
    Replies: 1
    Last Post: 01-29-2015, 02:27 PM
  2. Excel for Mac and Excel for Windows
    By newbimac in forum OS X - Apps and Games
    Replies: 2
    Last Post: 02-26-2012, 08:04 PM
  3. Way to automate copying from a website into Excel?
    By edokid in forum OS X - Apps and Games
    Replies: 0
    Last Post: 01-28-2012, 10:16 AM
  4. Pages - table within a table?
    By watfordkev in forum OS X - Apps and Games
    Replies: 0
    Last Post: 07-13-2011, 04:08 PM
  5. MAC ARP Table
    By fatlog in forum Running Windows (or anything else) on your Mac
    Replies: 2
    Last Post: 10-14-2003, 04:41 AM

Posting Permissions

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