http://www.aistechnology.com/site/Viewer.aspx?iid=362&mname=ArticleGroup General Software Tips en-us 60 We are giving the tips the month off for July. See you in August! Mon, 14 Jul 2008 11:00:00 CST http://www.aistechnology.com/site/Viewer.aspx?iid=5465&mname=Article http://www.aistechnology.com/site/Viewer.aspx?iid=5465&mname=Article Do you spend a lot of time beautifying Excel spreadsheets after you have entered your data into them? There is a quick and easy way to automatically have Excel adjust the width of all the columns that contain data in them and it takes only three mouse clicks to do it! The secret to this tip is to enter all your data first or at least get your column headings in place and formatted. After you have that completed, highlight the entire spreadsheet by clicking one time on the square in the upper left hand corner of your spreadsheet – above row 1 and to the left of column A. Then place your mouse cursor between any two columns – it doesn’t matter which two. Your mouse cursor will change its appearance something that looks like a single bar in between to outward pointing arrows – when that happens you are in the correct place. When you see that cursor, simply double-click your mouse. Any columns containing data will automatically be widened to the first the longest piece of data in that column. You can repeat the steps above any time you would like to readjust your column widths! And that’s a quick and simply way to adjusting your column widths, so… Give It A Try! If you would like a printable version of this tip, click here. Sun, 08 Jun 2008 13:44:00 CST http://www.aistechnology.com/site/Viewer.aspx?iid=5463&mname=Article http://www.aistechnology.com/site/Viewer.aspx?iid=5463&mname=Article Internet Explorer – Organizing Your Favorites There are many options for sorting your favorites in Internet Explorer. My two favorites are creating folders and alphabetizing entries. If you have a number of favorites that fall into the same category, like at home I have entries to do with my kids’ school, my online bill pay entries, and all of Nick’s “stuff”. So to be able to find a favorite quickly, I created folders for my favorites called – School, Financials, and Nick. After creating the folders, I moved the appropriate favorites into their new folder homes. Now when I go to look for something, I don’t have a GIANT list of entries. The other trick I LOVE is sorting the list of favorites in alphabetical order. This one is SO EASY and handy. It will take your existing favorite entries and organize them alphabetically making finding an entry a snap. Folders will be alphabetically organized at the top of the list, with regular entries coming next, also alphabetically ordered. Instructions for Internet Explorer 6.x – Creating Folders While in Internet Explorer, click on the Favorites menu from the tool bar at the top of the screen. Then click on Organize Favorites. The box on the left will appear, click on the Create Folder button, type in your new folder name and press the enter key. Repeat these steps for every new folder you want to create. Once your folders have been created, moving entries into them is done in the same Organize Favorites window on the left. Just highlight the favorite you want to move to a folder in the list in the window, then click on the Move to Folder button and select the folder you want to move it into and click OK. Repeat these steps for every favorite you want to move. (An even faster way to rearrange your favorites is just pick up the favorite you want to move and drag and drop it onto the folder in which you want it stored.) Alphabetizing Favorites After you have created all your folders and moved your favorites around, you can alphabetize the entries. While in Internet Explorer, left click on the Favorites menu from the tool bar at the top of the screen. Then right-click anywhere INSIDE the Favorites menu and choose Sort by Name. Instructions for Internet Explorer 7.x are basically the same. The Organize Favorites box is a little different. The buttons are named New Folder instead of Create Folder and Move instead of Move to Folder. And that’s how you organize your Internet Favorites – helping you find favorites faster, so… Give It A Try! If you would like a printable version of this tip, click here. Tue, 06 May 2008 09:22:00 CST http://www.aistechnology.com/site/Viewer.aspx?iid=5461&mname=Article http://www.aistechnology.com/site/Viewer.aspx?iid=5461&mname=Article Microsoft Word – A new spin on AutoCorrect Many of you are familiar with the AutoCorrect feature found in Microsoft’s Word (Excel and Outlook) programs – you make a common typo like “ADN” and the system automatically changes it to “AND” for you. What a great feature for people like me who are really good at typos! But did you know that you can add entries to your AutoCorrect and save yourself some serious time? Let’s say you have a company policy in place that says anytime you reference your company you must use the legal entity name – for this example your company name is AIS Technology, LLC. That’s a lot of letters, not to mention capitalization and punctuation! I can add an entry to my AutoCorrect list so that every time I type in “atl” the system will replace those letters with “AIS Technology, LLC”. It’s pretty cool! You can do the same thing with a disclaimer sentence or common closing sentence for your emails! You type “typ” and the system changes it to “Thank you so much for your prompt attention to this matter.” To modify your AutoCorrect list in Word 2003 – From the Menu Bar, choose Tools, then AutoCorrect Options. You will see the box below. 1. To add an entry to the AutoCorrect list, type the abbreviation you want to add in the Replace: column and type your full text (with punctuation and capitalization if appropriate) in the With: column. 2. Then click the Add button. Repeat these steps for every entry you want to add! To modify your AutoCorrect list in Word 2007 – Click on the Office Button in the upper left hand corner of the Word window and choose Word Options. Select Proofing from the list on the left, then click on the AutoCorrect Options button on the right. Then follow steps 1 and 2 above to add entries. A couple of things to keep in mind – • Office 2007 shares the same AutoCorrect list across Word, Excel and Outlook – older versions may not – so you MAY need to add AutoCorrect entries in the different programs. • Make sure your abbreviations are not letter combinations that you use in your daily life. For example, using “so” as the abbreviation for “Sandy Oliver” would be a bad plan, because every time I typed the word so, it would change it to my name! And that’s how you can save time by autocorrecting your unique abbreviations, so… Give It A Try! If you would like a printable version of this tip, click here. Thu, 03 Apr 2008 11:31:00 CST http://www.aistechnology.com/site/Viewer.aspx?iid=5460&mname=Article http://www.aistechnology.com/site/Viewer.aspx?iid=5460&mname=Article Did you ever wish you could print out just PART of the webpage? You don’t need the entire page – just one little section. Well accomplishing that goal is a lot easier than you may realize!!!! The most difficult part of printing part of a webpage is highlighting the area you want. Because different web developers use different page designs and technologies, so every page can be different – even within the same company’s website. Things to watch out for when highlighting text from a webpage… Columns – If there are columns on a page, and you want information from both columns, you often end up highlighting more than you want. Try highlighting information from each column separately. Pictures – Sometimes what LOOKS like a word, or an article, is really a picture pasted into the webpage, so highlighting just a portion of the picture is next to impossible without special software. Once you have used your mouse to successfully highlight the part of the webpage you want to print, from the Menu Bar at the top of the browser, choose File, then Print. Then in the Print Range box, choose Selection – then Print. And that’s all there is to printing part of a webpage, so… Give It A Try! If you would like a printable version of this tip, click here. Tue, 26 Feb 2008 11:12:00 CST http://www.aistechnology.com/site/Viewer.aspx?iid=5456&mname=Article http://www.aistechnology.com/site/Viewer.aspx?iid=5456&mname=Article