PC Review


Reply
Thread Tools Rate Thread

Duplicating a Table

 
 
wolf_tracks@invalid.com
Guest
Posts: n/a
 
      7th Apr 2010
I have a simple table filled with data. I would like to duplicate (#
rows & columns, and the width of columns) the table w/o the data. Word
2007. How is that done?

--
Wayne Watson (Watson Adventures, Prop., Nevada City, CA)

(121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time)
Obz Site: 39° 15' 7" N, 121° 2' 32" W, 2700 feet



Web Page: <www.speckledwithstars.net/>

 
Reply With Quote
 
 
 
 
Suzanne S. Barnhill
Guest
Posts: n/a
 
      7th Apr 2010
Copy/paste the table. Make sure it is not set to automatically resize to fit
contents. Then delete the contents. This should preserve the number of rows
and columns and the widths of the columns. It will *not* preserve the row
height. If you need to do that (for printing only, to create a blank form),
you can instead change the font color to white). Otherwise you'll have to
manually adjust the row height for each row, which is easier said than done.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

<(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
>I have a simple table filled with data. I would like to duplicate (# rows &
>columns, and the width of columns) the table w/o the data. Word 2007. How
>is that done?
>
> --
> Wayne Watson (Watson Adventures, Prop., Nevada City, CA)
>
> (121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time)
> Obz Site: 39° 15' 7" N, 121° 2' 32" W, 2700 feet
>
>
>
> Web Page: <www.speckledwithstars.net/>
>
>


 
Reply With Quote
 
wolf_tracks@invalid.com
Guest
Posts: n/a
 
      7th Apr 2010
On 4/6/2010 9:05 PM, Suzanne S. Barnhill wrote:
> Copy/paste the table. Make sure it is not set to automatically resize to
> fit
> contents. Then delete the contents. This should preserve the number of
> rows and columns and the widths of the columns. It will *not* preserve
> the row height. If you need to do that (for printing only, to create a
> blank form), you can instead change the font color to white). Otherwise
> you'll have to manually adjust the row height for each row, which is
> easier said than done.
>

Ah, the key here is copy using the corner cross and not sweep the entire
table for a copy. It carried the contents, but that's easy to delete.
The next question, for interest only, is how to I merge the two tables?

--
Wayne Watson (Watson Adventures, Prop., Nevada City, CA)

(121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time)
Obz Site: 39° 15' 7" N, 121° 2' 32" W, 2700 feet

Solid waste produced to generate electricity per person
over a lifetime:
Nuclear power -- 2 pounds in a coke can
Fossil (coal) fuel -- 68.5 tons in six 12-ton RR cars

-- Power to Save the World, Gwyneth Cravens

Web Page: <www.speckledwithstars.net/>

 
Reply With Quote
 
Terry Farrell
Guest
Posts: n/a
 
      7th Apr 2010
Providing the tables have identical columns (both the number and width of
the columns), removing the break between the tables will merge them into a
single table. If any of the columns are a different width, aligning the
columns will make the tables merge.

--
Terry Farrell - MSWord MVP

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On 4/6/2010 9:05 PM, Suzanne S. Barnhill wrote:
>> Copy/paste the table. Make sure it is not set to automatically resize to
>> fit
>> contents. Then delete the contents. This should preserve the number of
>> rows and columns and the widths of the columns. It will *not* preserve
>> the row height. If you need to do that (for printing only, to create a
>> blank form), you can instead change the font color to white). Otherwise
>> you'll have to manually adjust the row height for each row, which is
>> easier said than done.
>>

> Ah, the key here is copy using the corner cross and not sweep the entire
> table for a copy. It carried the contents, but that's easy to delete. The
> next question, for interest only, is how to I merge the two tables?
>
> --
> Wayne Watson (Watson Adventures, Prop., Nevada City, CA)
>
> (121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time)
> Obz Site: 39° 15' 7" N, 121° 2' 32" W, 2700 feet
>
> Solid waste produced to generate electricity per person
> over a lifetime:
> Nuclear power -- 2 pounds in a coke can
> Fossil (coal) fuel -- 68.5 tons in six 12-ton RR cars
>
> -- Power to Save the World, Gwyneth Cravens
>
> Web Page: <www.speckledwithstars.net/>
>

 
Reply With Quote
 
Suzanne S. Barnhill
Guest
Posts: n/a
 
      7th Apr 2010

As Terry says, removing the separating paragraph will merge them, but if you
just want to add rows to the end of the table, you can add a single row by
tabbing out of the last row, or you can add multiple rows by selecting the
rows (any number up to the entire table) and using Table | Insert | Rows
Below.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On 4/6/2010 9:05 PM, Suzanne S. Barnhill wrote:
>> Copy/paste the table. Make sure it is not set to automatically resize to
>> fit
>> contents. Then delete the contents. This should preserve the number of
>> rows and columns and the widths of the columns. It will *not* preserve
>> the row height. If you need to do that (for printing only, to create a
>> blank form), you can instead change the font color to white). Otherwise
>> you'll have to manually adjust the row height for each row, which is
>> easier said than done.
>>

> Ah, the key here is copy using the corner cross and not sweep the entire
> table for a copy. It carried the contents, but that's easy to delete. The
> next question, for interest only, is how to I merge the two tables?
>
> --
> Wayne Watson (Watson Adventures, Prop., Nevada City, CA)
>
> (121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time)
> Obz Site: 39° 15' 7" N, 121° 2' 32" W, 2700 feet
>
> Solid waste produced to generate electricity per person
> over a lifetime:
> Nuclear power -- 2 pounds in a coke can
> Fossil (coal) fuel -- 68.5 tons in six 12-ton RR cars
>
> -- Power to Save the World, Gwyneth Cravens
>
> Web Page: <www.speckledwithstars.net/>
>
>


 
Reply With Quote
 
bj
Guest
Posts: n/a
 
      7th Apr 2010
I add one row to the end, then just F4 as many times as necessary.

Approx. monthly I have to enlarge an ongoing table after deleting the
obselete rows (one by one as I process other information). I find this
method easier than clearing contents, re-sorting, etc. I'm adding different
numbers of rows each time.
bj

"Suzanne S. Barnhill" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> As Terry says, removing the separating paragraph will merge them, but if
> you just want to add rows to the end of the table, you can add a single
> row by tabbing out of the last row, or you can add multiple rows by
> selecting the rows (any number up to the entire table) and using Table |
> Insert | Rows Below.
>
> --
> Suzanne S. Barnhill
> Microsoft MVP (Word)
> Words into Type
> Fairhope, Alabama USA
> http://word.mvps.org
>
> <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> On 4/6/2010 9:05 PM, Suzanne S. Barnhill wrote:
>>> Copy/paste the table. Make sure it is not set to automatically resize to
>>> fit
>>> contents. Then delete the contents. This should preserve the number of
>>> rows and columns and the widths of the columns. It will *not* preserve
>>> the row height. If you need to do that (for printing only, to create a
>>> blank form), you can instead change the font color to white). Otherwise
>>> you'll have to manually adjust the row height for each row, which is
>>> easier said than done.
>>>

>> Ah, the key here is copy using the corner cross and not sweep the entire
>> table for a copy. It carried the contents, but that's easy to delete. The
>> next question, for interest only, is how to I merge the two tables?
>>



 
Reply With Quote
 
Suzanne S. Barnhill
Guest
Posts: n/a
 
      7th Apr 2010

I add a row, F4, select the two rows, F4, select the four rows, F4, etc.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"bj" <(E-Mail Removed)> wrote in message
news:O$(E-Mail Removed)...
>I add one row to the end, then just F4 as many times as necessary.
>
> Approx. monthly I have to enlarge an ongoing table after deleting the
> obselete rows (one by one as I process other information). I find this
> method easier than clearing contents, re-sorting, etc. I'm adding
> different numbers of rows each time.
> bj
>
> "Suzanne S. Barnhill" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> As Terry says, removing the separating paragraph will merge them, but if
>> you just want to add rows to the end of the table, you can add a single
>> row by tabbing out of the last row, or you can add multiple rows by
>> selecting the rows (any number up to the entire table) and using Table |
>> Insert | Rows Below.
>>
>> --
>> Suzanne S. Barnhill
>> Microsoft MVP (Word)
>> Words into Type
>> Fairhope, Alabama USA
>> http://word.mvps.org
>>
>> <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> On 4/6/2010 9:05 PM, Suzanne S. Barnhill wrote:
>>>> Copy/paste the table. Make sure it is not set to automatically resize
>>>> to
>>>> fit
>>>> contents. Then delete the contents. This should preserve the number of
>>>> rows and columns and the widths of the columns. It will *not* preserve
>>>> the row height. If you need to do that (for printing only, to create a
>>>> blank form), you can instead change the font color to white). Otherwise
>>>> you'll have to manually adjust the row height for each row, which is
>>>> easier said than done.
>>>>
>>> Ah, the key here is copy using the corner cross and not sweep the entire
>>> table for a copy. It carried the contents, but that's easy to delete.
>>> The next question, for interest only, is how to I merge the two tables?
>>>

>
>
>


 
Reply With Quote
 
wolf_tracks@invalid.com
Guest
Posts: n/a
 
      7th Apr 2010

On 4/7/2010 12:42 AM, Terry Farrell wrote:
> Providing the tables have identical columns (both the number and width
> of the columns), removing the break between the tables will merge them
> into a single table. If any of the columns are a different width,
> aligning the columns will make the tables merge.
>

Yep, that worked. Again the little + sign did the trick.

--
Wayne Watson (Watson Adventures, Prop., Nevada City, CA)

(121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time)
Obz Site: 39° 15' 7" N, 121° 2' 32" W, 2700 feet

Solid waste produced to generate electricity per person
over a lifetime:
Nuclear power -- 2 pounds in a coke can
Fossil (coal) fuel -- 68.5 tons in six 12-ton RR cars

-- Power to Save the World, Gwyneth Cravens

Web Page: <www.speckledwithstars.net/>

 
Reply With Quote
 
wolf_tracks@invalid.com
Guest
Posts: n/a
 
      7th Apr 2010
On 4/7/2010 7:41 AM, Suzanne S. Barnhill wrote:
> I add a row, F4, select the two rows, F4, select the four rows, F4, etc.
>

Good to know about F4. I guess its primary use is for adding rows.

--
Wayne Watson (Watson Adventures, Prop., Nevada City, CA)

(121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time)
Obz Site: 39° 15' 7" N, 121° 2' 32" W, 2700 feet

Solid waste produced to generate electricity per person
over a lifetime:
Nuclear power -- 2 pounds in a coke can
Fossil (coal) fuel -- 68.5 tons in six 12-ton RR cars

-- Power to Save the World, Gwyneth Cravens

Web Page: <www.speckledwithstars.net/>

 
Reply With Quote
 
bj
Guest
Posts: n/a
 
      7th Apr 2010
<(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> On 4/7/2010 7:41 AM, Suzanne S. Barnhill wrote:
>> I add a row, F4, select the two rows, F4, select the four rows, F4, etc.
>>


That's too complicated for adding just 10-20 rows. :-)

> Good to know about F4. I guess its primary use is for adding rows.
>


F4 is the "repeat" button.
Very handy for lots of things.
bj


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Duplicating records from one table to itself Goldar Microsoft Access Form Coding 1 27th Feb 2010 02:13 AM
Re: duplicating data to a different table Gina Whipp Microsoft Access Forms 4 13th Aug 2009 12:46 AM
Duplicating one Field from One table to Another Uni Microsoft Access Form Coding 5 20th Feb 2008 03:30 PM
Linking table without duplicating PK accessuser via AccessMonster.com Microsoft Access Database Table Design 3 20th Dec 2006 10:11 AM
RE: Duplicating a table John Microsoft Access ADP SQL Server 4 13th Feb 2004 01:02 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:00 PM.