The Cold of Autumn

The cold days of Autumn are hitting our area. This past week the overnight temperatures dipped into the teens, and we even woke to about an inch of short-lived snow one morning.

The brisk air is invigorating, and I'm enjoying the changing of the seasons. I have several projects to finish up before the cold weather strikes in earnest, but hard work and perseverance should help knock those out.

I hope you enjoy this week's newsletter and find the information helpful.


ExcelTips (ribbon) for 22 October 2016

Linking workbooks
Jumping to a Specific Cell Using a Hyperlink

Excel allows you to define hyperlinks in your worksheets, and these can target specific cells on other worksheets. Here are two ways to make this happen.

Read this tip »

(Thanks to Michael Avidan (MVP), Alex Blakenburg, Jim Williams, Elliot Penna, Vasant Kumbhojkar, Mike Shellito, Christy Miller, Rolf Pedersen, Steve Aprahamian, Alec Whatmough, Neil Mitchell, David Gray, Rod Eggink, David Shepherd, Max Jones, Marc Reisberg, Catherine Lorenzo, Steven George, Henry Arthur, Tony Nixon, Jeaux Brown, and Cynthia Pili for contributing to this tip.)

Drawing objects
Selecting Drawing Objects

Excel allows you to create all sorts of drawings using a wide assortment of tools. When you need to take an action upon those drawing objects, you need to know how to select them. Here's how.

Read this tip »

Here's a Quick Way to Be in Control of the Largest Excel Datasets

If you can't discover the patterns that are already in your data, you are not in control of your work. Writing formulas is painful when you have thousands of rows. PivotTables are the way to quickly get insights from your data, but the fine points of PTs are elusive to many smart professionals. If you dare to fully understand and use PTs, then get started today for free.

Changing Paper Size for a Complete Workbook

If you need to change the size of paper on which your worksheets will be printed, it can be bothersome to make the change on each worksheet individually. Here's how to make the change on the entire workbook, at one time, regardless of how many worksheets it contains.

Read this tip »

Excel can calculate date in lightening time
Thoughts and Ideas on Significant Digits in Excel

Ruminations and reflections about significant digits in Excel. Includes examples of how significant digits can affect the outcome of various functions and formulas.

Read this tip »


Help Wanted

This section is for those having problems making Excel behave. If Excel is giving you fits, feel free to submit your own Help Wanted question.

If you have a solution for the problems below, click the link after the problem to send us your answer. (All responses become the sole property of Sharon Parq Associates, Inc., and can be used in any way deemed appropriate.) If your response is used in a future issue, you will be credited for your contribution to the answer.

Finding a Worksheet with a Specific Value in a Specific Cell

I have a workbook that contains hundreds of worksheets. Each worksheet represents an individual project for our company. Cell C4 of each worksheet contains the project number for that particular project. Finding individual projects out of all the hundreds in the workbook is cumbersome, at best. Could a macro be created that would all the user to enter a job number, find the worksheet that has that job number in cell C4, and then display that worksheet?
—Kelly Jones (provide an answer for this Help Wanted question)

ExcelTips is a free service of Sharon Parq Associates. You can find thousands of tips at our website and a whole lot more. ExcelTips is part of the Tips.Net network.
Sharon Parq Associates, Inc.  •  PO Box 1187  •  Mountain View, WY  82939  •  801-607-2035