How to make cells shift down automatically

		Microsoft Office Forums > Microsoft Excel > Excel
How to make cells shift down automatically

FAQ

Thread Tools

Display Modes

01-18-2011, 07:29 PM

macropod

Windows 7 32bit How to make cells shift down automatically

Office 2000

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,521

Hi iffy,

So how is Excel supposed to know:
a) which cells to move; and
b) how far to move them?
Also, what happens to any formulae that reference either:
a) the cells you move; or
b) the range above the cells you move?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can you make an EDITABLE text box that will automatically duplicate on each page in W	dha3	Word	0	08-05-2010 07:17 PM
How can I change the colors of cells automatically based on Job Completion?	Learner7	Excel	0	07-06-2010 10:47 PM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM
format cells to automatically place quotes around text	dirtleg	Excel	1	09-16-2008 01:52 PM
Automatically entering/fill data in cells in Excel 2003	dipdog	Excel	0	08-17-2006 08:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:29 PM.