Making Sure Numbers Copy as Numbers

When you copy information from one worksheet to another using a macro, you might not get exactly what you want. This tip looks at how to make sure that your macro copies numbers as numbers, even if they start out as text.

Read this tip »

(Thanks to Steve Aprahamian, Patrick Sedgwick, Harold Druss, Tomek Dluzniewski, James Woolley, Bob Beechey, Wayne Edmondson, and Aldo Santolla for contributing to this tip.)

Controlling Where You Edit Cell Contents

You can edit cell information either in the Formula bar or in the cell itself. Here's how you can configure Excel to specify where you want to perform your edits.

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 500 pages of detailed info on how to better use Excel. Learn more about Excel today!

Checking for Time Input

Need to know if a cell contains a time value? Excel doesn't contain an intrinsic worksheet function to answer the question, but there are some easy ways to approach the problem.

Read this tip »

Canceling an Edit

When editing a cell, you may want to cancel the edit at some point. There are two ways to do this, both described in this tip.

Read this tip »

Fast AutoFill

Want to fill a long column with predictive data? It's easy to do by using AutoFill and a double-click of the mouse.

Read this tip »

Deleting a File in a Macro

Macros give you a great deal of control over creating, finding, renaming, and deleting files. This tip focuses on this last aspect��"how to get rid of an existing file.

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.

Making Page Breaks More Visible

Is there a way to make page breaks darker so that I can see them? I cannot tell if I am entering data that will be on a different page when printed. It is very time consuming and annoying to bring up Print Preview after I type something into each cell.
—Rod Williams (provide an answer for this Help Wanted question)