FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week

Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

March 22, 2016

Hi fellow Excel Addict,

Luckily that big snowstorm that was forecast for us last Thursday night just brushed by. Instead of 25cm of snow we had less than 10. Today only a trace of snow remains but it still doesn't feel much like spring.

Francis Hayes (The Excel Addict)It's extremely windy here today with 100+kmh (62+mph gusts). When I went for my run this morning, at times I was almost running in place. It's funny how, when you have the wind at your back, everything is wonderful but when it's in your face, well, not-so-much. However, running into the wind does force one to work much harder and the benefit is, when the wind stops, things seem much easier. I'm sure there is a life lesson in there somewhere.

A
lso, I want to say a big THANK YOU to everyone for helping spread my newsletter around the world. Maybe you're as passionate about working with Excel as I am or maybe not so much. But I think you understand that sharing these tips with other Excel users will help them tremendously. I'm a big believer in the 'Pay it Forward' principle.

In last Thursday's 'Excel in Minutes' newsletter, I showed you how to 'Tame the 'Unfrozen' Columns When Using Freeze Panes'. If you missed it you can read it here.

If you have a favourite tip that you'd like to share, or a problem that you've been trying to solve, that I could possibly include in my newsletter, please send it along to me.

Wishing you an AWESOME week,
Francis Hayes (The Excel Addict)
Email: 
fhayes[AT]TheExcelAddict.com


Francis Hayes (TheExcelAddict.com)

TheExcelAddict.com Quote of the Day

"Keep away from people who try to belittle your ambitions.
Small people always do that, but the really great people make
you feel that you too, can become great."
-- Mark Twain --




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



Excel in Seconds with TheExcelAddict.com

PageUp. PageDown. PageSideways ?

Twice in the past week I have been asked if there is a way to scroll sideways one full screen width using the keyboard. So I assume there are a lot of other Excel users out there who haven't yet discovered this useful tip.

When you are working with a large spreadsheet with lots of columns that require a lot of scrolling left and right, it's good to know a keyboard shortcut for scrolling sideways so you don't have to be switching back and forth between your mouse and keyboard.

To scroll one screen width to the right, hold down the ALT key and press the PageDown key.

To scroll one screen width to the left, hold down the ALT key and press the  PageUp key.

Keyboard Shortcut Scroll Screen Left And Right in Microsoft Excel 2007 2010 2013 2016 365


Thanks for supporting this newsletter and website

FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week

Earnings 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' and 'Excel in Seconds' are publications of TheExcelAddict.com.
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630