The Tip Jar

Here are some interesting tips from MS Office suite. We will be posting new tips on and off. Please visit our website again to check out the new tips.

MS Word:

How to generate random text in a Word document without typing it?
Many a times when you need to test and try certain formatting options, you need some dummy text in your document. You do not want to type in the text for 15 minutes and try your options.

Try this…
In the document type

=rand(n1, n2) and hit the Enter key.

Where n1 is the number of paragraphs required and n2 is the number of lines required in each paragraph. For instance =rand(20,4) will generate 20 paragraphs, each having 4 lines.

MS Word:

How to delete the entire table from a document?
Your document might contain a table which is no longer required.

Try this…
Select the entire table by clicking on the small box at the top left corner of the table. The table gets highlighted. Press the backspace key.

MS Outlook:

How to add the email address of a sender to your Contacts quickly?
Try this…
"Drag the email from the INBOX and drop it on the CONTACTS icon shown in the Outlook Bar or Navigation Bar."
The email of the sender will automatically be added onto a New Contact form. The contents of the email also get added to the memo area on the right side of the form. If your contact's email has their signature at the bottom, you can control copy the signature data to Job Title, Company, Address, Phone and other fields.

MS Excel

How to resize a column to the width of the longest text in the column?
The column in your excel sheet may not be wide enough to accommodate and show the whole text in that column.

Try this…
Hover your mouse on the right edge of the column next to the column name which you want to resize. When you see a split arrow, double click on the edge. The column will resize to the longest text in that column.

MS Excel

How to insert multiple rows at a time?
You can insert multiple rows at the same time rather than inserting it one by one.

Try this…
Select the number of rows you want to insert by keeping the left mouse button pressed and dragging it over the row number. Let go the mouse when the selection is done. Keep the mouse pointer on the rows selected. Right click and click Insert.

MS Excel 2010

How to make the text fit in a cell?
The text you want to fit in a cell of a spreadsheet might be too big. To make it fit in one cell

Try this…
Select the cell and in the “home” tab, “alignment” group press the “wrap text” button. The row height will automatically increase to fit the text in the cell.

vancouver_class_location
Vancouver Training Site
vancouver_excel_classroom
Classroom
vancouver_classroom
Classroom
vancouver_classroom
Classroom

Rapid Computer Training Inc.
Email: info@rapidtraining.ca
© 2005, Rapid Computer Training Inc.

About Us

Contact Us

Privacy Policy

Training      For             All