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
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
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
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
Here are a few more Excel articles that I read this week, that you might find useful:
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!
Save time with our "Done For You" Excel products.
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2018
All rights reserved.