TECH TIPS NEWSLETTER - 12/29/06
- By Matthew D
- Published December 29, 2006
- 2006 Newsletters
- Unrated
Did you ever notice when you are working in an EXCEL worksheet that the default worksheet contains lots of columns and rows? It's easy to reduce the size of the sheet. After you've added the data to the workbook, delete all of the rows after the last cell. Then, delete all of the columns to the right of the cell that do not contain data. Press CTRL & S to save the file. The next time you access the spreadsheet, the file will be more convenient and smaller!
TECH TIPS NEWSLETTER - 12/15/06
- By Matt H
- Published December 15, 2006
- 2006 Newsletters
- Unrated
GOOGLE CHECKOUT
If you are like most consumers, you are doing a lot of your shopping online. There is an easier way to shop securely and track your purchases in one place, Google checkout! Sign up for a FREE Google check out account and enjoy an online portal to all of your purchases and shipping information with only ONE user name and password to remember!
TECH TIPS NEWSLETTER - 12/01/06
- By Matt H
- Published December 1, 2006
- 2006 Newsletters
- Unrated
PRINT PREVIEW SHORTCUT
Did you know that you could PRINT PREVIEW in word by pressing the CTRL +F2 key?This shortcut comes in handy when you can't get to your mouse!Just hit CTRL +F2 to get back to your main document.
TECH TIPS NEWSLETTER - 11/17/06
- By Matt H
- Published November 17, 2006
- 2006 Newsletters
- Unrated
READY FOR VISTA?
Visit Microsoft.com at the link below and you can download a free tool that will let you know if your system is ready for the new VISTA operating platform!
http://www.microsoft.com/windowsvista/getready/upgradeadvisor/default.mspx
TECH TIPS NEWSLETTER - 10/27/06
- By Matt H
- Published October 27, 2006
- 2006 Newsletters
- Unrated
IMPORTING INTO POWERPOINT
Many people like to work in Word as much as possible and then import the Word document into PowerPoint. To do this, run Word and open the document you want to use in PowerPoint. Now choose File/Send To/Microsoft PowerPoint. This will open PowerPoint and load the current Word document into a new slide show.
TECH TIPS NEWSLETTER - 10/13/06
- By Matt H
- Published October 13, 2006
- 2006 Newsletters
- Unrated
REARRANGE TOOLBARS IN IE
Somehow, your address bar is not where it used to be and you suddenly have a Yahoo, Google and AOL toolbar when you start up Internet Explorer. It’s easy to control your tool bars and gain control of your Internet experience. Open IE and click VIEW, TOOLBARS. Make sure that “Lock the toolbars” is not clicked. Next, LEFT CLICK your address bar and drag it to where you want it to be. Click VIEW, TOOLBAR and UNCHECK any of the toolbars installed that you do not want to see when you open IE. You can even clean up the ICONS on your toolbar by clicking VIEW, TOOLBARS and CUSTOMIZE.
CYCLE FONT COLOR IN EXCEL
You can add a handy icon to your Excel toolbar that will allow you to cycle through all of the font colors in a spreadsheet! Changing font colors can be just a click away if you follow the steps below…
TECH TIPS NEWSLETTER - 10/06/06
- By Matt H
- Published October 6, 2006
- 2006 Newsletters
- Unrated
HIDE A WORKSHEET IN EXCEL
If you are working on an EXCEL document and you want to share it, but not ALL of it, you can hide a worksheet. Hiding a worksheet does not delete it; it simply “hides” it. To HIDE a worksheet, click the worksheet that you want to hide. On the FORMAT menu, point to SHEET and then HIDE. To UNHIDE, just click the FORMAT menu, point to SHEET and click UNHIDE. A box will appear listing the worksheets. Click on the worksheet that you want to unhide and click OK.
TECH TIPS NEWSLETTER - 09/22/06
- By Matt H
- Published September 22, 2006
- 2006 Newsletters
- Unrated
If you are tired of fighting with your mouse when editing a word document, try a new trick!If you want to select a block to text to change, delete, copy, etc., simply place your cursor at the beginning of the text, hold down the SHIFT key and place your cursor to the end point.It's much easier than holding down the right mouse button and dragging your mouse around the page.Try it!
TECH TIPS NEWSLETTER - 09/22/06
- By Matt H
- Published September 22, 2006
- 2006 Newsletters
- Unrated
If you are tired of fighting with your mouse when editing a word document, try a new trick!If you want to select a block to text to change, delete, copy, etc., simply place your cursor at the beginning of the text, hold down the SHIFT key and place your cursor to the end point.It's much easier than holding down the right mouse button and dragging your mouse around the page.Try it!
TECH TIPS NEWSLETTER - 09/08/06
- By Matthew D
- Published September 8, 2006
- 2006 Newsletters
- Unrated
ADD SOME STYLE TO EXCEL WORKSHEETS
If you are working in an excel worksheet and you want to format certain cells to do the same thing, you can create a CUSTOM STYLE to make life easier! For example, if you want all of the cells that contain a TOTAL calculation to be RED, IN CURRENCY and have DOUBLE LINES above them, follow the steps below:
- Click on one of the TOTAL cells in your worksheet
- Go to FORMAT/STYLE
- In the name box, type TOTAL CELL
- Click MODIFY
- Under the Number tab select CURRENCY
- Under the Border Tab select DOUBLE LINE then click on the upper border
- Under font, select RED
- Click OK twice
2006 Newsletters