Thursday, July 30, 2009

How to "Save As ..." in Excel 2007.

For the first time ever, I use Excel 2007. And I don't know how to "save as", that is, to save a file in a different format than the default Excel format.

So I google it, and find this page from Digg.

I'm amazed that many people think it's a stupid question. Many people don't answer the question, just saying the guy who asked this question is retarded. They say, "To publicize how stupid this question is, let's keep posting!" How mean they are. As a result, I have to scroll down quite a bit to find the solution:

RIGHT CLICK on quick access toolbar
SELECT Customize quick access toolbar
SELECT Show All Commands from "Choose commands from:" drop down
SELECT Save As
CLICK add
The guy who asked this question (and I myself) is not retarded. It's Microsoft Excel developers who are retarded. How can you design the updated version of software so un-intuitively to the users of the previous version? (They completely reshuffle which command belongs to which menu bar.)

And the most annoying feature of Excel, namely, a pop-up window always shows up when I want to close a file that is already saved in the non-Excel format, still remains in this new version of Excel. It is Microsoft Excel developers who are retarded.

And when I enter "mar2003" (as the survey identifier for the one conducted in Morocco in 2003; "MAR" is the ISO code for Morocco), Excel 2007 recognizes it as 3/1/2003 (as the previous version of Excel does). Who would enter "mar2003" for 1st March 2003? It is Microsoft Excel developers who are retarded.

50 comments:

Anonymous said...

Thank you!

Anonymous said...

THANK YOU!!! I HATE this version of office.

Anonymous said...

thanks i didn't realize how much i used the save as button if the IT gurus would listen a little more they would be a lot more effective

Doris said...

I know, FFS M$, making people ask "stupid questions"! Haha.
Anyway, thanks for this!

Kristen said...

Thanks so much for your post. Excel 2007 is not intuitive, and in my opinion, the interface is poorly redesigned.

You saved me about 20 minutes of digging through file menus to find a very simple command.

.::WaNiE::. said...

Thank u so much for this ! I'm not a retarded also, i just cant find the 'save as' button, i dont want to just click the save button and they replaced the original doc. im working with.

and yeah i hate this version of office !

Anonymous said...

thanks a lot. this one really was very helpful to me.

Anonymous said...

Thank you
Couldn't find the "save as" function your help much appreciated
cheers
Rod

skypuppy said...

MS think they know whats best for us, they are SO out of touch!Thanks for pointing in right direction! MS has screwed up with Windows 7 as well, not being able to drag and drop files in folders. There is a workaround for this at: http://www.winhelponline.com/blog/disable-full-row-select-explorer-windows-7/

Anonymous said...

Thank you so much!

Anonymous said...

thank you - soooooo much for the ""save as"" needed to show all commands

Anonymous said...

Thank you sooo much, I was beginning to wonder whether it was worth buying 2007!!!!

Anonymous said...

MS are such assholes. You rock! Thanks for posting this.

Anonymous said...

Thank you for posting this, despite having worked in IT for 12 years I couldn't see the damned Save As button and had to resort to Google for the answer - something I really shouldn't have to do. As for the MS Developers, it's very easy to blast someone for not knowing something when you know a product (& recent changes) inside out.

Anonymous said...

Usually, I use OpenOffice, but I changed work PCs and was forced to use Excel with the missing "Save As" button.

Thank you for posting this very helpful tip!

Anonymous said...

You are absolutely right. Thank you for the post, cause I spent almost 1 hour trying to find where they hide the 'save as' option. It happens now that instead of facilitating us the new excel is doing the opposite - waste our time making efforts to find the necessary option

Anonymous said...

Thanks for this comment - I do not like Office 2007 either - did the programmers ask anybody for input

Anonymous said...

Still useful info! Thanks.

SharonL said...

Thank you so much for answering that question for me. I also read that post FIRST, before I found your answer. I have been writing computer software since 1966, I couldn't find it either. 2007 isn't exactly intuitive......

chris moeller said...

I just stick to open office normally, but had to "save as" in excel 2007.

How idiotic!

Very bad user interface design, no wonder I hear so much from people on how they hated the "banners"!

If it's not broke, make it unusable, huh? ;)

HiLLjO said...

You have NO idea how much this saved my brain this morning! Nevermind those people who are SO mean they have to make fun of people because it's the only way they feel like they have the upper hand.

Anonymous said...

Thank you. I too had the same question. If I am mentally challenged, I fooled the three universities that gave me degrees.

Anonymous said...

Thank you so much - so frustrating without this option!

Anonymous said...

I agree with you comments and thank you teacher.

Anonymous said...

Thank you! WHY, WHY wouldn't developers have done some analytics on what commands were most commonly used? I have an older version and have the hardest time on 2007 Word. It's a frustrating waste of time....and it's not like I'm an idiot (12yr user of MS Word, 15yr Mensa member).

Anonymous said...

Thank you so much, from someone who takes pride in being able to figure out computer questions on my own, but also continues to be amazed at Microsoft's need to make everything hard than it needs to be. Thank you Apple and Steve Jobs for showing us that computers and computer software can be intutive.

Anonymous said...

Excel 2007 blows goats. Thanks for the Save As help.

Anonymous said...

Today I realized I am retarded too.

Anonymous said...

It is Microsoft developers who are retarded.

Anonymous said...

Thanks! You saved my time.

Carol said...

I hated 2007 since day one! I still use 2003 and refuse to use 2007 even though I paid through the nose for it, unless absolutely necessary!
Thank you for that tip!

Anonymous said...

Thanks a bunch! had been struggling with the 'save as' option. Your blog helped instantly! :)

Anonymous said...

Thanks very much indeed. Luckily your web page was the first I clicked on ! Thanks for taking the time to inform us :-)

A_Train said...

America thanks you

Anonymous said...

I, too, am grateful for your sharing the answer to this perplexing question! It takes smart people to give this kind of gift, not retarded people!

Anonymous said...

Thanks for the post. I too had no idea where to find the Save As button, after my version of Office was upgraded at work. I want to add that it turns out you can get to "Save As" by clicking on the giant Microsoft Office logo in the upper left-hand corner. I had no idea the logo was actually a command menu.

Anonymous said...

Thank you! Couldn't figure it out and needed to do it for work, for a while I just saved then had to go and change the name. Feel like an idiot!

Anonymous said...

THANK YOU THIS WAS VERY USEFUL! Sorry to hear someone thought you were retarded. I guess I am retarded too.

Anonymous said...

Thank You for this post!
I had already saved over something I wanted to keep before I resorted to looking it up... What a pain.

Anonymous said...

Thanks! How very frustrating!! OVER 35 yrs computer experience, & couldn't find this! Ugh!

Program developers need to have more 'users' test programs before released to general public!!

This help was Much Appreciated!

Anonymous said...

Thank you very very much!!!!

Anonymous said...

Pardon my language in advance, but HOLY BLEEPIN BLEEP! I first used office 2007 in, ...2007, and refused to use it anymore because of this exact problem.

Now, in 2012 as you can see from my timestamp, I am being forced to use office 2007 due to a new computer at work.

I can't believe those blithering motherbleepin arrogant morons did not fix this problem in the five intervening years.

If they really HAD to get rid of one of them, Save would be the one to remove, since Save As gives you all the other options (including Save with only one additional click.)

BLEEP YOU MICROSOFT!

(I self-censored since I noticed this is moderated and other commenters kept it clean.)

Anonymous said...

Thanks,

I too was wondering where to find option "Save as" once i opened an excel sheet from an outlook mail.

There is nothing wrong in the question u asked.

Anonymous said...

I agree. The microsoft developers are retarded. This is so non-intuitive. After this I'm going to LibreOffice. No more Microsoft crap.

Anonymous said...

GRACIAS, from Dallas, TX! Your comments vis-a-vis Excel are SPOT ON!

Joshua Mercer said...

Thank you! Very helpful.

Rob said...

Thanks. MIcrosoft are idiots for not making the "save as" visible in the default setup.

Anonymous said...

thank you from France

Anonymous said...

LOL!! Yes, absolutely agree: THEY ARE RETARDED.

Thanks a lot for your help!

Markus Schopenknecht said...

Thanks for that, made my day. I use the 2010 version, so i had to look elsewhere for that (excel-aid.com, the guide for "Excel save as" is quite good, video and pictures included), but your humor is just wonderful. Cant get that from a "professional" Website :P