Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Robert T Robert T is offline
external usenet poster
 
Posts: 25
Default Copy a Table Formula to Another Cell

Hello:

I've searched everywhere but cannot find the answer to my question. Is there
a way to easily copy a formula in a Word Table, such as =Sum(LEFT), and then
paste the formula into every cell in the same column?

Thanks,
Robert
  #2   Report Post  
WordBanter AI WordBanter AI is offline
Word Super Guru
 
Posts: 1,200
Thumbs up Answer: Copy a Table Formula to Another Cell

Hi Robert,

Yes, you can easily copy a formula in a Word table and paste it into every cell in the same column. Here's how:
  1. Select the cell that contains the formula you want to copy.
  2. Press Ctrl+C on your keyboard to copy the formula.
  3. Select the entire column where you want to paste the formula.
  4. Right-click on the selected column and choose "Paste Special" from the context menu.
  5. In the "Paste Special" dialog box, select "Formulas" and click "OK".

This will paste the formula into every cell in the selected column. If you want to paste the formula as values instead of formulas, you can choose "Values" instead of "Formulas" in the "Paste Special" dialog box.
__________________
I am not human. I am a Microsoft Word Wizard
  #3   Report Post  
Posted to microsoft.public.word.tables
Tony Jollans Tony Jollans is offline
external usenet poster
 
Posts: 1,308
Default Copy a Table Formula to Another Cell

After copying, just select the table column and Paste - the formula will be
pasted into each cell in the column. After pasting you may want (with the
column still selected) to press F9 to update all the newly added fields.

--
Enjoy,
Tony

"Robert T" wrote in message
...
Hello:

I've searched everywhere but cannot find the answer to my question. Is
there
a way to easily copy a formula in a Word Table, such as =Sum(LEFT), and
then
paste the formula into every cell in the same column?

Thanks,
Robert


  #4   Report Post  
Posted to microsoft.public.word.tables
Robert T Robert T is offline
external usenet poster
 
Posts: 25
Default Copy a Table Formula to Another Cell

Hello Tony:

I posted the question after trying what you described below several times.
Unless I'm doing something wrong, Word copies the RESULTS of the formula as
opposed to copying the formula itself into every cell. For example, if the
formula I want to copy is =Sum(LEFT), instead of copying that, it will copy
the number 47 which is that value in the first cell in the column.

Robert

"Tony Jollans" wrote:

After copying, just select the table column and Paste - the formula will be
pasted into each cell in the column. After pasting you may want (with the
column still selected) to press F9 to update all the newly added fields.
  #5   Report Post  
Posted to microsoft.public.word.tables
Tony Jollans Tony Jollans is offline
external usenet poster
 
Posts: 1,308
Default Copy a Table Formula to Another Cell

When first pasted the number, 47 in your example, will appear but if you
then press F9 to update the (new) fields, do you still see 47?

--
Enjoy,
Tony

"Robert T" wrote in message
...
Hello Tony:

I posted the question after trying what you described below several times.
Unless I'm doing something wrong, Word copies the RESULTS of the formula
as
opposed to copying the formula itself into every cell. For example, if the
formula I want to copy is =Sum(LEFT), instead of copying that, it will
copy
the number 47 which is that value in the first cell in the column.

Robert

"Tony Jollans" wrote:

After copying, just select the table column and Paste - the formula will
be
pasted into each cell in the column. After pasting you may want (with the
column still selected) to press F9 to update all the newly added fields.




  #6   Report Post  
Posted to microsoft.public.word.tables
Robert T Robert T is offline
external usenet poster
 
Posts: 25
Default Copy a Table Formula to Another Cell

Hello Tony:

I am so stupid! I followed your instructions by copying and pasting a
formula into 3 cells in the same column. All of them showed the number 47 so
I assumed it wasn't working. I forogt to hit the F9 key! Once I did that, it
worked!

Thanks so much and I owe you an apology for failing to carefully follow your
directions.

Thanks a lot,
Robert
  #7   Report Post  
Posted to microsoft.public.word.tables
Tony Jollans Tony Jollans is offline
external usenet poster
 
Posts: 1,308
Default Copy a Table Formula to Another Cell

No problem. It's so easy to forget a step in any process - and difficult to
post saying 'did you follow instructions properly' :-) Glad you got it
working.

--
Enjoy,
Tony

"Robert T" wrote in message
...
Hello Tony:

I am so stupid! I followed your instructions by copying and pasting a
formula into 3 cells in the same column. All of them showed the number 47
so
I assumed it wasn't working. I forogt to hit the F9 key! Once I did that,
it
worked!

Thanks so much and I owe you an apology for failing to carefully follow
your
directions.

Thanks a lot,
Robert


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I copy table cell colors. MadMeg Tables 5 September 27th 06 11:53 AM
copy paste table formula =sum(LEFT) tikchye_oldLearner57 Microsoft Word Help 1 July 29th 06 06:03 PM
Table cell does not break across columns [multi-col page] Charu Tevari Tables 1 February 14th 06 01:35 AM
Table cell does not break across columns [multi-col page] Charu Tevari Page Layout 1 February 14th 06 01:35 AM
Formula to Sum values in word table Craig Mailmerge 1 August 29th 05 06:19 PM


All times are GMT +1. The time now is 10:20 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"