Using X of Y in a Page Footer

If you want your printed worksheet to include page numbers, adding them is relatively easy. This tip shows two ways that you can get the desired footer.

Read this tip »

(Thanks to Herman Broeckx, Ryszard Raciborski, Steve Aprahamian, Ira Bernstein, Alan Cannon, Michael Avidan (MVP), Ron Solecki, James Woolley, Jeff Paliwoda, Janice Harris, Sheila Leppert, Leszek Rozpedek, Jim Conseil, Dave Newcomer, Mark McCune, Penny Edwards, Thomas Van Dam, Henry Arthur, Kathleen Waggoner, Rosalba Monti, Hank Jager, Rhonda Simmons, and Craig Korfanta for contributing to this tip.)

Separating Cells Based on Text Color

If the font color used for the data in your worksheet is critical, you may at some time want to move cells that use a particular cell color. This tip discusses a few different ways you can move the colorful cells where you want them.

Read this tip »

ExcelTips at Your Fingertips

Support ExcelTips and obtain a valuable resource—your own copies of the ExcelTips archives. Each archive contains all the tips for a calendar year; often over 400 pages of detailed info on how to better use Excel. Learn more about Excel today!

Hiding a Hyperlink on a Printout

Hyperlinks can be real handy in a workbook, but you may not always want them visible when you send the workbook to the printer. Here are a variety of ways you can hide a hyperlink so it doesn't clutter up your printout.

Read this tip »

Automatically Hiding the Personal Workbook

If you leave your Personal.xlsb workbook visible from one Excel session to another, you may find that you unwittingly make changes you never intended to make. Here's some ideas on how to protect the workbook or at least stop yourself from making those unwanted changes.

Read this tip »

Sizing Text Boxes and Cells the Same

Adding a text box to a worksheet is easy. Making sure that text box is the exact size of a cell in the worksheet may not be as easy. Here are the easiest ways to make sure the text box matches the cell (or cells) you place it over.

Read this tip »

Getting a List of Matching Cells

The Find and Replace capabilities of Excel allow you to easily locate all the cells in a worksheet that contain specific values. If you want to copy the list of addresses to a different worksheet, though, the task is a bit more complex. Here are some ideas you can apply.

Read this tip »

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.

Values Beginning with a Specific Letter or Digit

I have a list of names and numbers (numeric values) in the range B1:B65. In cell A1 I have a single letter or a single digit. I would like to generate a list of just those values from B1:B65 that begin with the letter or digit in A1.
—Richard Roberts (provide an answer for this Help Wanted question)