Excel Weekly News from Contextures Oct 8, 2013
Prevent Scrolling + more Excel tips
In this week's Excel news, you'll see how to prevent scrolling on a worksheet, and other tips. Thank you for reading the Excel news!
- Debra firstname.lastname@example.org
Prevent Scrolling on Excel Worksheet
With a simple change to a worksheet property, you can limit scrolling and clicking to a specific range of cells. This setting only lasts until the workbook is closed, so you can use a bit of programming to set it again when the workbook opens.
Click here to see the details, and download the sample file: Prevent Scrolling on Excel Worksheet
Change All Number Formats in Pivot Table
In my recent pivot table number format survey, I learned that Number is the most popular format, by a wide margin. The votes were tied when it came to decimal places -- 0 and 2 were equally popular.
Thanks for voting in the survey, and if you'd like a quick way to change all the data in a pivot table to Number format, you can use a macro -- the code is in my blog post.
Click here to see the details, and to get the sample file: Change All Number Formats in Pivot Table
Switch Languages in Excel Workbook
Select English or French from the drop down list in this sample file, and the worksheet text changes to that language. You can apply this technique to shapes too, so flow charts and diagrams also appear in the selected language.
Click here to see the details, and download the sample file: Switch Languages in Excel Workbook
More Excel Tips
Here are a few more Excel articles that I read this week, that you might find useful:
- Have you ever thought about being an Excel consultant? Paul Ballard looks at the downside of this career choice.
- Alex Mullans, from Microsoft's Office Graphics team, creates a scary-looking chart on the Excel team's blog. I hope that your charts don't look like that!
- For a humorous peek at what other people are saying about Excel, read this week's collection of Excel tweets, on my Excel Theatre blog.
- Dates are stored as numbers in Excel, and just formatted as dates. Dick Kusleika shares a quick tip for seeing the numeric value of the date in a cell.
- If you're getting started with Excel's formatted Tables features, watch Jon Acampora's step-by-step video on Using Excel Tables. He explains their 10 key benefits too, and has links to other articles.
Video: Pick Answers With Excel Option Buttons
To make it easy for people to select one item from multiple options, you can add option buttons to your worksheet.
For written instructions, see Pick Answers With Excel Option Buttons. To see the steps in action, please watch this short video tutorial.
The leaves are rapidly falling off the trees, but it sure makes the sidewalks look pretty. In some sections, it looks like they are paved with gold. It's our Canadian Thanksgiving this coming weekend, so Happy Thanksgiving if you'll be celebrating too!
Recommended Excel Tools
In addition to all the free Excel tips and tutorials, there are other Excel tools that you can invest in. To learn more about the products listed below, click on the links to take a look at their features, and decide if they're right for you.
- Contextures PivotPower Premium Add-in
- Contextures 30 Excel Functions in 30 Days
- Excel Online Course
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2017
All rights reserved.