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 ddalgleish@contextures.com

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:

  1. Have you ever thought about being an Excel consultant? Paul Ballard looks at the downside of this career choice.
  2. 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!
  3. 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.
  4. 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.
  5. 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.

Golden Sidewalks

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!


Contextures Products

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.




Privacy Policy


Contextures Inc., Copyright 2019
All rights reserved.