Storms and Water

It's been a quiet week at the Wyatt household; nothing much to comment on or report about. We've been enjoying typically unpredictable April weather, with storms blowing through quite regularly. None are terribly burdensome, however, although we thought the one that came through early Thursday morning was going to be a doozey. (It wasn't.) Regardless, each increases the much-needed water for our area.

I hope things are going well for you in your corner of the world this week.

—Allen
     

ExcelTips (ribbon) for 17 April 2021

Macros extend Excel
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.)

 
Customizing Excel
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!

 
Time formulas
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 »

 
Editing
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 »

 
AutoFill
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 »

 
Macros extend Excel
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 »

     

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.

 
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)

 
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  •  307-200-0450