| 0 |
Subject: Posting Excel Info
Posted by: ukula
- [57534297] Tue, Jun 29, 2004, 08:47
I'm trying to post some Excel data onto the Rotoguru forum but my formatting is lost when I do a simple copy/paste. How do I retain the formatting? |
| 1 | Trip
Donor
ID: 13961611
Tue, Jun 29, 2004, 09:10
|
There may be an easier way, but this is how I do it.
1 - Save the file as a web page.
2 - Open the web page, select view > source
3 - Copy and paste the data into your post, making sure you select Yes on the ignore line feeds button.
|
| 2 | Guru
ID: 330592710
Tue, Jun 29, 2004, 09:23
|
When you save as a web page, choose to save only the cell area that you want to reproduce, and not the entire sheet. Otherwise, you may get a bunch of blank columns (situated to the right of the table) which force the forum page to widen unnecessarily.
|
| 3 | ukula
ID: 57534297
Tue, Jun 29, 2004, 09:27
|
I don't see "web page" as an option when I save the file in Excel (Excel 97). It IS an option in Word however. Any thoughts?
|
| 4 | Mike D
Sustainer
ID: 41831612
Tue, Jun 29, 2004, 09:32
|
Is HTML an option?
|
| 5 | ukula
ID: 57534297
Tue, Jun 29, 2004, 09:34
|
only in Word
|
| 6 | Guru
ID: 330592710
Tue, Jun 29, 2004, 09:37
|
You're right, "Save as web page" is an option in Excel 2000 and later versions, but not Excel 97.
Perhaps you can paste the Excel area into a Word document and then save as a web page from Word? Then you'd need to copy the html source (step 2 above), etc.
|
| 7 | Mike D
Sustainer
ID: 41831612
Tue, Jun 29, 2004, 09:44
|
That's what I used to do when I ran '97.
|
| 8 | ukula
ID: 57534297
Tue, Jun 29, 2004, 09:47
|
a
|
| 9 | ukula
ID: 57534297
Tue, Jun 29, 2004, 09:48
|
It worked but....why the big space before the table?
|
| 10 | Guru
ID: 330592710
Tue, Jun 29, 2004, 10:02
|
Did you select the yes button for "ignore line feeds"? If not, that will probably solve the problem.
If so, then Word inserted a bunch of blank lines, in all likelihood. You should try to find only the section of html code that you want to include, and paste only that.
|
| 11 | ukula
ID: 57534297
Tue, Jun 29, 2004, 10:23
|
a
|
| 12 | ukula
ID: 57534297
Tue, Jun 29, 2004, 10:23
|
Beautiful. Thanks Guys.
|
| 13 | Mike D
Sustainer
ID: 41831612
Tue, Jun 29, 2004, 10:29
|
Don't forget to customize it while in Excel. Colors, fonts, etc........prior to doing all the rest.
|
| 14 | J
Leader
ID: 49346417
Tue, Jun 29, 2004, 10:31
|
I think its beautiful the way it is. As does ukula.
|
| 15 | Mike D
Sustainer
ID: 41831612
Tue, Jun 29, 2004, 10:42
|
It's certainly innately beautiful. Beautiful in its own way.
But in the rare event people wanted something that did not put them to sleep, color is an option.
(LMAO)
|
| 16 | MadDOG
ID: 37552296
Tue, Jun 29, 2004, 11:17
|
Why is that "C" way over to the left?
|
| 17 | Mike D
Sustainer
ID: 41831612
Tue, Jun 29, 2004, 11:38
|
Um....it must be your monitor??? ;)
|
| 18 | Guru
ID: 330592710
Tue, Jun 29, 2004, 11:39
|
BTW, if anyone wants to test this out, the test forum is the preferred place to do that.
|
|
|
|
Post a reply to this message: (But first, how about checking out this sponsor?)
|