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?

[ToraToraTora]

upload the image here:
https://imgbb.com/
do not sign in or open an account, stay anonymous,follow the instructions click "start uploading" and it will display it's own version of windows explorer, find the screen shot as you did above, double click then click the upload button, once done it will display a link that you can copy, copy it and past into AB like any other link.

[Buenchico]

As I'm using Windows 7, I'm unable to check on whether TTT's suggestion will work. However I'm a bit concerned about the image format that might be used by a screenshot saved by that method. I've got a feeling that it might be something other tham .jpg (such as .png), which might not be accepted for upload to the web.

If you can't get that method to work, here's an alternative which (to the best of my knowledge) is univeral across all versions of Windows:

1. Press the Print Screen key (ON ITS OWN).

2. Open Paint. (You should find it listed, via the Start button, under Accessories).

3. Click Paste.

4. Go to 'Save As' (NOT just 'Save') and select Jpeg as the file format.

5. Save the image file to anywhere convenient on your computer (such as to the desktop).

6. Then upload to https://imgbb.com/ as previously suggested.

[Buenchico]

Crossed posts!

You can ignore what I've just written as long as the image file uploads OK for you. (If it doesn't, it's probably using the wrong image format. You can then follow my method above anyway)

[ToraToraTora]

yes ^^^^ that's another way using paint, I was hoping that would not be necessary

[andy-hughes]

Hopefully, if I've done it right - this is the link -

https://ibb.co/WvvkVKH

Gentlemen - start your engines ...

[bednobs]

what do you want it to look like?

[andy-hughes]

Hi bednobs - it was a bog-standard Excel worksheet, with columns and headings, until I pressed who on earth knows what!!

I'd just like it to go back to that, if it can be done please.

[Atheist]

You've somehow created a chart (i.e. a graph).

[Atheist]

Try clicking on Sheet 1 on the right end of the tabs across the bottom of the screen.

[andy-hughes]

Atheist - that's done it!!!

Thank you so much everyone who has contributed to the thread, and for all your patience with my Luddism, your efforts are greatly appreciated.

Have a good evening all.

[fiction-factory]

I can see you had at least 7 charts there, andy. Did you set up/want any charts?

[Atheist]

I'm pleased. Sheet 1 shows your spreadsheet as you created it, and somehow there are various charts (i.e. graphs displaying the spreadsheet data) on other tabs. You may have created the charts on purpose or maybe not. Anyway, now you know what the bottom tabs are for. If you don't want any of the charts, you can delete them by right clicking the tab and left clicking delete.

[andy-hughes]

No, I didn;t want any charts at all.

I am a simple soul in computing terms, i simply want my disco collection indexed so i can section it and know what I have in which genre - makes life easier in the middle of a gig.

Thanks again all.

[ToraToraTora]

yep you created a chart, in fact you created 9 charts! yep your data is on sheet1

[ToraToraTora]

if you select all by mistake, (top left corner) then go clicking around not realising what happnned, you can end up clicking the chart tab and then creating a chart but you'd have to select all types of chart for that to happen! Err indoors does this sort of thing all the time.

[andy-hughes]

Thanks Tora, that's clearly what I did - at least I'll know how to correct it next time, and not spend several hours wasting my time, and then wasting the time of kind AB'ers.

Thanks again for your support - much appreciated.

[ToraToraTora]

The thing is there is nothing to "correct", the chart function is very powerful if you want to use that sort of thing. All you did was create various chart views of your data. The data itself remained constant and hiding in sheet1. if you can stand the excitement create a new sheet of a simple list then select all and play with the chart function, it should enable you to see what you actually did here. Excel is probably the most used officey type program on the planet and for good reason. They say that if a rogue state wanted to do the most damage to the world, they should stop excel working!