On the Road

Today I'm in the Midwest, in the middle of a week-long trip. I brought my granddaughter back to Ohio to spend the week with my sister, and I am spending the time researching genealogical and historical records in dusty old libraries and graveyards in Tennessee and North Carolina. (And, truth be told, I'm having a grand time doing it. I find this type of pursuit very refreshing.)

I hope you are having a great summer and enjoy the tips this week.

—Allen
     

ExcelTips (ribbon) for 19 July 2014

Worksheets
Using Very Long Worksheet Tab Names

Excel places a limit on how many characters you can use in a worksheet name. This tip discusses that limit and provides some easy workarounds you could try if you need to use longer names.

Read this tip »

(Thanks to Trevor Shuttleworth, Steve Aprahamian, Guy Goodwin, Dave Onorato, Don Bruck, and Carole Haley for contributing to this tip.)

 
Comments
Pasting a Comment into Your Worksheet

Excel allows you to not only put information into cells, but into comments attached to those cells. Here's how to copy the information from a comment into a cell, using techniques you are already familiar with.

Read this tip »

 
PivotTables Make You Feel Faint?

Do you get weak in the knees when asked to deal with huge amounts of data? Forget feeling faint ever again when you are asked to deal with PivotTables. Learn much more than the basics with PivotTables for the Faint of Heart, now available in three great versions.

 
Editing
Displaying Row and Column Labels

When you create a worksheet, it is common to place headings at the top of each column and the left of each row so you can know the meaning of the data in the worksheet. It is a bother to have those rows and columns scroll off the screen when you are entering data. Here's how to make those headings stay visible at all times.

Read this tip »

 
Macros extend Excel
Renaming a File

Need to rename a file in a macro? It's easy to do using the Name command, as discussed in this tip.

Read this tip »

 
     

Need More ExcelTips?

You are reading the free version of ExcelTips. There is another version you could be reading right now: ExcelTips Premium. This week ExcelTips Premium subscribers also learned about:

  • Editing the Custom Spelling Dictionaries
  • Determining the RGB Value of a Color
  • Changing the Color of Worksheet Gridlines
  • Inserting and Copying Rows

Each weekly newsletter is in a professional PDF layout and presents double the tips (Premium subscribers see articles you won't in regular ExcelTips) with great, useful graphics. Plus, ExcelTips Premium subscribers get valuable money-saving benefits. For more information (including a sample issue), visit the Tips.Net store.

     

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.

 
Select One Cell and Make Another Cell Bold

Is there a way that when I select a specific cell that Excel will automatically make the contents of a different cell bold? For instance, if I select cell K5 I would like whatever is in cell C5 to show as bold; when I leave cell K5 (to go to a different cell), then cell C5 should to revert to however it was before selecting K5 made it bold.
—Clay Sandoz (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