Class
Descriptions		 Private
Training		 Technical Services Entre
Directory		 New
Location		 Entre
Home Page

Tips and Tricks
 The following tips and tricks are taken from the classes taught at Entre.  If you would like to be walked through these tricks and many, many more, check out our classes given every month.
 

Newest Tip

To Open Windows Explorer with the Keyboard: Hold down the WinKey+E
Previous Tips

In Excel or Word: to increase or decrease the Zoom level for viewing.  Hold down the Ctrl key and roll the scrolling wheel on your mouse.

When using Internet Explorer to view web pages, if you press F5 it will refresh the page to the most current changes.

In Excel: to move the cell selector to the last populated cell in a column, point to the bottom center edge of a cell and double-click. Double-clicking on the right edge takes you to the last populated cell in the row.  Double-clicking on the left edge takes you to the last populated cell in the row. 

To Double Underline in Excel: Select cells to double underline and hold down the Shift key and click on the Underline button on the Tool Bar.
To Move an entire paragraph up or down in Word: Place the cursor anywhere in the paragraph and hold down the Alt key and the Shift key and press the up or down arrow.
To Copy a PowerPoint Slide into another Application: In PowerPoint, click on View, Click on Notes Page.  Right click on the slide, click on Copy.  Go to where you want to copy it and Right click Paste.

In Excel to Drag and Drop the contents of selected cells to another sheet: Hold down the Alt key while dragging with the white arrow pointer and point to the sheet tab to move to, then point to the cell tot move to and release the mouse button then the Alt key. To copy, hold down the Alt + Ctrl key while dragging.

To Print what is displayed on your Screen: Press the Prnt Scrn button on your keyboard (this is above the Insert key on most keyboards),  then open Word or WordPad and press Ctrl+V to paste the image you just copied to the clipboard.  Then you can print this or save it as a document.

In most most programs, even on the Desktop, instead of Right Click, Properties, you can press Alt+Enter.

Anytime in a Windows program you get somewhere you really do not want to be press the Esc key in the upper left hand corner of your keyboard.  This is the same thing as clicking on the Cancel Button.  It will make the quick menu go away when you have right clicked by mistake.
To Avoid the "Run away mouse" when selecting text or cells hold down the Shift key and press one of the Arrow keys until you have finished your selection.
In Access, to Bring up the Database Window: Press F11
In Microsoft Internet Explorer to automatically insert the www. at the front and the .com at the end of a URL.  Type the website name like entre-roanoke and press Ctrl+Enter.
To Double Underline in Word: Hold down the Ctrl key and the Shift key and press the D key.
To Move the contents of one cell to another In Excel: Point to the cell until you see a white arrow.  Hold down the left mouse button and drag the mouse pointer to the cell you want to move to.  Let go of the mouse button.
In PowerPoint, to Duplicate a Slide in the Slide Sorter view : Select the slide to duplicate, down the Ctrl key and press D
To select an entire paragraph in Word: Place the I-beam pointer anywhere in the paragraph and click three times.
In Access, to move to the Next record same field: Hold down the Ctrl key and press Page Down
In Access, to move to the Previous record same field: Hold down the Ctrl key and press Page Up
To Link the Contents of one cell to another cell in Excel: Point to the border of the cell until you see a white arrow. Drag with the Right mouse button to the cell in which to place the link, let go of the mouse button. Click on Link Here.
To Increase the Font Size in Word, PowerPoint and FrontPage: Hold down the Ctrl and Shift key and press the > symbol.
To Decrease the Font Size in Word, PowerPoint and FrontPage: Hold down the Ctrl and Shift key and press the < symbol.
To make the Format Painter button Sticky: Double-Click on the format Painter button on the Toolbar of Microsoft Office Applications to be able to paint the format of a selection over and over.
To Capitalize the First Letter of a word in Word: Hold down the Shift key and press down the F3 key until the capitalization is what you want.
To Automatically Change the Width of a Column to Fit the Widest Entry
In a Word Table: Position the mouse pointer at the right most edge of the column until you see a black two-headed arrow pointing left and right.  Double-Click.
In Excel: Position the mouse pointer between the Gray Lettered Column heading until you see a black two-headed arrow pointing left and right.  Double-Click.
In Access: Position the mouse pointer between the Gray Named Column heading until you see a black two-headed arrow pointing left and right.  Double-click.
To Remove all Borders from a Word Table, make sure your flashing cursor is in the table, then hold down the Alt and Ctrl keys, then type a U.
To Copy a Formula down a column in Excel, get the Fill Pointer (+) by pointing to the bottom right-hand corner of the cell with the formula and double-click.
To select All, in almost every Windows Program including Word, Excel, PowerPoint, Outlook and Access, just hold down the Ctrl key and type an A.
To exit any Windows program, you can just hold down the Alt key and press the F4 key.  This is especially important to know if your mouse stops working or if you use a laptop.


Have you added Entre's Website to your Favorites or Bookmarks?
We will continue to add tips and update the Class Calendar and Events.
Check us out again soon.