Results 1 to 9 of 9
  1. #1


    Member Since
    Feb 11, 2009
    Posts
    405
    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

    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

    toMACsh's Avatar
    Member Since
    Jul 30, 2009
    Location
    Wisconsin
    Posts
    6,198
    Specs:
    Mac Mini (Late 2014) 2.6GHz Intel Core i5 Memory: 8GB 1600MHz DDR3
    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


    Member Since
    Feb 11, 2009
    Posts
    405
    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

    toMACsh's Avatar
    Member Since
    Jul 30, 2009
    Location
    Wisconsin
    Posts
    6,198
    Specs:
    Mac Mini (Late 2014) 2.6GHz Intel Core i5 Memory: 8GB 1600MHz DDR3
    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


    Member Since
    Feb 11, 2009
    Posts
    405
    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

    toMACsh's Avatar
    Member Since
    Jul 30, 2009
    Location
    Wisconsin
    Posts
    6,198
    Specs:
    Mac Mini (Late 2014) 2.6GHz Intel Core i5 Memory: 8GB 1600MHz DDR3
    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

    chscag's Avatar
    Member Since
    Jan 23, 2008
    Location
    Keller, Texas
    Posts
    49,407
    Specs:
    Late 2013 27" iMac, iPad 3, iPhone 6s+, iPhone 6+, 3 iPods, Sierra
    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

    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. Excel for Mac and Excel for Windows
    By newbimac in forum OS X - Apps and Games
    Replies: 5
    Last Post: 09-23-2015, 01:34 PM
  2. 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
  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
  •