Want to highlight a helpful answer? Upvote!

Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How can I move columns in Numbers without distorting the formula in other cells? In Excel I can cut and paste entire columns and the formula in other cells adjusts accordingly. When I do it in Numbers, the formula messes up. How can I do this?

How can I move columns in Numbers without distorting the formula in other cells? In Excel I can cut and paste entire columns and the formula in other cells adjusts accordingly. When I do it in Numbers, the formula messes up. How can I do this?

For example: I have formulas in columns D and F that relate to columns C to CU

If I want to move one column from one position to another (say S to T), the formula loses the colums that was moved, i.e. it doesn't recognize it has moved, rather sees it as deleted... How can I do this without distorting the formula?

MacBook Pro

Posted on Jan 22, 2012 4:14 AM

Reply
Question marked as Best reply

Posted on Jan 22, 2012 8:33 AM

Numbers User Guide and iWork Formulas and Functions User Guide are not designed only to help helpers to help you.

User uploaded file


Yvan KOENIG (VALLAURIS, France) dimanche 22 janvier 2012

iMac 21”5, i7, 2.8 GHz, 12 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.2

My Box account is : http://www.box.com/s/00qnssoyeq2xvc22ra4k

My iDisk is : http://public.me.com/koenigyvan

4 replies
Question marked as Best reply

Jan 22, 2012 8:33 AM in response to Svettles

Numbers User Guide and iWork Formulas and Functions User Guide are not designed only to help helpers to help you.

User uploaded file


Yvan KOENIG (VALLAURIS, France) dimanche 22 janvier 2012

iMac 21”5, i7, 2.8 GHz, 12 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.2

My Box account is : http://www.box.com/s/00qnssoyeq2xvc22ra4k

My iDisk is : http://public.me.com/koenigyvan

Jan 22, 2012 11:10 AM in response to Svettles

Thanks for the feedback.

If I often urge askers to look at the available resources, it's because a large range of questions asked in the forums are already answered in these documents.

As they are PDFs, they are easy to search in.


CAUTION

Download them while they are available.

Given what is delivered with iBooks Author, I'm afraid that we will not get such easy to use documents.

Searching infos in the iBooks Author documentation available on line is awfully cumbersome and a lot of embedded links are wrongly flagged this way. In the Help files they aren't links but underlined strings.

It seems that the tool used to generate the web pages was wrongly configured.


Yvan KOENIG (VALLAURIS, France) dimanche 22 janvier 2012

iMac 21”5, i7, 2.8 GHz, 12 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.2

My Box account is : http://www.box.com/s/00qnssoyeq2xvc22ra4k

My iDisk is : http://public.me.com/koenigyvan

How can I move columns in Numbers without distorting the formula in other cells? In Excel I can cut and paste entire columns and the formula in other cells adjusts accordingly. When I do it in Numbers, the formula messes up. How can I do this?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.