Copy Table WITH Formatting to paste in Excel.. - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Baseball Leftovers

Copy Table WITH Formatting to paste in Excel..

Moderator: Baseball Moderators

Copy Table WITH Formatting to paste in Excel..

Postby justinA » Tue Mar 14, 2006 4:04 pm

Help please. I am simply trying to copy Sport Fanatics' tables into Excel keeping the same cell alignment and what not. At the computer at my school, I did it just fine. A simple select and then copy and paste. But now, on my computer, it only will paste it into one cell.

Here's an example for you to help me with: http://www.sportfanatics.net/Baseball/F ... t_Base.htm

Thanks
The Oreos!
justinA
Major League Manager
Major League Manager

User avatar

Posts: 1013
Joined: 9 Jun 2003
Home Cafe: Baseball

Postby ukrneal » Tue Mar 14, 2006 4:07 pm

Try Paste Special. Pick one of the text alternatives and see if that works.
ukrneal
General Manager
General Manager


Posts: 2322
Joined: 29 Jan 2004
Home Cafe: Baseball

Postby justinA » Tue Mar 14, 2006 4:19 pm

ukrneal wrote:Try Paste Special. Pick one of the text alternatives and see if that works.

It works sort of.. Unicode results in all the data in the right cells, but it doesn't look as nice as what I got from at school. What setting could result in such a difference? Browser type? That could be it! I use IE at school but Firefox at home.
The Oreos!
justinA
Major League Manager
Major League Manager

User avatar

Posts: 1013
Joined: 9 Jun 2003
Home Cafe: Baseball

Postby justinA » Tue Mar 14, 2006 4:25 pm

Yup. Browser was the problem. How weird.
The Oreos!
justinA
Major League Manager
Major League Manager

User avatar

Posts: 1013
Joined: 9 Jun 2003
Home Cafe: Baseball

Postby Amazinz » Tue Mar 14, 2006 4:26 pm

Yes the difference is the browser. You could just use IE or just use a web query and then format it however you wish.
Image
Maine has a good swing for a pitcher but on anything that moves, he has no chance. And if it's a fastball, it has to be up in the zone. Basically, the pitcher has to hit his bat. - Mike Pelfrey
Amazinz
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeWeb SupporterPick 3 Weekly WinnerSweet 16 SurvivorLucky Ladders Weekly Winner
Posts: 18800
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters


Return to Baseball Leftovers

Who is online

Users browsing this forum: apz, GiantsFan14, NZ Eff, Pogotheostrich and 12 guests

Forums Articles & Tips Sleepers Rankings Leagues


Today's Games
Thursday, Apr. 17
(All times are EST, weather icons show forecast for game time)

Atlanta at Philadelphia
(1:05 pm)
Cleveland at Detroit
(1:08 pm)
Toronto at Minnesota
(1:10 pm)
Seattle at Texas
(2:05 pm)
LA Dodgers at San Francisco
(3:45 pm)
Colorado at San Diego
(6:40 pm)
Milwaukee at Pittsburgh
(7:05 pm)
St. Louis at Washington
(7:05 pm)
NY Yankees at Tampa Bay
(7:10 pm)
indoors
Boston at Chi White Sox
(8:10 pm)
Kansas City at Houston
(8:10 pm)

  • Fantasy Baseball
  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact