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.
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.
Also, 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)
If you missed my last newsletter, you can click here to view it online.
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.
| 'Spreadsheets Tips
Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630