Excel Gone Wrong

[andy-hughes]

I have been working on a basic Excel spreadsheet, and I've pressed something and the entire layout has altered.

I had to save and close it, so how can I get it to go back to how it was please?

[Buenchico]

Perhaps you've simply got the workbook view set to something other than 'Normal'?
https://www.exceltip.com/basic-excel/view-tab.html

[andy-hughes]

Thanks Chris - I think my version of Office is older, so the info does not coincide, so I can't follow its instructions - any further advice much appreciated.

[ToraToraTora]

can you expand on what you had and what has changed.

[CrapAtCryptics]

Like most Microsoft programs if you make a mistake there is always the back button if you stop immediately but as you have saved it that option has gone. If you can give detail or maybe a screenshot if its no personal we can probably help.

[andy-hughes]

Thanks CAC - how can I attach a screenshot to show you what has gone wrong please?

[andy-hughes]

TTT - // can you expand on what you had and what has changed. //

I had a bog-standard Excel spreadsheet, and somehow I have managed to change into something entirely different - changes too complex to explain, but a visual will help when i find out how to attach one.

Thank you.

[ToraToraTora]

just take a screen shot, save into a JPG and upload to https://imgbb.com/

[Buenchico]

It would help to know which version of Excel you're using.

If you can work out how to take a screenshot on you computer, you can upload the image to here
https://imgbb.com/
(Just accept the default options. Copy the link and then paste it into a post, preferably on a separate line to anything else, here).

[andy-hughes]

Not been able to get a screenshot onto here I'm sorry.

[ToraToraTora]

are you using W10 ?

[andy-hughes]

Yes T, I am.

[ToraToraTora]

ok press the windows button+print screen, your screen will be saved in the screen shots sub folder of your pictures folder.

[andy-hughes]

I am working this on laptop, when I click on the file icon to get into pictures, it reduces the images to large thumbnails. Fed up now!

[andy-hughes]

Is there a way of saving the spreadsheet onto a flash drive, so I can put it on my desktop, where i am sure I can screenshot it?

[Buenchico]

If, as I suspect, you've simply got an incorrect 'View' setting applied in Excel on your laptop, the spreadsheet should open normally anyway when you open it in Excel (with a 'Normal' setting) on your desktop. i.e. there's probably nothing at all wrong with the spreadsheet file itself; it's only the way that you've told Excel to display it that's causing the problem.

However you can copy the spreadsheet file across to your desktop via a flash drive, and then open it, just as you would with any other file. i.e. open two windows side-by-side on your laptop, with one displaying the contents of the folder where the spreadsheet resides and the other showing the contents of the flash drive. Drag-&-drop the file from the former to the latter. Transfer the flash drive to your desktop, navigate to its contensts and double-click on the file.

[andy-hughes]

Hi Chris

I've got it onto my desktop, and I have pressed every button I can see under the View tab, but nothing changes it.

[ToraToraTora]

the problem is that if I was there with you I'd fix it in seconds but we cannot see what the problem is unless you show us. Now you have the sheet opened have you tried the screen shot as above?

[andy-hughes]

Hi TT - I have clicked the Print Screen, but i can't find the image in Pictures - how would I locate it please?

[ToraToraTora]

did you do windows key+print screen? assuming you did. Go to where you normally store documents in windows explorer, then go up one level by clicking on the bar at the top that shows you the folder you are in, eg: something like this : computer-> local disk(c:)-->users--Andy-->my documents. EG if you are in "my documents" click "Andy" to go up a level, then in that level you should see a list of folders, one of them should be "pictures" click on that and then you should have a sub folder of "screen shots" - ps I am actually using W7 on this machine so the actual wording may be different but the structure should be the same.

[andy-hughes]

Hi TT - found it - now what do I do please?