tag:blogger.com,1999:blog-23858118666218173512012-01-29T20:07:43.084-07:00Geeks live it, nerds talk it. I am a Nerd.Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comBlogger541100tag:blogger.com,1999:blog-2385811866621817351.post-74160907241577143402011-10-12T12:02:00.005-06:002011-10-12T12:07:25.035-06:00

A customer of mine recently wanted to know why her pictures appeared to have a layer of line impressions. We went through her printing process and made some adjustments that cleared up the problem. (But I have to tell you, it's cheaper and you'll get better results by taking your flash cards to Office Max, Walgreen's, or even Costco to get them printed.) In this case, she wanted to print a

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-22173150946060893442011-10-12T11:44:00.001-06:002011-10-12T11:45:12.939-06:00

MS Office 2010 has been out for awhile now and I recently did the "Big Install". I opened up Word to take a look and I see these light blue crop marks on the top and bottom corners of the document screen. My first thought was, "Huh?", followed quickly with, "Go Away." Here are the steps to turn that feature off: Open Word 2010 a. Click File, Options, Advanced on the left panel b. Under the

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-20324061263662681462011-10-12T11:38:00.001-06:002011-10-12T11:38:52.147-06:00

The "CTRL" key is a powerful tool in Excel. Open Excel - any version: - Ctrl and click random cells. This will select a range of non-adjacent cells. - Ctrl + A will select the entire spreadsheet (if empty), or the range of data (if data is present) - Ctrl + Home moves the active cell to A1 - Ctrl + End moves the active cell to the last cell with data entered. (But goes nowhere if the

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-66252730636834755102011-10-12T11:31:00.000-06:002011-10-12T11:31:27.964-06:00

The vital role of Formula Auditing. An amazing but little known tool in Excel. Trick 1) F2 Key, Shows formula in current cell (rather than looking up at the Formula Bar) Trick 2) Ctrl ~, Show all formulas in worksheet (~ is located below the Escape key) Trick 3) Formula Auditing, draw arrows to formulas (Add to your Quick Access Bar) See Examples on this Video

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-89542147620425236642011-10-12T11:21:00.000-06:002011-10-12T11:21:36.302-06:00

You read that right. You can total the columns, rows, and Grand Total in just 2 clicks. View this quick video and be smarter and happier. Trick 1) Total all columns at once Trick 2) Total all columns and rows at once Trick 3) The 2-Step Chart

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-20517118000466211052011-10-12T11:12:00.001-06:002011-10-12T11:15:35.677-06:00

One of the best kept secrets in Excel is the amazing 'Fill Handle' for data entry purposes. Watch this video, the link will take you to a screen demonstration with me talking in the background: Excel Fill Handle Video I would type it all out, but it would be a page long and the video is only one minute long.

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-27057158108869325662011-10-12T11:09:00.001-06:002011-10-12T11:09:45.597-06:00

Adding new columns within your Excel spreadsheet is super easy: Right Click, Insert, Columns. And then I learned a new way recently and just shook my head. (Old dog, new trick syndrome...) This works on Rows or Columns: Click the row or column header (A,B,C.. or 1,2,3..) Press CTRL + (plus sign) to add a column or row Press CTRL - (minus sign) to delete a column or row

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-31392880593638509562011-10-12T11:06:00.000-06:002011-10-12T11:06:22.832-06:00

If you enter any block of data into Excel, you can produce a chart in 2 quick steps: 1. Click into one cell of the data (Excel will assume all adjacent cells should be included.) 2. Hit the F11 key at the top of your keyboard. Shazam! There's your 2 step chart!

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-65793911610598406772011-10-12T11:00:00.002-06:002011-10-12T11:04:14.414-06:00

An Excel Data Form is a useful data entry tool if you have the tedious job of entering data. (I avoid this at all costs, but periodically I have to cave.) The reason you would ever use a "Form" is if the database you are using is vertically or horizontally off the screen. Go through the steps below and if you find it useful, then you have saved a little sanity. Otherwise, just ignore this. As

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-55421872911705992112011-10-12T10:57:00.001-06:002011-10-12T11:04:24.951-06:00

In Excel, when you type an email address into a cell it automatically changes to a Hyperlink. (Tip: to Undo that automation, just hit Ctrl Z immediately after it happens. You can also Right click the hyperlink and choose "Remove Hyperlink") Anyway, when you type an email address and it automatically changes into a Hyperlink that you want to keep, how do you then select that cell without

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-9805219096237937112011-10-11T17:01:00.001-06:002011-10-11T17:02:32.557-06:00

My definition of MetaData: Hidden threads of document changes, revisions, the author's name, and various other incriminating details that travel along with a Word document like fingerprints on a drinking glass. No big deal, you can't see that info, right? In the wrong circumstances, like a legal action, metadata could ruin your case. How to remove them... My disclaimer: I do not normally do

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-81532497746645446612011-10-11T16:57:00.000-06:002011-10-11T16:57:03.586-06:00

Creating a Watermark in Excel 2003 & 2007 Watermarks are dim images in the background of a spreadsheet. 'Back in the day' we could identify quality paper from the watermark imprint. 'Nowadays', a watermark can be any word or image you like. Ex: Confidential, Draft, company logo, etc. Here's how to make one in Excel... Excel 2007 1. click Insert, and then in the Text section, click Header &

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-31404569653935082632011-10-11T16:52:00.001-06:002011-10-11T16:54:04.765-06:00

Watermarks are dim images in the background of a document to mark them as Confidential, Draft, a company logo, etc. Here's how... Word 2007 or 2010 1. On the Page Layout tab, in the Page Background group, click Watermark. 2. Scroll through the designs and choose one, or Click Custom Watermark, click Text watermark and then select or type and format the text that you want. 3. To view a

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-33655816062054551622011-10-11T16:37:00.001-06:002011-10-11T16:39:07.248-06:00

Do you work in the corporate world and have that handy list of "Global Contacts" in Outlook? If so, then you know what happens when you click TO: and it opens the GLOBAL list when you really just want your CONTACT list. By default, Outlook searches through the GLOBAL list before searching personal Contacts. Well... you can change that order and put your CONTACT addresses first. Here's how... 1

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-91715431501497505452011-10-11T16:23:00.002-06:002011-10-11T16:29:22.381-06:00

Last week, for some freak reason, an email would come into my Outlook, appear long enough for me to notice it and see the first line, then vanish. Great. So the hunt began, clicking through my 50 folders (yes... 50) trying to find where it landed. No luck. So I have this saying... Whenever you have the question "How Do I ____fill in question here___", the answer is "Right Click". How do I

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-89290727803041276832011-10-11T16:11:00.001-06:002011-10-11T16:13:31.126-06:00

Question: "When I enter a new contact in my Outlook 2003 it automatically inserts a (651) area code for the phone number. How can I change this to (208)?" Answer: "You are looking for the Phone and Modem dialing rules. Try this: 1. Open any contact. On the toolbar click on Actions > Call contact > New call (For 2007 or 2010 versions, click "Call > New call") 2. Click Dialing Properties, then

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-77466094900632998222011-10-11T15:59:00.001-06:002011-10-11T16:00:19.560-06:00

If you use Outlook Exchange, it's easy to click Tools, Out-of-Office Assistant. But if you don't use Exchange, how do you get your email to "Auto Respond" while you are away? Here is the answer... This is called an "Auto Responder" and isn't a part of the stand-alone Outlook version. Instead you will find it on your web email software. Since your email domain is @yourdomain.com, then you

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-32971556422730423792011-10-11T15:36:00.005-06:002011-10-11T15:48:38.222-06:00

Sometimes, I just need to add a note on my email Inbox list to remind me what to do with a certain email. Here are the steps to get there... Or watch me apply it at this link. In Outlook Email view... 1. Click View, Current View, Customize Current View You will be working with 2 buttons in here: Fields and Other Settings 2. Click Fields; click the "new field" button, type a name for

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-42261222398196858012011-10-11T15:25:00.004-06:002011-10-11T15:29:13.128-06:00

Note: This does not apply to "Outlook Express" With Outlook, you can Color Code emails as they arrive in your Inbox. Color coding helps target specific messages. Here's how... (works in both Outlook 2003 and 2007) Assign a color to a message from a specific person. 1. Select a message from a person that you want to change to a color. 2. From the Tools menu, select Organize 3. Select the "

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-53952744144448747922011-10-11T15:16:00.003-06:002011-10-11T15:22:38.753-06:00

If you use MS Outlook as an email, calendar, and contact manager, then you are familiar with switching screens back and forth to check your calendar. This trick works best if you have two monitors on your desk. It still works with one monitor, but your best results are with two. Basically, you can place your email on one screen and your calendar on the other. This saves a ton of frustration

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-8936586968407524682009-12-28T15:25:00.012-07:002011-07-03T11:06:18.951-06:00

Have you ever used color-coded file folders in your office? Of course! The red ones mean "this", the yellow ones mean "that", etc. They help because at a glance, you know the topic of the colored folder. Outlook offers the same priority coding in the calendar. Here's how to use it: (works Outlook 2003, 07 and 10) 2003 version: Right click an appt, choose "label", and choose a color. (You can

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-23543847966163092672009-12-28T15:24:00.006-07:002011-07-03T11:11:47.470-06:00

Many times throughout my day I am looking ahead at my calendar, shifting, adding, deleting, and scheduling appointments. In fact, besides my email, my calendar is the second most used tool on my computer. But with all that activity going on, the moment my phone rings I need to "re-group" and get back to "Today". Instead of trying to scramble and hurriedly get my screen back to the current date

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-65417291902937137082009-12-28T15:24:00.005-07:002011-07-03T11:11:04.580-06:00

OK - Depending on your profession, your schedule may need multiple appointment slots per hour, rather than just 1 per hour. For instance a dentist may need 15 minute increments, but a phychiatrist may need 1 hour increments. Here's how to adjust the time slots on the Outlook calendar. 1) Open the Microsoft Outlook calendar screen 2) Click the "Week" view button located at the top of the

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-13192953007728278082009-12-28T15:20:00.003-07:002011-07-03T11:12:14.140-06:00

I was writing a letter to the editor and the instructions said my word count had to be less than 300. Well how am I supposed to know without counting each word? Here's the answer... Word 2007: Right-click the status bar (bottom of screen), and make sure there is a checkmark in front of "WordCount". As you type,the word count will be displayed on the bottom left side of the Word status bar.

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-90063376171440787382009-12-28T15:19:00.008-07:002011-07-03T11:13:38.513-06:00

When you are in Microsoft Word, and you are in Print Layout view (View, Page Layout or Print Layout), you will see a ruler on the left side of your document. Move your mouse to the ruler and Double-Click. SHAZAM!! Page Setup magically appears! You'll never go back to the old way of opening your margin settings. Now finish your document, and be happy...

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-2819362584735318222009-12-28T15:19:00.007-07:002011-07-03T11:12:40.499-06:00

When someone emails a Word document to me, and I click to open and read it, it opens in this odd "Reading Layout". It sort of resembles a "storybook" layout. I just want to see the document as it will print without wrestling to get it to look normal. Here's how to disable that pesky feature forever... In Word 2003, 1. Click Tools, Option 2. Click the General tab 3. Unclick the box "Allow

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-61578188384336514722009-12-28T15:18:00.002-07:002011-07-03T11:14:18.021-06:00

Swapping paragraphs in Microsoft Office Word can be complicated. As well as having to cut and paste, you often have to reformat line breaks afterward to make the paragraph line up properly. There is a trick in Word 07 that allows you to use the SHIFT+ALT keyboard shortcut. Click the paragraph that you want to move, hold down SHIFT+ALT, and move the paragraph up or down by using the arrow keys.

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-30461607477292980842009-12-28T15:14:00.008-07:002011-07-03T11:15:57.283-06:00

My friend Anthony called me immediately after he had accidentally deleted 1300 pictures. And he was thorough... he also emptied his recycle bin. Well, I didn't have an answer for him, but he found a great one and shared it with me. I'm passing it onto you: www.recuva.com It's Free, easy, and he was able to retrieve all 1300 pics within a few minutes. Don't Delete your Pictures!

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-26824989791934182562009-12-28T15:14:00.007-07:002011-07-03T11:15:06.227-06:00

I remember way-back-when how easy it was to print a screen. We just hit the "Prt Scr" button on the keyboard above the Home and End keys, and immediately the printer would engage and shoot out a piece of paper with our screen on it. Then Windows 98 appeared and it all changed. Unfortunately, many of us never learned the new (hidden) step. If you need to print a certain window or dialog box (

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-73382888921745100362009-12-28T15:13:00.006-07:002011-07-03T11:16:24.812-06:00

Is it possible to change a Desktop Icon's picture? Yes. I get bored with those little yellow files on my desktop. Here's how... 1. Right click the icon to be changed, choose Properties. 2. On the Shortcut tab choose the button "Change Icon..." 3. Choose a new picture in the window or click the "Browse" button and find the Icon picture you made in MS Paint (below)... Can I use one of my own

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-76124021090168201782009-12-28T15:11:00.007-07:002011-07-03T11:20:05.070-06:00

Here is a Computer "Underground" Super Secret: Everyone knows that when you work in an industry for any length of time you learn things that the general public does not know. Tips, Shortcuts, Secrets. Here are a couple I've learned... 1 - If you have to call tech support, exmaple: Dell's Tech Support - (by the way, the phone # is 1-800-INDIA) - and you cannot understand the accent/dialect

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-52853782770179584882009-12-28T15:11:00.006-07:002011-07-03T11:19:05.302-06:00

Sometimes productivity isn't possible if you're away from your main computer. For instance, I teach a class on Digital Cameras and demonstrate photo manipulation. But the lab computer does not have PhotoShop. My home office computer does. To teach the class productively, I remotely access my home office computer. To do that, I have to use a remote access product. Productivity Secret #3.

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-81754116180061558952009-12-28T15:10:00.003-07:002011-07-03T11:23:12.447-06:00

While you are reading this, right now, press and hold Control on your keyboard and scroll the mouse wheel up or down. Welcome to the Super Secret of Zoom control! No matter where you are or what you are looking at, the moment you feel your eyes squinting, just press Ctrl and Scroll the mouse wheel. So even if you can't find a Zoom button, this trick will work. Another tip to zoom control, is

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-14547310086618245292009-12-28T15:09:00.003-07:002011-07-03T11:21:39.853-06:00

Here is a Computer Secret that I use just once in awhile - but it's a Biggy: System Restore - the best thing Microsoft ever did for their customers. This will save you tremendous hours of heartache by re-setting whatever FREAK thing happened to your computer. I am a power user; I know what I am doing, and still I have to do a System Restore about every two months. Unexplainable things happen

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-64721336912880764122009-12-28T15:08:00.007-07:002011-07-03T11:24:01.723-06:00

It seems like the your computer is the all important tool, until you lose your files and you realize the computer is just the box that held the important stuff. You MUST backup computer files on a regular basis. And there are many methods to accomplish this. I'll list them here, you choose 1, 2, or more, and then make it a priority to put your choice into action! 1a) Manually back up your

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-78188224221789129492009-12-28T15:08:00.006-07:002011-07-03T11:23:39.878-06:00

For External computer care, a can of air to blow out the keyboard and an alcohol pad to clean the keyboard and mouse are standard in my desk drawer. And NEVER use Windex or alcohol on your monitor. You will streak the optical coating and you'll regret it forever. Only use water and a soft cloth. The Internal computer care is a little more intense and takes more time and knowledge. 1.

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-46025456285768615302009-12-28T15:07:00.003-07:002011-07-03T11:24:32.905-06:00

This is an important topic; have you seen the price of computers? They're incredibly low! Buying a new computer isn't such a bad idea. But it's a hassle to buy a new one. All that time to transfer files, install software, the expense of buying software you already have on your old computer, and the list goes on. Instead of buying a new computer, I'm going to upgrade the one I've got this

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-73538936878194837732009-12-28T15:06:00.002-07:002011-07-03T11:25:25.007-06:00

Does your home office have various cords and plugs and gadgets scattered around, laying on shelves, in the bottom of boxes, and at the back of a drawer? You find random USB cords that you *think* came with your digital camera, but you're not really sure... Hmmmm. Solve this chaos by designating one spot for all cords. Go to any Walmart to the plastic bin section and purchase a $15 3-drawer

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-28149463018573407532009-12-28T15:05:00.002-07:002011-07-03T11:26:02.412-06:00

There are just some things in my office that I can't live without. I highly recommend these simple and inexpensive items so your computing time is streamlined. I buy as much of my stuff online at Newegg’s Electronic Store as possible, but I also take a look at clearance tables at my local office supply stores. I use a laptop, so a laptop stand recovers desktop space and I store my notepads

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-56119782030223661552009-12-28T15:01:00.003-07:002011-10-12T11:58:27.816-06:00

Microsoft SmartArt graphics allow you to create high-impact, professional diagrams. Instead of spending hours designing your own, use Microsoft Office 2007 to focus on the visual message that you want. The SmartArt Designs are available in all the 2007 Office programs: Word, Excel, PowerPoint, Publisher 1. On the Insert tab, click the SmartArt button. 2. In the list of diagram categories,

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-69036925848594254892009-12-28T14:59:00.003-07:002011-07-03T11:34:10.089-06:00

An audience is an interesting animal and your presentation can tame them or turn them against you. Here are some tips to keep them focused on your message and not on the LENGTH of the message while itching to escape. 1) Use a white background on your slides. It lights up the room and keeps them alert 2) Don’t “read” your slides. There is nothing worse than having someone read what is on the

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-88771626007927957872009-12-28T14:57:00.002-07:002011-07-03T11:35:44.933-06:00

Would you like to have access to your slide notes during a PowerPoint presentation--without printing? Microsoft Office PowerPoint 2003 and 2007 feature a multiple-monitor view that can display your presentation on one monitor and your notes on a 2nd monitor. But your computer must have two video cards: if you can connect a projector or 2nd monitor to your system, then you have a spare video

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-86985290948009036032009-12-28T14:55:00.003-07:002011-07-03T11:36:13.994-06:00

I'm big on organizing my piles and piles of papers. With Microsoft Outlook, you will eventually accumulate piles and piles of contacts. You need to keep them organized. There are 2 methods: (and I use both of these simultaneously) 1) Create Contacts folders (or "add folders") and move the contacts into their designated folders. Here's how: a. Float your mouse over the word "Contacts" and Right

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-91854857952620459452009-12-28T14:52:00.004-07:002011-07-03T11:36:34.577-06:00

So many contacts, and now... so many folders of contacts. I literally have 28 folders of contacts that apply to many industries. So I seperate my contacts by the industry: School, Business, E-commerce, and personal groups like Family, Hobbies, Holiday Cards, etc. Then my contact folders were so long and alphabetized, that my family folders were intermingled with business folders. Do you see

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-80255781152382952082009-09-15T13:59:00.004-06:002011-07-03T11:37:14.795-06:00

If you follow my weekly email super secrets, but occasionally need to dig back into your archives to find a particular computer tip, it might be lost, deleted, whatever. It's just gone. So to the rescue comes Andy's "Computer Super Secrets" blog site! Yes ladies and gentleman, at last one place to find all the tips in nice little batches according to subject. Start clicking over on the right

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-55650737797620976562009-09-14T13:34:00.004-06:002011-07-03T11:38:10.463-06:00

Excel 2007 charting is absolutely delightful. The color splashes are beautiful, fresh, and just COOL! I couldn't wait to get started using them, afterall it was the main reason I upgraded to the 07 package. And then I discovered a "teensy little problem". Ugh. My file sizes were gigantic. Even if I saved them as .pdf's, they were still un-mailable, often breaching the 3 mb size, which is

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-3486097990390424272009-09-14T13:30:00.003-06:002011-07-03T11:38:57.239-06:00

First of all, what is an Excel comment?  It's basically a post-it note attached to any cell in the spreadsheet. Open a spreadsheet, and in any cell hit your right-mouse button. Choose "Insert Comment" and you will see a little yellow post-it appear. Type anything in it and click away from it. A small red triangle is left in the cell. The triangle will not print, but if you float your mouse

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-24145275483298332262009-09-14T13:23:00.004-06:002011-07-03T11:39:40.034-06:00

My friend Bill writes: Andy, for some reason my attachments are not showing in the heading of my e-mails, but are in the body of the e-mail as a square icon. Is there a way to change this so it does not appear in the body of the message but on an attachment line? (I think this may have started when I had our company e-mail tech support fix some problems I was having.) Answer: It's an easy fix

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-65664775396530806652009-09-14T13:16:00.003-06:002011-07-03T11:40:30.674-06:00

Outlook has a featured called "automatic completion" for any email address typed into the To or CC fields. This feature does not pull from the contacts or address book, rather, it adds names to the auto complete list as you type them. The problem comes in when you add a bad address, and then each time you start to type in the address, the incorrect one appears in the list. To fix this problem,

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-14900819187778860812009-09-14T13:13:00.004-06:002011-07-03T11:42:38.771-06:00

Outlook allows up to 2 active signatures for each email account on your system depending on if it's a NEW email or a REPLY email. For instance, I have 5 active email accounts (I know, I'm neurotic but I can't help it!) and I have about 7 signatures set up, but can only use 2 per account. Well, all that changes with Outlook 2007. Not only can you still have multiple signatures, but you can use

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-80746949386678552582009-09-14T13:06:00.004-06:002011-07-03T11:43:34.130-06:00

Microsoft Outlook is configured to block automatic picture downloads from the Internet. This can help protect your computer. But you can unblock pictures you feel are safe to download. Advantages of blocking automatic picture downloads include: - Avoid viewing potentially offensive material (when external content is linked to the message). - Keep malicious code from damaging the data on your

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-70063780719618490942009-09-14T12:55:00.006-06:002011-07-03T11:44:00.284-06:00

Take a look at your list of Outlook contacts. Have you ever noticed the vertical lines between the columns? They have a purpose: (If you don't see the lines, check the left panel under "Current View" options. Click "Address Cards") 1) You can drag the lines to widen or shrink the column width 2) You can sort the contacts with a right click on any vertical divider line. • Right-click the

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-78423477781410485212009-09-14T12:41:00.003-06:002011-07-03T11:46:37.874-06:00

In technology, the term "backdoor" originally meant a "hidden code" or "secret sequence". It has come to also mean "A unique way of getting something done by going through a different door."  I was in a seminar recently and saw the speaker use the Outlook signature feature as a quick autofill of text to eliminate redundancy. I could not believe my eyes. A backdoor use of signatures. Brilliant!

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.comtag:blogger.com,1999:blog-2385811866621817351.post-62485094049085844982009-09-01T15:20:00.001-06:002011-07-03T11:47:17.071-06:00

Privacy Policy for ComputerSuperSecrets.blogspot.com If you require any more information or have any questions about our privacy policy, please feel free to contact us by email at super_secrets@aweber.com. At ComputerSuperSecrets.blogspot.com, the privacy of our visitors is of extreme importance to us. This privacy policy document outlines the types of personal information is received and

Chief Nerdhttp://www.blogger.com/profile/02618589046980181996noreply@blogger.com