Newest
Tip |
To Add Classic
Menu to Microsoft Office 2007: Go to
www.ubit.ch/software/ubitmenu-languages/ Follow the directions to
download the free version or buy the corporate version for multiple
licenses. This program adds a Menu tab to the Ribbon that
lets you use the old pull down menus and the Standard Toolbar. |
Microsoft Office
Tips |
Keyboard shortcut
for the Format Painter in Microsoft Front Page, Microsoft Word and
Microsoft PowerPoint: Select the text with the format to copy
and press Ctrl+Shift+C, then select the text to paste the format
on and press press Ctrl+Shift+V |
Microsoft Access
Tips |
In
Microsoft Access to Copy Data from the previous Record in the field your
cursor is in:
Press Ctrl+' (apostrophe) |
To Bring up the Database Window: Press F11 |
To move to the Next record same field: Hold down the Ctrl key
and press Page Down
To move to the Previous record same field: Hold down the Ctrl key
and press Page Up
|
Microsoft Excel
Tips |
To Duplicate or
Copy the contents of
a cell: go to the
cell below the one you want to copy and press Ctrl+D |
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. |
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. |
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 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.
|
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 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.
|
Microsoft PowerPoint
Tips |
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 PowerPoint, to Duplicate a Slide in the Slide Sorter view: Select
the slide to duplicate, down the Ctrl key
and press D
|
Microsoft Word
Tips |
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
Move an entire row up or down in a Word Table: Place the cursor
anywhere in the row and hold down the Alt key and
the Shift key and press the up or down
arrow. |
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 Double
Underline in Word: Hold down the Ctrl key and the Shift key
and
press the D key.
|
To
select an entire paragraph in Word: Place the I-beam pointer
anywhere in the paragraph and click three times.
|
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.
|
Microsoft Windows
Tips |
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
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 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. |
When using
Internet Explorer
to view web pages, if you
press F5 it will refresh the page to the most current changes. |
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
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
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 Open
Windows Explorer with the Keyboard: Hold down the WinKey+E |
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. |
To Check
When a Website was last updated: Open the website in either
Explorer or FireFox and type in the address bar:
javascript:alert(document.lastModified) and press Enter. |
Have
you added the Abacus Website to your Favorites or Bookmarks?
We will continue to add tips
Check us out again soon.
|