RSS

Open & Save files faster in Excel 2013 [quick tip]

19 Nov

Excel 2013, the newest version of Excel as of writing this has many great features like data modeling, improved pivot tables, power view, flash fill etc. But one thing that I find very annoying is the Open & Save experience. Any time we open a file or save a workbook (which happens a lot everyday), we must navigate the painful backstage screen to select our favorite folders.

You see, Excel 2013 supports cloud saving. So that means, by default it will show your Office 365 or OneDrive or SkyDrive or whatever fancy new name Microsoft has for these things. But I am not so much in to clouding. Heck, I see a passing cloud in the sky and I almost run into my house. So what to do?

Simple. We can turn off these features.

We can save & open files faster by using below trick (I am cursing myself for not learning this earlier).

image

Go to Excel options (this will be visible only once you open any file, even a new one) from File menu.Click on SaveEnable “Dont show backstage when opening or saving files”Enable “Save to computer by default”Optional: Add a default save location for your workbooksYou are done.

Now that I have turned on these features, I no longer pay the extra click tax to Microsoft whenever I save my files
(Source chandoo.org)

Advertisements
 
1 Comment

Posted by on November 19, 2014 in Excel

 

One response to “Open & Save files faster in Excel 2013 [quick tip]

  1. SutoCom

    November 19, 2014 at 6:21 pm

    Reblogged this on SutoCom Solutions.

     

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: