Jump to content

I know in excel I can set A1=12345 and anywhere else I can say cell=A1

Can I do this in word?
I have a large sheet with about an hours worth of working out, it starts with experiment data and spends many formulas getting to a final value, the issue is that my lecturer has provided many examples, all of which use different, and wrong units. As each day passes I notice something that looks wrong about the method (cm instead of m or using the wrong temperature in the wrong place)

Correcting which requires me to start from the very beginning with new starting values and REDO all the calculations. The method itself has "formulas" in word so cannot be copied into excel which would be ideal, and I dont want to copy this thing into excel manually as that would take ages.
I just want to be able to select some text in word and click>link to here and wherever I link it to, should be the value it copies?

Link to comment
https://linustechtips.com/topic/684795-ms-word-referencinglinking/
Share on other sites

Link to post
Share on other sites

I'm assuming you have a "table" in word. You should be able to copy then paste special into excel...EDIT: This doesn't work. You really should just go through and transfer everything over into excel...

 

Apparently you can push Alt F9 to reveal the field codes, which have the formulas in them. It doesn't work on my mac with a mini wireless keyboard. Some interaction of the function keys, media keys, and mac makes it not work. Linky below.

 

http://mcqsets.com/s/microsoft-word-questions-answers/copy-paste-formula-word-table/

 

Some tables in word are literally just mini excel spreadsheets which you can subsequently open in excel by right clicking. 

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×