It sounds like you're having trouble changing the print area and page breaks in your Excel 2003 worksheet. Here are a few steps you can try to resolve the issue:
- Check that the new column is included in the print area:
- Select the cells you want to include in the print area (including the new column)
- Go to File Print Area Set Print Area
- Check that the correct cells are included in the print area
- Adjust the page breaks:
- Go to View Page Break Preview
- Check that the page breaks are where you want them to be
- If they're not, click and drag the blue lines to adjust them
- If the blue lines won't move, try going to File Page Setup Sheet and unchecking "Allow spacing between cells"
- Copy and paste the data into a new file:
- Select the cells you want to copy
- Right-click and choose "Copy" or press Ctrl+C
- Open a new Excel file
- Right-click and choose "Paste" or press Ctrl+V
- If you get an error message about multiple cells, try selecting just one cell and pasting into that cell, then dragging the formula across the rest of the cells
It's possible that the file could be corrupted, especially if it was recovered from a disk defrag problem. You could try saving a copy of the file under a new name and see if that resolves the issue. If none of these steps work, you may need to seek further assistance or consider recreating the worksheet from scratch.