Resizes to Multiple pages

0

I have an excel sheet I've used for a long time with no troubles.  

Now when I go to View/Page Break View and try to move over the dotted line two columns, it resizes the whole sheet into over 400 pages.   I've taken out any headers & frozen panes.   I've reset the print area and nothing.   If I try to change the scale to fit, it tells me it can't resize to smaller than 10%.  

MS 2007 version

Any ideas what to do?

Answer
Discuss

Discussion

The below did not help.
ccrippen Jul 13, '16 at 8:46 pm
Is there anyway you can include a sample file? It would be easier to figure out the problem that way.
don (rep: 1322) Jul 13, '16 at 9:01 pm
Add to Discussion

Answers

0

It sounds like this might solve your problem:

  1. Click the Microsoft Office Button, click Excel Options, and then click the Advanced tab.
  2. Click to select the Enable fill handle and cell drag-and-drop check box, and then click OK.

I got this from the following site: MS Excel Issue

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login