Excel sheet to another popup into picture mode

Asked By Sawrav_saw 0 points N/A Posted on - 12/28/2011

When I cut, copy, paste data from one excel sheet to another it popup into picture mode and lock the data. (XP Office 2003). When I put this data into the Excel 2007 I can eligible to cut, copy and paste data.

How I can turn off the picture mode?

• Status: Open
• Question Views: 1129
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Thompson Locker

Go To Solution

Answered By Parker tech 0 points N/A #93636

Excel sheet to another popup into picture mode

Hello,

When you protect a worksheet, all cells are locked by default, which means that they cannot be edited.

Open Excel > Tools > Options >

In General Tab, uncheck the box where the sentence starts as "Automatically Drawing."

Now close Excel and reopen your files.

Hopefully it will work for you.

Thanks,

About Parker tech

Questions
2

Answers
8

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 12/31/2011
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Thompson Locker 10 points N/A #93637

Excel sheet to another popup into picture mode

You may be pasting the data the wrong way. You will need to observe the following while pasting the data from one excel sheet to another.

• First, you will need to make sure that you are copying only the cells that have the data, for if you copy the entire sheet including the blank cells then it may cause such a problem.
• You will also need to make sure that you are using the 'paste special' option to retain the default format of the data upon pasting it to a new sheet.
• In the new worksheet, after you have copied the data, you will go to edit and then choose paste special, or simply right click and choose paste special.

Thompson Locker.

About Thompson Locker

Questions
0

Answers
619

Best Answers
77

• Vote Up 0 Vote Down

• Posted on - 12/31/2011
• Question Category: MS Excel