Search Contextures Sites
Excel Weekly News from Contextures Apr 04, 2013
Did you enjoy the long weekend, and get away from the computer for a little while? The weather wasn't great on Sunday, here in the Toronto area, but there was a beautiful sunset at the end of the day. You can see my photo at the end of the newsletter.
Now that we're back to work, in this week's Excel news, you'll see how to go back to previous cells, sort a pivot table with a custom list, and other tips. Thank you for reading the Excel news!
- Debra firstname.lastname@example.org
Go Back to Previous Location
In Excel, you can store up to 4 temporary locations, and go back to those locations quickly. This is handy if you’re making updates to a big workbook, and want to switch between a couple of sheets without lots of scrolling.
To see the details, click here: Go Back to Previous Locations
Show RSS Feeds on Excel Worksheet
Do you use Google Reader to keep up with your favourite blogs and websites? I use Google Reader a few times every day, and was disappointed to learn that it will be shut down on July 1st.
I'm looking for a replacement reader, and it looks like Feedly will be pretty good, as long as they find a way to transfer our feeds from Google in July. And it's free, so the price is right!
In the meantime, you can also import RSS feeds into Excel. It certainly isn't a replacement for Google Reader, but it's quick and easy to set up, so try it out!
To see the details, and to download the sample file, click here: Show RSS Feeds on Excel Worksheet
Sort Pivot Table With a Custom List
By default, a pivot table's items are sorted alphabetically. You can change the settings, so items are sorted based on their values.
And, you can even create a custom list of items, such as cities or regions, then sort your pivot table in that order.
Click here, to read the details: Sort Pivot Table With a Custom List
Video: Divide Numbers Without Formulas
In Excel, you can quickly add, subtract, multiply or divide, without using formulas. Just type a number on the worksheet, copy the cell, and use the Paste Special options.
Watch this short video to see the steps for using Paste Special to divide a group of cells.
For written instructions, and other data entry tips, please go to this page on my Contextures website: Change Values With Paste Special
Recommended Excel Tools
They aren't free, but these Excel tools are a worthwhile investment, so please 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 the products mentioned in this newsletter, and earn a commission on the sales.
Here's the beautiful sunset we enjoyed on Sunday night -- a wonderful way to end a long weekend.
Contextures Inc., Copyright ©2014
All rights reserved.