Freepages-Help-L Archives
Archiver > Freepages-Help > 2010-10 > 1287329593
From: Kabe <>
Subject: Re: [FreeHelp] Test to group (was Excel auto numbering,etc.)
Date: Sun, 17 Oct 2010 08:33:13 -0700 (PDT)
In-Reply-To: <9BC3501405FB472FB1B951F34BF8904D@BERT>
Can you all let me know if you are receiving my posts of late? I haven't seen them coming thru, and some of yours including this one are going into my Junk/Spam Folder.
Thanks!
Kathie B.
(Also, somewhat unrelated: my son bought me some "Legacy" genealogy software for my birthday and I'd like some opinions on the product before I open it! Thanks again!)
-- On Sat, 10/16/10, Barry Carlson <> wrote:
From: Barry Carlson <>
Subject: Re: [FreeHelp] Excel to HTML - tip regarding Excel's auto numbering
To: , "Nick Reddan" <>
Date: Saturday, October 16, 2010, 5:05 AM
Nick Reddan's example of creating an HTML table format within the
spreadsheet is a good one. I've had a look at it and found that one stage
can be eliminated, and when the spreadsheet example found at:-
http://countjustonce.com/test/simple-table.html
- is opened, the formula found in cell G11 is all that is needed to copy the
table to its left. Just copy and "fill down" the desired number of rows and
the table will be copied over complete with the HTML formatting.
The additional HTML formating above and below the table contents is also
entered in column "G" using the standard format in the formula field, e.g
="<!doctype html>'" etc..
To copy the result into your text editor, just highlight, copy and paste the
contents in column "G" into your editor and save.
Thanks Nick for sharing the simplified HTML table generation method.
Barry
-------------------------------
To unsubscribe from the list, please send an email to with the word 'unsubscribe' without the quotes in the subject and the body of the message
This thread: