Why does my spreadsheet open “scrambled”?
Hello all you wonderful experts! Thank you so much for all the help you all give me!
I’m back with more trouble… 😉
I’m using Microsoft 365 on Windows 10. I’ve created an Excel spreadsheet and it’s got some weird things going on.
I’ve set all four margins at .5.
“Scale to Fit” is set to “Automatic” for both Width and Height and 100% for “Scale”.
Part One:
When I open it in Excel, the top margin is displaying larger than .5, and row numbers 4 through 9 are “missing” (but the rows are still there because everything in those rows is present on the screen).
After I took the above screenshot and went back to the spreadsheet, the top margin was still larger than .5 but the row numbers 4 through 9 are appearing now.
I then went to File > Print and the margin is correct even though it displayed incorrectly in the above image, prior to selecting Print.
I then went back to the spreadsheet by clicking the back arrow in the Print dialogue and the margin is now displaying correctly.
This happens haphazardly but more often than not.
Part Two:
Sometimes the layout of the form itself is messed up, rows missing, lines shifted, cells appearing oddly but every time I try to get a screenshot, the form corrects itself as soon as I click on the “Snip & Sketch” icon in my taskbar (so I took a picture with my phone). Also showing are the messed up row numbers (38 and 39 showing twice).
When I scroll down and then back up on the spreadsheet that weirdness has corrected itself but row numbers are missing now (but the rows are technically still there because everything in the rows is still appearing on the screen)
Part Three:
I can enter 6 lines of text in this box and it displays fine…
But when I go to print it, it cuts off the 6th row of text.
————————
Other than Part Three where the 6th row of text is cut off when printing, everything else prints fine even though it displays oddly at times. It happens not just on my computer but on others’ computers as well.
Any idea what I can do to fix these issues?
Thank you so much!! 🙂
Hello all you wonderful experts! Thank you so much for all the help you all give me! I’m back with more trouble… 😉 I’m using Microsoft 365 on Windows 10. I’ve created an Excel spreadsheet and it’s got some weird things going on. I’ve set all four margins at .5. “Scale to Fit” is set to “Automatic” for both Width and Height and 100% for “Scale”. Part One: When I open it in Excel, the top margin is displaying larger than .5, and row numbers 4 through 9 are “missing” (but the rows are still there because everything in those rows is present on the screen). After I took the above screenshot and went back to the spreadsheet, the top margin was still larger than .5 but the row numbers 4 through 9 are appearing now. I then went to File > Print and the margin is correct even though it displayed incorrectly in the above image, prior to selecting Print. I then went back to the spreadsheet by clicking the back arrow in the Print dialogue and the margin is now displaying correctly. This happens haphazardly but more often than not. Part Two: Sometimes the layout of the form itself is messed up, rows missing, lines shifted, cells appearing oddly but every time I try to get a screenshot, the form corrects itself as soon as I click on the “Snip & Sketch” icon in my taskbar (so I took a picture with my phone). Also showing are the messed up row numbers (38 and 39 showing twice). When I scroll down and then back up on the spreadsheet that weirdness has corrected itself but row numbers are missing now (but the rows are technically still there because everything in the rows is still appearing on the screen) Part Three: I can enter 6 lines of text in this box and it displays fine… But when I go to print it, it cuts off the 6th row of text. ———————— Other than Part Three where the 6th row of text is cut off when printing, everything else prints fine even though it displays oddly at times. It happens not just on my computer but on others’ computers as well. Any idea what I can do to fix these issues? Thank you so much!! 🙂 Read More