A Quiet Week for the Wyatts

It has been a quiet week around the Wyatt household. By that I mean we haven't had to do any traveling and were able to stay at home. (Well, except for the times I was working in the office, of course.) This means I was able to get caught up on some projects that were on the back burner for too long.

I hope your week went well, too, and that you enjoy the tips in this week's newsletter.

—Allen
     

ExcelTips (menu) for 7 December 2019

Time formulas
Entering or Importing Times without Colons

Enter a time into a cell and you normally include a colon between the hours and minutes. If you want to skip that pesky colon, you'll need to use one of the techniques described in this tip.

Read this tip »

 
Files
Avoiding Scientific Notation on File Imports

When importing information from a CSV file, you may get unintended results from time to time. Here's how to force Excel to ask how information should be interpreted.

Read this tip »

 
Add UserForms to Your Macros

Still relying on message boxes and input boxes to communicate with the users of your Word and Excel macros? Take your macros to the next level by creating your own UserForms. Discover how in the information-packed Creating VBA UserForms course. Low cost; great instruction--check it out today!

 
Protecting worksheets
Unlocking a Worksheet with an Unknown Password

It is not unusual, in a corporate world, to be handed a worksheet whose source you don't know. If that worksheet is locked and you need to change it, then you become very interested in figuring out how to unlock the worksheet.

Read this tip »

 
Printing
Setting Up Your Printer

Need your printed output to look its best? You may need to change the settings used by your printer, then. Here's how to get to those settings.

Read this tip »

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