Microsoft Excel 2003, 2007, 2010, 2013 Tips
The Excel Addict - Help with Excel 2013, 2010, 2007, 2003
October 1, 2015
Greetings from The Excel Addict
Hi fellow Excel Addict,

After terrible July weather (locally, the coldest July on record), a fantastic month of August, and one of the warmest Septembers ever, the first day of October was also unseasonably warm (24C). However, I'm afraid all of that beautiful warm weather is coming to an end. Today it is raining and 10 degrees celsius.

Francis Hayes - The Excel Addict - www.TheExcelAddict.com

Maybe I'll finally get some of my online projects started.

Windows 10?
As you probably know, Microsoft released Windows 10 a few weeks ago. It's a free upgrade, which is nice, but I haven't taken the plunge yet. Since I've retired, I have only one computer, so I'm a little hesitant about making this change, even though MS say it's easy to revert back if you don't like it.

Have you upgraded to Windows 10? If so, I'm looking for some feedback as to what your experience has been. I'd appreciate it if you'd take a few minutes to let me know.

Upgrades up to you eyeballs
Five versions of Windows (Vista, 7, 8, 8.1, 10) in 8 years. Five versions of Excel (2003, 2007, 2010, 2013, 2016) in 12 years. Don't you ever wonder how you are supposed to keep up when there seems to be a new version of Windows, Office, and iPhone every time you turn around?

I love learning new stuff as much as anyone but most of us have a life away from our computers as well, so I do understand the frustration many people have trying to keep their skills current. Heck, I'm doing this for a living now and even I find it challenging.

See. If today was a sunny warm day, I probably wouldn't have gone on this rant.

Peace.

Have a great weekend,

Francis Hayes (The Excel Addict)
Email: 
fhayes[AT]TheExcelAddict.com



If you missed my last newsletter, you can click here to view it online.


If you have a favourite quote, send it to me and I may post it in my newsletter.
"The best day of your life is the one on which you decide your life is your own. No apologies or excuses. No one to lean on, rely on, or blame. The gift is yours - it is an amazing journey - and you alone are responsible for the quality of it. This is the day your life really begins.”  -- Bob Moawad


Today's Microsoft Excel Tip

Working With Separate Worksheets On Dual Monitors (Excel 2010 and earlier)

In my previous newsletter, I showed you how you could 'Open Multiple Excel Files in One Step'. That generated a question from a lot of readers who have not yet upgraded to Excel 2013 but want to be able to work with multiple workbooks in separate/dual monitors.

With Excel 2013, by default, every time you open a workbook, it opens in a separate window. You can easily move each window around as you like. For those who have two monitors, this is an awesome feature that Excel users have been dreaming about for years. However, in earlier versions of Excel, each workbook opens in the same Excel application window.

One option I often see recommended for working with workbooks in separate windows is to open two separate instance of Excel and then open one workbook in each. Although, opening Excel in two separate instances does make it easy to move each workbook to a separate monitor, it also presents a whole other set of problems. These include, not being able to: open two worksheets from the same workbook (i.e. the second will open as Read Only), create formulas that reference the other workbook, paste formulas from one worksheet to the other (i.e. values are pasted rather than formulas).

Although it takes a little more preparation, here's another option that a lot of Excel users find works best for them.

Work with separate workbooks on two monitors
To work with two workbooks or worksheets on separate monitors without opening separate instances of Excel, here's what you need to do...

Restore Down button1) Close all workbooks except those you want to work with. If you want to work with separate sheets in the same workbook, from the View tab click the New Window command in the Window group;

2) Make sure your Excel window is not maximized. If it is, click the Restore Down button on the top right corner;

3) Click and drag the Excel window header so that the left edge of the Excel window is at the left edge of your left monitor;

4) If the top and bottom edges of the main Excel window aren't already maximized to fit your monitor, point to the edge of the Excel window (the mouse pointer will change to a two-headed-vertical arrow) and drag to resize;

5) Now, here is the trick. Drag the right edge of your Excel window across to the far edge of the second monitor. Your Excel window should now be stretched across both monitors;

6) Next, tile the windows by clicking View, Arrange All, Vertical;

7) You're now ready to work with both windows visible. See NOTES below

NOTES:

• When you're finished working on dual monitors, remember to resize the Excel window by dragging the right edge of the window back to the left monitor. At this point, you can maximize the window and it will fit on one monitor.
 
• When Excel is stretched across both monitors, the Ribbon and message boxes for both workbooks will appear in only the left window or sometimes partially split across both.

• The messages (e.f. AutoCalculate, etc...) usually displayed on the right side of your status bar will be visible on the second monitor only.



Thanks for supporting this newsletter and website


Subscription Information: Spreadsheet Tips From An Excel Addict is available only to subscribers of my newsletter. If this newsletter was forwarded to you and you would like to get your own copy, please visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com

My records show that {!name} at {!email} requested a subscription to this newsletter at TheExcelAddict.com on {!signdate long}.

 If you would like to share this newsletter with others...
1) Share a link to this page
2) Ask your friend/colleague to visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com
3)  Post a link to TheExcelAddict.com in a company newsletter or website.

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 for a few dollars. 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 I will get your money back for you...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