Website
Design
Website
Redesign
Maintenance
Portfolio
Other Consulting
Accounting
 
Microsoft Office Tips & Tricks
Home
Page
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
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.

Call us or email us to create your website or assist you with Microsoft Office today!