New Tasks and New Responsibilities

Now that Autumn is here, the kids are back in school, and things are starting to settle down, why not share information about ExcelTips with a friend or coworker? After all, Autumn often means new tasks and new responsibilities or new homework, if you are a student. Might Excel (and ExcelTips) be helpful to that friend or coworker?

Give it a thought, then give them a tip. Send them to this webpage.


ExcelTips (ribbon) for 3 October 2015

Easily Dividing Values by 1000

Sometimes the data in a worksheet isn't in the exact format desired. If you want to dividie your values by 1,000, there are a couple of ways you can approach the task, as described in this tip.

Read this tip »

(Thanks to Michael Avidan (MVP), Barry Dysert, Tomas Wallgren, Nick Pomponio, Steve Aprahamian, Meu Wah, Denny Jansen, Henry Harper, John Burke, Gary Wilson, John Vander Linden, Martin Nicol, Brian Lair, Marty Brown, Martyn Passmore, James Tobin, Larua Norin, Jim Williams, Leslie Glasser, Leslie Scott, Alex Blakenburg, Isha Goyal, Brian Hershman, Steve McClure, Sian Thomas, Richard Ashdown, Dermot McGlone, Ephraim Ngizwenayo, Ricard Ribas, Kimberly Mihaliak, Andrew McIsaac, Damian Fennelly, Lisa Borden, David Zwaaf, David Schlatter, Alan Bouvier, David Leyden, Craig Korfanta, Tony Davis, Bernie Marshall, Andrew Evans, Jacques Raubenheimer, Lara Carey, Louis Farrell, and Mansoor Pirwani for contributing to this tip.)

Macros extend Excel
Reversing Names In Place

Do you want a way to reverse names within a cell, making them "last, first" instead of "first last?" Here's a handy macro that can take care of the switch for you.

Read this tip »

Supercharge Your Formatting

Want to change how your data looks based on criteria that you determine? It's easy to do using Excel's powerful conditional formatting features. Picture how you want your data to appear, then use conditional formatting to make it happen. Unleash the power of conditional formatting today.

Customizing Excel
Turning Off Paste Options

Paste some information into a worksheet and Excel helpfully displays some options related t the paste operation. If you don't want to see those options, here's how to turn the feature off.

Read this tip »

Macros extend Excel
Selecting a Range of Cells Relative to the Current Cell

When processing information in a macro, you often need to select different cells relative to the currently selected cells. It's easy to do once you know how to use offsets in your macro statements.

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.

Printing Formatted Comments

I already know how to print comments in Excel but I can't find any information about print formatted comments. I've formatted the comments to be bold, to have colors, etc., but those formats don't show when printing.
—Hannah Davis (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 794  •  Orem, UT  84059  •  801-607-2035