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.
Maybe I'll finally get some of my online projects started.
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.
Have a great weekend,
Francis Hayes (The Excel Addict)
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.
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.
To work with two workbooks or worksheets on separate monitors without opening separate instances of Excel, here's what you need to do...
1) 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
• 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.
|"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