New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
Switcher Hangout The place for switchers to discuss their new machines, and how to work with OS X. General support can be had here for newbie stuff, like "How do I restart my new iMac?" :)

Copying table into MS Excel for Mac


Post Reply New Thread Subscribe

 
Thread Tools
Trolle

 
Member Since: Feb 11, 2009
Posts: 390
Trolle is on a distinguished road

Trolle is offline
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?
QUOTE Thanks
EvenStranger

 
EvenStranger's Avatar
 
Member Since: Dec 09, 2010
Location: Virginia
Posts: 845
EvenStranger is just really niceEvenStranger is just really niceEvenStranger is just really niceEvenStranger is just really niceEvenStranger is just really nice
Mac Specs: Currently 13" Late 2010 MBA, 4GB/128GB; Early 2011 13" MBP, dual core i7 2.7ghz, 4gb ram, 500gb hd

EvenStranger is offline
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.
QUOTE Thanks
toMACsh

 
toMACsh's Avatar
 
Member Since: Jul 30, 2009
Location: Wisconsin
Posts: 5,591
toMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to all
Mac Specs: Mac Mini Core 2 Duo

toMACsh is offline
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.
QUOTE Thanks
Trolle

 
Member Since: Feb 11, 2009
Posts: 390
Trolle is on a distinguished road

Trolle is offline
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
QUOTE Thanks
toMACsh

 
toMACsh's Avatar
 
Member Since: Jul 30, 2009
Location: Wisconsin
Posts: 5,591
toMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to all
Mac Specs: Mac Mini Core 2 Duo

toMACsh is offline
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?
QUOTE Thanks
Trolle

 
Member Since: Feb 11, 2009
Posts: 390
Trolle is on a distinguished road

Trolle is offline
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.
QUOTE Thanks
toMACsh

 
toMACsh's Avatar
 
Member Since: Jul 30, 2009
Location: Wisconsin
Posts: 5,591
toMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to all
Mac Specs: Mac Mini Core 2 Duo

toMACsh is offline
Well, Firefox doesn't work for you. There are other browsers you could try besides Safari. Have a look at Chrome, Opera, Thunderbird...(oops!)
QUOTE Thanks
chscag

 
chscag's Avatar
 
Member Since: Jan 23, 2008
Location: Fort Worth, Texas
Posts: 41,366
chscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond repute
Mac Specs: 27" iMac i5, 3.2 GHz, iPad 3, iPhone 5c, 3 iPods, Yosemite

chscag is offline
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.)
QUOTE Thanks
BrianLachoreVPI

 
BrianLachoreVPI's Avatar
 
Member Since: Feb 25, 2011
Location: Maryland
Posts: 3,742
BrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant future
Mac 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

BrianLachoreVPI is offline
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.
QUOTE Thanks

Post Reply New Thread Subscribe


« iTunes Back-Up HELP! | Oh dear »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Excel 2008 and 2011 file seetim OS X - Apps and Games 2 01-27-2011 02:01 PM
Can't open big Excel workbook on MacBook Air SergeiV OS X - Apps and Games 1 06-01-2010 05:01 AM
MAC excel 08 vs PC excel 07 gcookie OS X - Apps and Games 2 05-31-2010 12:32 AM
Updating Excel document over a network? Garnon OS X - Apps and Games 3 05-26-2009 04:41 AM

All times are GMT -4. The time now is 06:45 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?