""
IMAGE: Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 2019, 365
 
 TheExcelAddict.com

February 11, 2021

Hi fellow Excel Addict,
 
Francis Hayes - Learn to work smarter with Excel at TheExcelAddict.comWhat a difference a week can make!

After cruising through the last 7 months of the COVID pandemic with a only 300 cases in our province of 1/2 million, this week there has been huge spike of around 200 new cases in just the past 3 days.

It appears to have originated from a limited number of activities in the same area happened over one weekend, so hopefully this will get contained soon.

I'm not too concerned though. With the weather we've been having in the past week, I don't want to leave my house anyway.

Today's 'Excel in Seconds' tip is one that I have been using every day for more than 25 years.

I hope you'll find it helpful.

Please help share my newsletter on your social media accounts — and with your colleagues or any other Excel users you know who want to get smarter with Excel.

Have a great day, keep safe and keep on Excelling,
Francis Hayes (The Excel Addict)
Email:  fhayes[AT]TheExcelAddict.com


Learn how to build your own stock portfolio dashboard in Excel in less than 30 minutes in this free tutorial.




 

Send Email. Connect With Customers. Grow Your Business.

With AWeber, you get all the email marketing tools you need to create and send beautiful and engaging emails. For a behind-the-scenes look at how you can use AWeber, sign up to our Test Drive email series:


 
Missed my last newsletter?

Click Here to View it Online



Having a positive attitude can help us in difficult times.
I hope today's quote will help foster a positive attitude in you today.


Quote of the Day

"If you are not willing to learn, no one can help you.
If you are determined to learn, no one can stop you."

-- Zig Ziglar --

If you have a favourite quote, send it to me and I may post it in my newsletter.

THIS WEEK'S 'EXCEL IN SECONDS' TIP

 

Open A Specific Workbook Every Time Excel Starts


Do you start each workday by always opening one or more specific workbooks?

Adding shortcuts to your Desktop would make opening these workbooks easier but wouldn't it be easier if they opened automatically every time you started Excel?

Yes, you can do that.

Excel gives you an option to designate an alternate startup folder where you can store one or more workbooks (or shortcuts to them) that you want to open each time Excel opens.

Here's how:

1) Browse to the folder in Explorer that you want to designate as the alternate startup folder.

2) Click in Explorer's address bar and then copy (CTRL+C) the folder path to the clipboard.

3) From the File tab, click Options, then click Advanced.

4) Scroll down to the General section and click in the 'At Startup, open all files in:' field.

5) Press CTRL+V to paste the folder path from the clipboard.

6) C
lick OK.


Alternate Startup Folder in Microsoft Excel 2007 2010 2013 2016 2019 365

You can now move any workbooks into this folder that you want to open each time Excel starts.

Or, if you would rather leave the workbooks in their original locations, you can create shortcuts that link to the workbooks.

Right click in the alternate startup folder, click New, Shortcut and browse to the file you want to link to.

When you are finished, close and reopen Excel and you will see the workbook(s) open automatically.


Learn how to build your own stock portfolio dashboard in Excel in less than 30 minutes in this free tutorial.
 

To share this tip with your friends and
colleagues, choose one of these options...

 
Open A Specific Workbook Every Time Excel Starts


 
Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are EVER not completely satisfied with anything I recommend, please let me know and you will get your money...GUARANTEED. You can't lose.
 
 
"Spreadsheets Tips From An Excel Addict" is a weekly publication of TheExcelAddict.com.
Copyright Francis J. Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630