How to fix a cell in Excel when dragging

Ive seen this when the options get messed up... try this...:1 Click File > Options.2 In the Advanced category, under Editing options, select or clear the Enable fill handle and

How to fix a cell in Excel when dragging

Ive seen this when the options get messed up... try this...
:
1 Click File > Options.
2 In the Advanced category, under Editing options, select or clear the Enable fill handle and cell drag-and-drop check box.

See if its checked. If it is. Uncheck it. Save the settings. Close excel. Then go back in and re check the box. Close excel and retry your doc again.

If its unchecked, check it to turn the options on then try your document again.Was this post helpful? thumb_up thumb_down

Video liên quan