Crisp Fall Weather

I hope you are having a great week. (Or, more properly, I should say that I hope you are having a great weekend.) Things in my corner of the world are going well right now, and I'm enjoying the crisp fall weather.

Enjoy the tips in this week's issue!

—Allen
     

ExcelTips (ribbon) for 25 October 2014

Editing
Pasting Excel Data within Word's Page Margins

The programs in the Microsoft Office suite are designed to work with each other easily. Sometimes there can be hiccups along the path of data bliss, however. This tip examines ways you can paste Excel data into a Word document without extending past the document margins.

Read this tip »

(Thanks to Zulfiqar Meghani, Brian Hershman, Guy Goodwin, Vincent Dutter, Jacques Raubenheimer, Bob Beechey, and Carole Haley for contributing to this tip.)

 
Formulas
Generating Double-Digit Random Numbers

Normally you use the RAND and RANDBETWEEN functions to generate random numbers. What if you want to generate random numbers within a certain range but exclude some numbers in that range? Here's some ideas on how to get what you want.

Read this tip »

 
Tech Questions? Get Answers! Ask Leo!

Thousands of answers to your computer, internet, security and technology questions. Now in its 12th year, industry expert Leo Notenboom is ready to answer YOUR question.

 
Worksheet structure
Floating Information in a Frozen Row

You can freeze information in rows or columns using one of the built-in features of Excel. As you move up or down in the worksheet, the information in the first rows can remain visible. If you want something in a row to always remain visible as you move left and right, the proposition becomes a bit trickier. This tip explains a couple of ways you can approach the problem.

Read this tip »

 
Macros extend Excel
Inserting the Current Time with Seconds

If you need to insert the current time, with seconds, then you'll need the macro discussed in this tip. It's easy to use and can give you just the information you need.

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:

  • Calculating the First Business Day of the Month
  • Switching Editing Location
  • Automatic Selection of Portrait or Landscape
  • Turning the Legend On and Off

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.

 
AutoFilling Numbers with a Trailing Period

I want to AutoFill a column of sequential numbers as "1.", "2.", etc., through "150.". The AutoFill will only work without the trailing period, but I want the period there. Is there a way to make this work as I'd like?
—Iana Cole (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