How to remove formulas in excel but keep the values

(Update: 2022-10-03

I have been getting a lot of hits on this particular article. So, I thought I would update it by adding some additional images and a bit more clarity to the subject. I hope you enjoy this article and can benefit from it. Continue reading the main article below and my other articles listed on the left side of this page. And leave a comment if you don’t mind. Thanks.)

 

If you have used Microsoft Excel, or even Open Office Calc (the free alternative to Microsoft Excel) you have most likely used or even created formulas to return a desired value. An example would be;
Column A contains a latitude, Column B contains a longitude and Column C has a formula that concatenates the two together. Here is a sample of that formula in column C:
=CONCATENATE(A2,”, “,B2)

In the formula above, notice the three commas and space between the two quotation marks following the middle comma. Anything you put between the quotes will be shown in Column C, but the quotation marks will not appear. See the sample below.

In this sample, we will put the word “Hello” within the quotes.

And here are the results of that same cell in the Excel sheet.

 

Now, getting back to our real-world example. 

Given the latitude of 34.6528144 and the longitude of -98.4146529 in columns A and B respectively, you get the following result displayed in column C.

As you can see, the results contain the comma and space (between the two numbers) that was specified in the formula between the quotation marks.

 

Okay, I know this article is supposed to be about how to remove the formulas from a calculated cell (or cells) while retaining the resulting data. Instead, all I have discussed so far is how to create a formula in a cell. True, but to remove a stain, you must first understand what the stain is and how it got there. The same theory holds true in a substantial number of aspects of life.

With that said, let’s remove those pesky formulas now that we are done with them. There are many ways you can accomplish this, and I have seen countless chapters in Excel books and dozens of web sites that have you find a specific tool on the toolbar and navigate through a dozen or more options to get your desired results. However, the simplest way is to just select the cell or cells that contain the formulas and press “Ctrl” + “C” to copy them. Next, with the cells selected, press “Ctrl” + “V” to paste the resulting values in the same cells.

Before you just hit the “Enter” key or move on to other things in your life, notice the little “clipboard” looking icon that popped up. It should look something like this: (I know the image is small, but that’s the way it is in Excel, so bare with me.)

Click on it and scroll down the menu to the “Paste Values” section of the list and choose the “Values (V)” option.

Hint, as you mouse over the options (represented by small icons), a tool tip will appear telling you what that function is called. Once you click the “Values (V)” icon, all formulas will be erased and replaced with only the results that it calculated. See the results in the two images below.

Image 1, Before

Image 2, After

Mystery solved! It really is a lot simpler than a lot of web pages make it out to be. As you can tell, I am a firm believer in the K. I. S. S. (Keep It Simple Stupid) method of thought.

 

Thank you for viewing my blog.

Also visit my new “About me” blog at https://www.aubreywlove.com

What to ask repair centers when your PC crashes

Computer repair center cautions.

Who do you trust with your beloved computer and all the data residing on it? It’s a question most of us take for granted as we drop off our computer at the local repair shop. Photo’s, legal documents and passwords are just a few of the things that we store on our computer thinking it is safely tucked away. Once the computer leaves your possession and is placed in a shop, how do you know all is safe?

Below is a list of important questions along with the expected answers you should receive when shopping for a repair center. If you are not comfortable with the answers your getting from a local computer repair shop or individual, you should consider other places.

How much do you charge per hour or service?

Most respectable computer repair centers will charge either by the hour or by task, depending on the issue. The hourly rate should range between $50 – $75 ‘depending on where you live.’ Too high of a price may mean that you are being overcharged and too low may mean that the repairman may not know what he is doing or he may be planning on billing for an excessive amount of hours.

Some services will be billed by “bench hours,” meaning, how many hours the computer is actually on the work bench whether attended or unattended. Expect to pay for unattended hours when your computer is using electricity and bench space while a program is being installed or updated.

Other services will be billed by  “product,” meaning, they charge a flat fee for installing a new video card or power supply.

How many billable hours will this take to repair?

The last thing you want to do is pay $60 hour for nine hours of labor, totaling $540 to repair a computer that can be replaced for three or four hundred dollars. This is where cost vs. reward comes into play. Is it worth it to fix the computer or just purchase a new one?

You should expect to hear from the repairman, “I can’t be totally sure, but these types of repairs in the past have cost an average of (x) dollars to repair. We can certainly call you if we see the cost is going to exceed the value of the computer.”

Don’t be alarmed if the technician can’t give you an exact amount over the phone, some computer problems may seem similar but are very different in reality.

Do you have a minimum charge?

Not all computer problems require nine hours on the work bench. If your issue takes only 15 minutes to repair, you may be slapped with a minimum bench time.

You should expect to hear “yes, we have a one billable hour minimum.” On part replacements, it is also common to have a flat rate for installing new hardware.

Will there be any additional charges?

While some companies stifle you with hidden fees, this simple question should clear the air. No one wants to get a quote only to find out the actual cost is much higher.

What you should expect to hear; “No. If it looks like it is going to cost more than we quoted, you will receive a phone call notifying you of the added expense and an explanation as to why.” At this point you may choose to go forward with the extra repairs or simply pick up your computer as-is.

Do you guarantee your work?

Guarantee’s and warrantees are a given in today’s society, but are they worth anything? Ask the repairman the conditions of the guarantee, if they fix the problem and it returns, what will they offer? If their response is “uhm or I’m not sure,” then try another repairman. No one wants to pay for repairs and have the same issue again two weeks later. This does not apply to all issues, for example; viruses. You may have your computer completely cleaned of all viruses and three days later be infected again.

You should expect to hear; “Yes, for most repairs we guarantee our labor and/or parts for 30 to 90 days.” Most hardware comes with a one year warranty from the manufacturer in conjunction with the local shops warranty. When replacing or upgrading parts, make sure you get new, not used if you want a warranty.

Anytime you have hardware or software programs installed on your computer, make sure you get the box, CD and literature for the product when you pick up your computer. Usually software will have a CD Key that you may need to register the product later.

Will you save my files?

Your computer is an assembly of parts that in most cases can be easily replaced. The digital items such as photo’s of your dog, video’s of your child’s first steps, legal documents and spreadsheets with your usernames and passwords are what’s really important to most of us.

The answer you should expect is; “yes, if they are retrievable.”

This also happens to fall under one of those items that are listed as a flat rate in most cases. Expect to have to pay $x per gigabyte of data retrieved. Most places will charge a flat rate of about $85 for the first gigabyte and $20 for each additional gigabyte. If your primary goal is to retrieve data from a dead hard drive, expect to send the drive to a professional lab. Generally, local computer stores do not have the ability to do this level of work. Professionals can most often retrieve data even if the drive has been formatted two or three times.

Summary:

When shopping for a computer repair center, do not hesitate to ask questions. Ask about certifications, knowledge level of the technicians and years of service. This is your computer and your sensitive data. Most often, your best option is to take it to a shop as opposed to a local guru’s house. On the reverse of that, some techies that work from home after their day job, are real brainiac’s and some are want-to-be’s, so beware.

Also visit my new “About me” blog at https://www.aubreywlove.com

Windows vs Mac vs Linux

Move over Microsoft Windows and Mac OS X, Linux is gaining ground with speed and stability. In past articles, we have primarily dealt with the two mainstream operating systems (OS), but there is another that is dominating the world – Linux.

What is Linux

Linux is, in simplest terms, an operating system just as are Mac OS X and Microsoft Windows. It’s the software on a computer that enables the computer operator to interact between applications (software) and hardware. Many people are inclined to think that Windows is the standard while Mac OS X and Linux are rogue operating systems. Quite the contrary. Windows is a DOS (Disk Operating System) based OS while Mac and Linux are based on the very first OS – Unix.

Actually, there are number of OS’s that you may install on your home computer. A quick list of the other more popular ones are; Solaris Sun by Oracle, Free BSD, Chrome, Android, Os2 / Os2 Warp, React OS, AtheOS, SkyOS, and Free DOS. Only Mac and Windows use TV ads to promote their product, yet Linux is gaining a lot of market-share considering it has only word-of-mouth advertising.

As an operating system, Linux is developed collaboratively, meaning that its development and ongoing support is not the responsibility of one company, but rather all of them collectively. Companies participating in the Linux community share research and development costs with their partners and competitors. This would be the equivalent of Microsoft and Apple sharing technology, resources, and cost. We all know that doesn’t happen and probably never will.

Linux OS is comprised of two parts, the Kernel (code that makes up the core OS) and the GUI, (Graphical User Input.) There are only a handful of Kernels, but the GUI that makes the distribution (a combination of Kernel and GUI) are plentiful. The most popular are Mint, Ubuntu, Red Hat, Suse and Debian.

Where is Linux

Linux has grown remarkably since its first release in 1991, powering everything from the New York Stock Exchange to mobile phones to supercomputers and consumer devices such as smart refrigerators and washing machines. Linux began as a server OS and has become useful in desktop and laptop systems, gaining popularity with leaps and bounds.

Windows and OS X are predominantly found on personal computers, but Linux’s adaptability to work well on “wristwatches to supercomputers” gives the OS an edge over the other two. Quite simply put, most of the web pages that you visit each day are hosted by Linux servers, not Windows or Mac. Linux can also be installed at the factory when you purchase a new personal computer / laptop online from places such as Dell Computers.

Surprisingly, even Windows 10 contains binaries identical to the binaries running on an Ubuntu platform. (Binaries are the core function code found imbedded in the OS.)

Cost

Since Linux is an open operating system built by the masses, it costs nothing to the end user. That’s right, FREE. Unlike the bloated priced Microsoft Windows or Mac computers, Linux is free to download and install on as many computers as you like and there is no registration or activation required. Just to set things straight, I like Mac computers. After all they are Unix based like Linux, but the cost of purchasing a Mac is just too much for me. While the Linux distributions may be free, the biggest cost associated with Linux is the learning curve. The time a company devotes to training its employees on a new OS is often more than they are willing to pay at this time.

Final thoughts

The advantage of Linux over Windows is Linux is more stable and virtually virus free. It’s also much faster at starting up, running applications and shutting down. With Linux, there is no “blue screen of death” as associated with Windows. The list of major advantages could go on for pages, but you get the gist of it.

In my professional opinion, anyone wanting to migrate over to Linux should start with either Mint or Ubuntu. These seem to be the most Windows-like and user friendly of the more than 100 distributions I have worked with. If you would like more information, please email me at pailwriter@outlook.com.

Also visit my new “About me” blog at https://www.aubreywlove.com

Hide, split and restrict with new Mac options.

Mac may be introducing only a handful of new options in its latest releases, but the feature set makes up in quality what it lacks in quantity. This week’s tech tips will find us back on the Mac side of the computer world, while we let the Windows users mull over the Windows 10 upgrade discussed last week.

1. Automatically hide or show the menu bar

The menu bar has been a staple on the Mac desktop since its first release in 1984. In the years that have passed, it was an option that could be used, but not hidden. It sat there with an alluring yet ominous presence, hiding a portion of that wallpaper scene that we so adoringly love. With OS X, you can regain that small portion of real estate and see your wallpaper in all its glory. Open System Preferences, then go to General and click on “Automatically hide / show the menu bar.” You can still glide your mouse over the area once occupied by your menu bar and it will re-appear ready for use. Mouse away from it, and it disappears once again.

2. Use split screen

The use of two windows or apps side-by-side just got easier with the release of OS X El Capitan. Hold down a left-click on an open app’s green Maximize button and drag it to the left or right of the screen, then release. Next, click on a second open window or app to snap to the opposite side.

If you already have a window in full-screen view, you can still view it in split screen by going to Mission Control and dragging a new window onto the thumbnail of the full screen app. Next, click on the second app you would like to open.

Apps that need more screen real estate to enter split view may display a message that they are not available in full screen mode. This is not always true, they may just need a higher resolution on your monitor. Setting a higher resolution will give your apps more screen real estate.

If holding down the full-screen button doesn’t enter split view, go to Apple menu – system preferences, click Mission Control, and make sure “Displays have separate spaces” is checked.

3. Restrict what someone can do – and when!

 

The parental controls in OS X may appear simple at first glance, but there are plenty of additional options in there – some that go beyond basic underage access restrictions. A few of the more useful options include setting a “bedtime” after which users won’t be able to access the computer, limiting the functions or accessibility of apps of a user, or restricting computer use to a certain length of time each day,

Summary:

We have knocked out three more off the infamous list of 50 things to do with your Mac. Only 44 more to go. Keep checking back for more great Mac and Windows tips in future articles. If you have any you would like to share, email me at pailwriter@outlook.com and we will try to get them in an upcoming article.

Also visit my new “About me” blog at https://www.aubreywlove.com

Windows 10 Free upgrade ending soon

Windows 10 free upgrade ending July 29. Microsoft is engaged in a final push to get users to upgrade, pushing fresh new features and overhauls to its design. However, is Windows 10 right for you? Here are some arguments, both for and against the upgrade.

For the upgrade:

1. New Features

Not everyone agrees about the value of Windows 10’s new features, but most agree the new operating system (OS) offers more than previous versions of Windows. The introduction of Cortana, a new virtual assistant, who’s intentions are to provide you with traffic and weather reports for your day and answer simple questions. Cortana also helps with your scheduling and to-do lists.

Rendering 3D graphics in games and other applications is boosted with the new DirectX 12 including faster boot times than that of Windows 7 and 8.1 and more support for multi-monitor setups. Side note: DirectX 12 can also be installed on Windows 7 and 8.

Storage from and to multiple drives, both locally and online, can be pooled more easily.

2. Support and Upgrades

While Windows 7 and 8 still have some years left before Microsoft stops supporting them, Windows 10 is being promoted as the “last” OS your computer will need. However, they are reflecting in their lifecycle fact sheet that support will end Oct, 14. 2025.

Rumor has it that Microsoft will eventually move Windows and Office to become a service or subscription after the 2025 end date for Windows 10. There was some thought of this as early as Windows 7 when it was in production and known only by its codename Blackcomb.

3. The return of the desktop

Windows 10 brings back the familiar desktop and start menu – well kind of. The start menu looks similar to the Windows 7 version, but has the tiled start screen from Windows 8 tethered to the side.

Some nifty upgrades to the Windows desktop include better support for Virtual Desktops and an enhanced Task View. These allow the user to easily jump between open apps and virtual desktops.

4. Better data access

Windows 10 takes advantage of Internet connectivity in a way its predecessors don’t, plugging users into a wider range of information and automatically syncing information with cloud services.

Searching from the Windows 10 taskbar will search more than just files on the hard drive, it will also search Windows Store apps and Microsoft’s Bing search engine. Windows 10’s integration with cloud services such as OneDrive helps automatically sync files between PCs and Cortana can share your profile between devices.

Against the upgrade:

1. New Features

The new smart assistant Cortana is not actually that smart, according to most users I have talked with. Often responding to simple questions with a Bing search rather than a direct answer, I found it frustrating and had better results with a simple Google search done by myself. The new Edge browser should have been a good idea, but with most new web browsers, it needs a lot of work. It lacks key features that are common-place in other browsers such as Firefox.

2. Privacy

Windows 10 collects more data than I am comfortable with. I am okay sharing how I use Windows and what apps I use, but I am concerned about Windows collecting what I type, my contacts and location. When Cortana is enabled, this data extends to my web browsing history, voice commands and more. The data gathering settings can be turned down, but not off.

Updates on Windows 10 also happens more frequently than older versions of Windows. Users have less control over when updates are done and what changes these updates will make.

3. Old Hardware / Software

Windows 10, like other Windows releases, does not support certain older hardware or software. I am not referring to items from the 80’s, I’m talking about hardware and software that worked fine on Windows 7. I found that printers are the least supported item, but some video cards were not supported either. When I spoke to the Microsoft tech support, their response was to simply buy newer hardware.

Older software that I paid good money for was no longer supported, but I could (with some software) buy an upgrade from that company that did allow it to function on Windows 10. So now I’m left to wonder; how much is that FREE upgrade to Windows 10 really going to cost me?

4. Missing features

A key item missing from Windows 10 is the Windows Media Center. This software was designed for TV, music and movie playback. The Windows store offers a version for you to download, but at an extra cost. There are some open-source (free) media programs out there to fill in the gaps.

Solitaire is still there but it comes with full page ads that you have to work around. You can disable them, but only by purchasing the solitaire game from the Windows store.

Another issue I found was that on some laptops, Windows 10 did not allow moving icons on the desktop. Where they landed is where they stayed. Even when creating a new icon, it was populated on the desktop in a random spot and was not movable. So, I could not arrange my icons to my viewing pleasure.

Conclusion:

If you decide to make the upgrade, there is one option not found in previous versions of Windows, the option to go back to Windows 7 or 8. You have 30 days to revert back to your original OS if you decide Windows 10 is not a benefit to you. In my experience, this option works most of the time. Two of the computers I tried this on crashed beyond repair.

So, there is a short list of my pro’s and con’s regarding the upgrade. I will leave it up to you the user to determine if the upgrade would be a good thing. My personal opinion is, if you are a heavy graphics user, (games and video) you may want to try it out. If you are a basic user, (Internet, email, word, etc) you may want to stick with Windows 7 or 8.

Also visit my new “About me” blog at https://www.aubreywlove.com

Mac OS X Tips and Tricks

For all you Mac enthusiasts out there, this is your time to shine with tips galore. We all know your Mac can do millions of things, but sometimes even the best of us forget some of the really cool stuff it can do for us. Below is a few of the 50 popular tips in my arsenal.

Disclaimer – much to my disappointment, I must emphasize that some of these tips need recent versions of OS X such as OS X 10.10 Yosemite or OS X 10.11 El Capitan, but not all them do. Some are tips that Apple has slipped into upgrades that you may have totally missed, while others may be classic “aha” moments of “I totally forgot you could do that!”

1. Making your Mac Talk and Listen

A feature in OS X 10.8, is Mac’s ability to talk to and listen to you. (Unlike my kids who never seem to listen but certainly enjoy the art of speaking their minds.) While these are often pinned as accessibility features, they can be useful tools for everyone. We are all guilty of shooting off an email without proofreading or attaching a document we scanned over too quickly. As humans we have a tendency to ‘auto-fill’ words as we proofread our own work. Instead, select the text and go to Edit> Speech> Start Speaking. You may control the speed and select from a variety of preloaded voices in the Dictation and Speech System preference pane.

If you find that you use this feature often, enabling a keyboard shortcut is the best option. The default shortcut is Option + Esc, but you can change this in the Dictation and Speech pane.

Your Mac is also a good listener. In OS X 10.8 you can also dictate text anywhere you would normally type. Using the default options in Mac, simply press the Function key twice and then start talking. No need for those bloated overpriced Text to Speech programs; Mac has it built in.

2. Signing PDFs Without Printing and Scanning

We may be brainiacs of the 21st century,  but we are still signing hard copies of all manner of things. When you are emailed a PDF to sign and email back, you know the routine. Open, print, sign, scan, reply and attach. Mac users can avoid all this and actually sign the PDF right in the email.

Drag a PDF into the email you’re sending, hover over it, then at the top right you’ll see a little button appear. Click it and you get a range of Markup options, including an option for signing documents. You can also add your signature by holding a signed piece of paper up to your webcam. Mac does a great job of cutting it out of the background. You can also sign with your trackpad. If you have an iPad stylus, you can use that instead of your finger.

3. Import with Image Capture

Mac users sometimes overlook Preview’s power features and almost always ignore Image Capture completely. Before you spend your family’s fortune on bloatware apps that bog down your computer with worthless software, you may want to revisit Image Capture in your Utilities folder. This Mac default program allows you to control most modern scanners (including the ones built into multi-function printers) both wireless and wired. You can also import from digital cameras, including the iOS devices.

Open Image Capture and pop up the panel at the bottom left corner for extra options. Here is where you tell your Mac which app should launch when you connect your devices (including ‘none’.) For example; you could launch Aperture when you connect your digital camera, but launch nothing when you dock your iPhone.

We still have 47 more cool tips, but we can’t list them all here at once. Keep checking back for more great Mac and Windows tips in future articles.

Also visit my new “About me” blog at https://www.aubreywlove.com

Things that go Beep in the Night

We have all heard those little beeps our computers make: like when we start the computer, turn off the computer and of course the times that we did something wrong. For example, when the computer is running we sometimes mistakenly put our elbow on the space-bar while talking to someone. With the advent of technology filtering into our lives, more so today than even 10 years ago, we seem to have grown accustomed to hearing those once annoying little beeps to the point of ignoring them, and this is a bad thing.

Those beeps are a language that computers and other electronic devices use in order to communicate with us. They tell us when they are sick and when they are well. They tell us when we have done something wrong or requested an action that is not possible.

So where do those little beeps come from? They emit from a small piezoelectric (piezo) speaker mounted to the motherboard in your computer. When you power on your computer it runs a POST (Power On Self Test) that checks the internal hardware for compatibility and connection before starting the remainder of the boot process. Generally, if the computer hardware passes the POST test, you will hear one beep (some computers may have two quick beeps) as it continues the boot process. If the computer fails the POST test, then it will either not beep at all or generate a beep code that tells the user the source of the problem.

If you have a situation where the computer beeps more than once, it would be safe to say “Houston, we have a problem.” The next step is to listen to the beeps, even if you need to turn off your computer and restart it several times. Don’t worry about damaging your computer at this point, it’s already broken. In this situation, listen to the amount of beeps and the length of each beep. Think in terms of Morse code. Your computer may produce three quick beeps, which would be a different error than two short ones and long one. Take note of the amount of beeps and their length before you start looking up the codes to determine your computer’s ailment.

Below is a list of common beep error codes with their meanings and possible solutions. Because of the wide variety of different computer manufacturers and the optional BIOS’s (Basic Input / Output Signal) they may use, the beep codes will vary. It’s best to check with the manufacturer of your computer for specific beep codes.

1 beep: BIOS ROM corruption or failure; this is an indication that your BIOS chip (an integrated chip (IC chip)) on the motherboard is corrupt. You may need to replace it or simply flash it. (Flashing a BIOS is just a way of saying programming it’)

2 beeps: Memory (RAM) not detected; don’t confuse this one with the four beep error. Two beeps means the RAM or memory sticks are not detected. Most often you can simply unplug them, blow out the inside of your computer with some canned air and re-install the memory.

3 beeps: Motherboard failure; sorry, but this one is going to cost you. Most often this means that your motherboard is bad and needs to be replaced. Desktop computers aren’t too costly, but laptop computers can be really expensive to replace. Here is where you may want to look at cost vs. reward.

4 beeps: Memory (RAM) failure; similar to two beeps but an all together different problem. This means that one or more of your memory sticks are bad. (It happens.) The best option here is to pull the memory sticks one at a time to isolate the faulty one. Remember to turn off and unplug your computer each time you work on the inside.

5 beeps: CMOS Battery failure; the CMOS has a battery backup built onto the motherboard and often is the same type of battery used in older watches or garage door openers. The CMOS is where your computer’s internal clock function resides. This lets your operating system boot with the correct date and time as displayed in the bottom right corner of your desktop. Of course, the CMOS does more than just maintain a clock, but you get the idea.

6 beeps: Video card failure; this is not a major issue, but it will prevent any signal or image from going to your monitor. Usually the system will still boot, but you just can’t see anything happening. Replacing a video card in a desktop is quiet easy, but in a laptop it can be expensive and difficult.

7 beeps: Bad processor CPU; this issue is going to set you back about $100 for a new processor plus labor. It’s not the worst thing that could happen, but it’s something you don’t look forward to either. Again, replacing one in a desktop is much easier and cheaper than a laptop.

In the event that you encounter such beeps, a simple listen of the amount of beeps and their duration may give you a quick clue as to what is wrong. Granted, this is just a generalized reference and should not be taken as gospel for all computers. As mentioned earlier, check the website for your specific computer as the codes may vary.

Also visit my new “About me” blog at https://www.aubreywlove.com

Windows 7 Task-bar Tricks

In recent articles we have ventured off into other lands of the electronic world with my first computer, first robot and a few other off-the-wall ideas. This week finds us back at the heart of tech articles with some tips for making Windows 7 work harder and faster for you. Today we will focus on the often used but frequently neglected taskbar.

Shake, Rattle and Roll

Have you ever found yourself clicking around between several open programs on your desktop when you just want to concentrate on one of them? There is a little trick to easily minimize all the others without actually closing them. Mouse over the title bar of the program you want to leave open on your desktop. Click and hold the mouse button down then shake the mouse around and all other programs will minimize to the task bar. Then release the mouse button. To make them return to the desktop just shake the title bar of the open program again.

Say hello to Speedy Gonzales

A nice feature about the taskbar is getting a thumbnail preview of all open windows applications. When you mouse over each application a thumbnail viewer appears. Usually there is a slight delay but you can make them display more quickly with a quick edit in the Windows Registry.

1. Click on the Start menu button and in the search box type “regedit”. Without the quote marks.
2. When you see the warning dialog box appear, click the “yes” button.
3. In the left column of the next dialog box click on the arrow next to “HKEY_CURRENT_USER.”
4. From the sub-list that appeared, click on the arrow next to “control panel” and in that list click on the “MouseHoverTime.”
5. In the right column of the dialog box you’ll see it has a value of 400 – which means 400 milliseconds. Double click on the line and set a new, lower value such as 100, then click OK and exit the Registry Editor.

Now when you mouse-over the application icons in the task bar, the thumbnail previews will popup much faster.

Shuffle your Taskbar Icons

Priorities, we all have them, so why not put your taskbar icons in an order that you are comfortable with. Normally these are lined up based on the sequence in which you added them to the task bar. Putting them in an order you prefer is simple. Just click and hold the mouse button on the icon you would like to move and slide it to the position of your choice. This can be done with open applications in the taskbar as well as shortcut icons in the taskbar. So click and slide until your taskbar is to your liking.

Mouse! Who needs a mouse?

For those of us who use the keyboard more often than the mouse, here’s a tip for navigating the taskbar. Instead of mousing over an icon in the taskbar simply press the “Windows” key and the letter T on the keyboard. This option will focus first on the leftmost icon. Hold the Windows key down and continue to press the letter T to toggle through the open applications.

You can also launch one or more of those applications with the keyboard. Simply press and hold the Windows key while pressing the appropriate number on the number pad. For example; the far left icon will be “1”, the next icon to the right of it will be “2” on the keypad, and so on.

Start menu boring? Customize it.

If you do more with videos than pictures or music, you can add a link in your start menu to launch the folder from there.

1. Right-click the Start button and select Properties.
2. On the screen that appears, go to the Start Menu tab and click “Customize.”
3. In the dialog box that appears, scroll to the bottom, look for the Videos section, select “Display as a link,” and click OK and then OK again.

If you’d prefer that Videos display as a menu, with links to files and submenus, select “Display as a menu.” You can also do this with your pictures and music as well as other folders.

Wow! Who knew you could do so much with the start menu and task bar? Best of all, this is just the tip of the iceberg. Stay tuned for future issues and learn how to completely modify your Windows and your computer to make them work more efficiently for you.

 

Also visit my new “About me” blog at https://www.aubreywlove.com

SPAM (email, not the meat)

SPAM: What to do and not do.

“How do I stop all the email spam?” Actually I’m asked this question frequently and I have a few quick tips for reducing your email spam down to a low roar. While it is virtually impossible to completely rid yourself of spam without actually terminating all your known email addresses, you can filter it down to a manageable size.

First,let’s take a look at how and why you are getting bombarded with these unwanted pests. Logging onto a website where you are asked for your email address is one of the biggest instigators. As mentioned before in this column, we discussed reading the fine print before typing in your email address and clicking that infamous submit button.

A great number of those sites state in their terms and conditions that they have the right to sell your email address, or at least share it with their affiliate companies. While the first company may specifically say they will not sell it, they do say they may share it with an affiliate company who does reserve the right to sell your info.  See the tips below for ideas on how to avoid this.

Another trend growing in popularity is sending #whatever to a certain number using your cell phone. In return you are registered to win a tank of gas or a $50 department store card. Do not fall for this one either. Here is the scoop on how that works for their benefit and your misery. This company (whoever it may be) shells out 50 bucks for a gift card or tank of gas and in turn they receive hundreds of active cell phone numbers they can put on a list for sale. Trust me, they are going to make a lot more than $50 selling that list with your phone number on it. I have seen this same tactic used with email also.

So if you are not really interested in acquiring a Russian mail order bride, dating Asian women or getting free samples of Viagra, then follow these simple rules to a cleaner email inbox.

Tips for reducing or avoiding email spam overload:

1. Do not use your daily email for logging onto new websites. I maintain a separate email account that I’ve dubbed as my spam mail. Simply create a new email address from any free server such as Yahoo, Gmail, Outlook, AOL (yes it’s still around), GMX and so on. Only use your daily email for co-workers, friends and family. If there is a site you would like to see regular email notices from; you may return to that site and put in your personal email address. Just remember to read those terms and conditions before doing so.
2. Do not unsubscribe from a stray junk email that may wander into your inbox. Often when you do this, you are sending that server a message that your email address is good and prime for them to distribute or sell. Simply delete the email without opening it. You may also select it and choose the option “mark as spam” from your email menu and later empty your spam folder. Eventually your email server will notice a pattern and automatically forward any future emails from that source directly to your spam folder.
3. Use caution when choosing the “reply all” option in response to emails. This includes emails from people that you know and trust. This was mentioned briefly in last week’s article “email spoof.” Using the reply all option inadvertently puts you and everyone else on that email string at risk for spam. You may know and trust the friend who sent you that email, but they may have friends you don’t know, and those friends have friends and so on.

In conclusion, following these three basic rules of thumb regarding email will go a long way in reducing your daily spam intake. Granted these are not the only things you can do, but they are my top three picks for anyone wanting to reduce the spam in their inbox.

 

Also visit my new “About me” blog at https://www.aubreywlove.com

Terms and conditions may apply

Most of us never take the time to actually read the “Terms and Conditions” that go along with our purchase of devices and software. These conditions limit us in ways we never imagined possible. Some allow the company to shut off our computers or make us responsible for accidental damages, while others lock us into two- or three-year contracts. The later is one of my most despised provisions – you see it all the time – and I think it should die a quick death in some Louisiana Swamp. But that’s just me.

Companies often do such things and they do it with our consent whether we realize it or not.

Below are a few excerpts from actual terms and conditions followed by a short comment to put them in a layman’s perspective. They were picked at random from a list of popular companies that almost everyone is familiar with. Not picking on any company per se, almost all of them have these same or similar terms and conditions.

(AT&T Terms and Conditions Section 7)

“7. FORCE MAJEURE

AT&T shall have no liability for any loss or damage caused by any of the following force majeure conditions: fires, floods, explosions, strikes, embargoes, power blackouts, earthquakes,volcanic actions, wars, water, the elements, labor disputes, riots, thefts, acts of the public enemy, accidents, acts of God, acts of government, acts or omissions of Customer, acts or omissions of third parties, changes in work practices, inability to obtain necessary labor or materials, acts or omissions of any communications carriers or any other cause beyond the reasonable control of AT&T, whether or not similar to the foregoing.”

This basically implies they will not cover anything other than a defect in the device itself despite the fact they advertise certain models of their phones as being waterproof. AT&T, like Netflix and many other companies, has an arbitration clause that limits the consumer to arbitration only. So, no lawsuits. And what exactly is an “act of government?” You may need a lawyer to explain that one. You may also want to check your homeowner’s insurance. You may find you’re walking around with an uninsured $500 cell phone.

(Microsoft Windows 7 Terms and Conditions Section 8)

“8. SCOPE OF LICENSE.

The software is licensed, not sold. This agreement only gives you some rights

to use the features included in the software edition you licensed. Microsoft reserves all other rights unless applicable law gives you more rights despite this limitation, youmay use the software only as expressly permitted in this agreement. In doing so, you must comply with any technical limitations in the software that only allow you to use it in certain ways.”

 

Okay Microsoft, so you’re telling me that despite the fact that I spent $400 on this software, I don’t actually own it, I am just paying for the “license” or right to use it. I know from personal experience that if you upgrade four or more hardware items on your computer at one time, Microsoft considers that a “different” computer and a new license is required for it. An alternative for this is the Linux operating system. Linux is free to download and install on as many computers as you would like without registration or activation.You may also modify and freely distribute Linux with one stipulation: you cannot charge for it.

(Netflix Terms and Conditions Section 15)

“15.Arbitration Agreement

If you are a Netflix member in the United States (including its possessions and territories), you and Netflix agree that any dispute, claim or controversy arising out of or relating in any way to the Netflix service, these Terms of Use and this Arbitration Agreement, shall be determined by binding arbitration.The arbitration will be governed by the Commercial Arbitration Rules and the Supplementary Procedures for Consumer Related Disputes (collectively, “AAA Rules”) of the American Arbitration Association (“AAA”), as modified by this Agreement, and will be administered by the AAA.”

BINDING ARBITRATION SIMPLY MEANS THAT YOU AGREE TO GIVE UP YOUR RIGHT TO GO TO COURT OR SUE. On a side note, if you own a cell phone or have a credit card, then you have given up your right to trial and have agreed to arbitration only, regardless of the circumstances. Simply put; if your cell phone blows up and burns the side of your face, you have no rights to sue, but simply agree to the bindings of an arbitration.

 

So the next time you sign up for or purchase a product, you might want to do a little research and actually read through those “terms and conditions.” You may find you have few rights as a consumer, or you may find yourself locked into one of those aforementioned two-year contracts with no escape. When doing your research for phones, computers etc. read the fine print and look at free alternatives that have no binding and limiting contracts. They are out there, but it takes some searching to find them.

 

Also visit my new “About me” blog at https://www.aubreywlove.com