Cannot edit worksheet around chart - not protected

Roseus

Board Regular
Joined
Dec 20, 2010
Messages
87
I have a work file with a chart on the third tab. The chart floats in the middle of the page, and there appears to be nothing around it. No cells, nothing. Just empty, gray space - like the background of Excel, if you minimize the worksheet, but not the program.

The sheet is not protected. The document is not protected.

I can edit the chart, but I cannot move it. I can't scroll (the scroll bars are there, but they fill the entite bar. There's nothing to scroll down to).

Under View, the view gridlines, headings, and ruler options are all greyed out. So is everything under Formula, and Insert...

Anyone ever seen this? I can't figure out how they created it/locked it down like this. I want to learn for my own knowledge, and to make some changes of my own.

Any thoughts?
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Create a chart > Right Click on the Graph > Move Chart > Select New Sheet (Along with name) > OK > DONE!
 
Upvote 0

Forum statistics

Threads
1,224,595
Messages
6,179,798
Members
452,943
Latest member
Newbie4296

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top