PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

CONTENTS

CAN'T COPY FORMULA IN EXCEL

INTRODUCTION

Sometimes our software can malfunction or we may press any button or key combination by mistake which can create a lot of problem for us. So let us try to find out few solution what we can’t do if any of the problem occurs.

Here is the list of problems and their solutions.

 

FILL HANDLE OR DRAGGING HANDLE IS MISSING
OR AUTOFILL OF EXCEL NOT WORKING PROPERLY

Fill handle or dragging handle is a small “square” sign in the lower right corner of the cell selection cursor. Just have a look .

The picture is showing a dark spot at the lower right corner of the selection. This is the fill handle, which lets us drag the formula down upto the list we want. Sometimes this handle is missing. Follow the steps to get it back.

SOLUTION1

Sometime, the fill handle is missing . It maybe a bug or by chance we may press any keys. Follow these steps to make it reappear.
  1.  Go to FILE MENU.
  2.  Go to options.
  3. Go to Advanced.
  4. Third main option under the EDITING OPTIONS is ENABLE FILL HANDLE .
  5. Select it and we are done.
  6. We can use the drag handle to copy the formula again.
  7. One more option is there ALERT BEFORE OVERWRITING CELLS.
  8. This option can be checked if we want an alert before overwriting on the already filled cells.
 

SOLUTION2

If handle is there, but can’t copy.

1.Try the autofill handle and drag the data. Now you can drag it to column side or row side.

 

2. Try updating the Windows, or Excel to the latest version to set it.

3. Try the copy paste in other applications.

4. Check if all these three options are selected or not.

Go to FILE >ADVANCED>EDITING OPTIONS

SHOW, PASTE OPTIONS BUTTON WHEN CONTENT I SPASTE

SHOW INSERT OPTIONS BUTTONS

CUT, COPY AND SORT INSERTED OBJECTS WITH THEIR PARENT CELLS

 

 

 

 

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: