Author Archive

Free Electricity for Home – - Free classifieds in California, Home improvements   Leave a comment

Long Kept Secret For Generating Free Electricity – How would you like to create a generator which creates Free Electric Energy? Using our easy-to-follow guide, … Posted in California, Home improvements of free classifieds via Free Electricity for Home – – Free classifieds in California, Home improvements.

Posted September 14, 2010 by pasadmin in Uncategorized

Wrapping Text in Excel   Leave a comment

Wrapping Text For multiple line entries of labels, comments, notes, or descriptions in Microsoft Excel, select the cells (or an entire row or column), choose Format > Cells, pick the Alignment Tab, and check the option for Wrap Text, finish with OK. The column width will determine how many lines are needed to display the [...]

Posted August 8, 2008 by pasadmin in MS Excel Tricks & Tips

No Formula, Please   Leave a comment

Formulas entered in Excel are relative to the cells they are entered in. Now you want copy the “result” of a formula to another cell.  So you go ahead and copy the cell where the result is and “paste” it it into the new cell. Whoops! What hapened? The reult is not the same as what [...]

Posted December 26, 2007 by pasadmin in MS Excel Tricks & Tips

Entering Phone #’s – What a Pain!   Leave a comment

These days to make a call you have to dial the 10 digit number…which means dialing the area code as well as the local phone #. Formating the # for each entry is a PAIN! For example to enter my phone number you would have to type “(613) 347-9893″. Thats a total of 14 keystrokes. [...]

Posted December 15, 2007 by pasadmin in MS Excel Tricks & Tips

Smart Data Entry   Leave a comment

Here’s the scenario:   You are maintaining a customer list in Excel. Your column names and widths are as follows:   Note: To set column widths Select Format from the top menu then choose Column and select Width. Enter the names and widths shown below.   Last Name            = Lname           [...]

Posted October 5, 2007 by pasadmin in MS Excel Tricks & Tips

Excel Can Find It!   Leave a comment

Geez! I have a big file of customers with all their information including phone #’s & addresses .  I want to talk to Jim Smith but I can’t find him in my Excel spreadsheet. I also know that I have a lot of “Jim”s in my spreadsheet.  So let’s find the one I want. Go [...]

Posted September 21, 2007 by pasadmin in MS Excel Tricks & Tips

The Power of “Find”   Leave a comment

The Power of the “Find” function in Word’s Edit menu will lower your frustration level.  Place your cursor (Insertion Point) at the very top of your document… now let’s get started. Scenario: You have a form letter that you have addressed to a customer and you want to call the customer but you’re not sure [...]

Posted September 21, 2007 by pasadmin in MS Word Tricks & Tips

Doesn’t Look Like a Fraction!   1 comment

Go to a blank cell in a worksheet. Enter the fraction 3/4. Hey! Wait a minute! I didn’t say March 4th …. I entered three quarters. Simple… I’ll just format the cell as a number or fraction (Format Menu/Cells) the result is 39145. Where did my fraction go? Here’s the answer. Excel automatically interprets your [...]

Posted August 16, 2007 by pasadmin in MS Excel Tricks & Tips

The Zero Dilema   Leave a comment

Often you want enter a number that begins with a Zero (Invoices, Zip codes). How frustrating it can be when you want the preceding zero(s) to appear in the cell.  In an Excel cell enter 0012345 and press enter.  OOPS! No Zeros! – only 12345 appears.  Go back to the cell and check the edit [...]

Posted August 15, 2007 by pasadmin in MS Excel Tricks & Tips

Separate Pages When Printing – Page Breaks   Leave a comment

You can spend a lot of time inserting and deleting rows in your worksheet so that when you print it your information stops and restarts on the next page where you want it to. This can be very frustrating and cost you a lot of ink and paper when testing each adjustment. Help is on [...]

Posted August 12, 2007 by pasadmin in MS Excel Tricks & Tips

Page Borders in Word   Leave a comment

Page Borders often present a problem that is easily solved, but is frustrating until you know about one small adjustment. The problem is that when you print your masterpiece, the page you have worked on so carefully, the bottom of the border does not print. The border looks fine, it is exactly as you wanted [...]

Posted August 9, 2007 by pasadmin in MS Word Tricks & Tips

Does It Read Smoothly?   Leave a comment

Sometimes you want to move a paragraph or two around in your document. For instance, you might want to move a paragraph from its current location to before the preceding paragraph. You can quickly move paragraphs by following these steps: Position the insertion point in the paragraph you want to move. While holding down the [...]

Posted July 25, 2007 by pasadmin in MS Word Tricks & Tips

Getting around Your Document   Leave a comment

I was working on a document with a student one day when we noticed a change needed to be made at the beginning of the line.  I mentioned it and the student immediately held down the left arrow key to get to the error and fix it.  I became impatient… using the arrow key takes [...]

Posted July 18, 2007 by pasadmin in MS Word Tricks & Tips

Word Formatting Tip   Leave a comment

Suppose your writing a multi-paragraph document but you would like to separate each with a formatted line. Try this … it will give your document a more professional look. Enter some text in a new Word document… don’t waste time typing… just copy any junk from an existing document. At the end of the text, [...]

Posted July 4, 2007 by pasadmin in MS Word Tricks & Tips

What Day of the Week Is It?   Leave a comment

When Did I do This? What if you’re using Excel to track the hours you are working for a customer. Naturally, you will use Excel’s date formatting in column A , # of hours worked column, a rate/hour column, a formula to calculate that day’s billing amount and a total billing to date column. Hey! [...]

Posted July 1, 2007 by pasadmin in MS Excel Tricks & Tips

Follow

Get every new post delivered to your Inbox.