However, as your workbook grows in size, Excel needs more time and memory to work through the calculations. Rather than see Excel slow down and become unusable, you can replace any formulas you’re using with their results. This will speed up Excel for other tasks and improve overall system performance and memory usage. You can replace the formula entirely or replace part of it, allowing you to mix data that changes with static data....

Update: Microsoft has ended support for Windows 7. For the latest, greatest, and secure OS, make sure you have an updated version of Windows 10 running on your PC. Note: This article was written several years ago for Windows 7. If you are on Windows 10. Check out our article on how to set default apps on Windows 10. Set Google Chrome as Your Default PDF Reader Step 1 Click the Start Menu and then click Default Programs....

Boost the speed and reliability of your web browsersTrack web activity on your home networkBlock and filter web content (including specific websites and domains) The free version of OpenDNS lets you do all of this without software or “hacks” that might enrage your ISP. OpenDNS is 100% legit and widely utilized in the business and education world. So, why not use it in your home? We could get into how OpenDNS works, but I’m betting you don’t care about reading the above benefits....

Share Phone Contacts Via The iMessage Or WhatsApp Interface Both iMessage and WhatsApp have very similar methods for sharing contacts. But I will start with iMessage. Share Phone Contacts In Your iOS Address Book Via iMessage So I hear there’s this guy called Mark O’Neill, who is really interesting to talk to. So I’m going to send over the contact details so I can talk to myself. Talking to myself is good....

Login to your Facebook and start a Chat session with a friend. In the chat title bar, click on the wheel icon. Expand the options menu and click on Add Friends to Chat. Enter the name of the friend(s) you want to invite to the chat room and click the Done button once everyone is added. The new chat room will open with everyone you selected. Party time!!!! Comment Name * Email *...

When you boot into Safe Mode, it only loads what is necessary for Windows. No effects, no complex graphics driver, sound card, etc. This allows you to narrow down more easily what the issue you’re having might be. If you need to get to Safe Mode, here are a few ways to do it – from easy to more difficult. Note: You can also boot Windows 10 in Safe Mode....

Hide Personal. xlsb when Excel Launches By default, Personal.xlsb will be hidden when Excel launches. Chances are, it’s been there a lot longer than you realize. But for one reason or another, it can become unhidden. The quickest way to get rid of it is to go to the View tab and click Hide. Now, Personal.xlsb will continue to open, but it’ll be hidden from view. In this way, you’ll still have access to the macros you’ve recorded, but you won’t see that pesky Personal....

However, one setting everyone can agree isn’t ideal is the default behavior of the widgets board. You don’t have to click the Widgets icon for it to launch. Instead, it’s set to open when the cursor hovers over the icon. That makes it annoying as it disrupts your workflow. The good news is you can change it. Here’s how to stop the popup Widgets board from launching on Windows 11 via hover....

You can use iCloud for Windows to access Apple apps like Messages and Notes, or you can use the Your Phone app on Windows 10 to type messages, but if you want to enter text into a non-Apple app, you need another option. Enter AirType, which is a free app that allows you to enter text using your Windows PC (or even a Mac) keyboard through a browser. It’s easy to use, and you don’t need to install anything on your PC to use it....

Looking for an easy way to upload files to multiple file hosting sites at once? Here I take a look at an online service that will mirror your files to up to 12 hosting sites. First, go to the Uploading.to website. Select the file hosting services you want to upload your files to. Then click Choose File. The groovy thing about this service is it lets you upload up to 10 files at once....

Maybe you caught some terrific pictures from an event over the weekend, a new addition to your family, or a spectacular view out your window. Here’s how to use the templates on TikTok to share those photos with a bit of flare. Access the Templates on TikTok Getting to the templates on TikTok is a piece of cake. Open the app and tap the plus sign like you normally would capture a video....

Note: If you need to setup Google Cloud Print and add printers to it, check out my previous article. I will assume that you already have a printer in your Google Cloud Print account. New Google Cloud Print Android App Install the Google Cloud Print app on your Android device. Then to print a document, tap the small printer icon at the top right side of the window. You’ll be able to choose a file you want to print from Drive, your files, Dropbox, SkyDrive…even your Gallery so you can share photos to other apps....

According to Microsoft: Simply put, you can connect your Windows 8 system to an ad hoc WiFi network, but the ability to create one is no longer available. Make Windows 8 Laptop WiFi Hotspot First download Virtual Router Plus which is a free and Open Source utility. No installation is necessary, and you can run it from a USB flash drive. Type in a name for the hotspot, password, and select the connection you want to share....

The HTC One X+ packs some serious firepower, as it uses a 1.7 GHz quad-core Nvidia Tegra 3 CPU, plus a fifth core, that saves battery by running tasks that don’t require as much processing power. The extra core has low power consumption that leaves the 2100 mAh battery available for other tasks. It has a 4.7 inch touchscreen (720p resolution), 8 megapixel rear facing camera that captures 1080p HD content and it runs Android 4....

Log into iCloud.com with your Apple ID and click iWork. Click the gear icon on the upper left side and select Upload Document. Browse to the location of the Pages document and upload it. Once it’s uploaded, click the document » Download » Word. Give iCloud some time to prepare the document to download in Word format. The amount of time it takes will vary depending on the size of the document....

For the first stage of the program, all existing Google Voice users will have three invites each via a link under the Google Voice Inbox. Google said this would slowly increase. Apparently, it’s going to work the same way as Gmail accounts a few years back. Similar to the best email addresses on Gmail, the best phone #s I’m sure will go fast so now is the time to start sending out emails to friends/family to secure your invite to the service....

9/22/2012 Editor Update — I just published a list of Keyboard Shortcuts for Windows 8 and Windows 10 Keyboard Shortcuts. Take a look at the latest shortcut goodness! My personal favorite BTW – is the pressing F6 while using Internet Explorer. F6 automatically selects your Address Bar for you. It saves me a lot of time! Windows 7 and Windows Vista Keyboard Shortcuts Windows logo key :: Open or close the Start menuWindows logo key + Left Arrow Key :: Snap current window to left side of screen for side-by-side viewingWindows logo key + Right Arrow Key :: Snap current window to left side of screen for side-by-side viewingWindows logo key + Left Arrow 2x :: Snap current window left across multiple monitors for side-by-side viewingWindows logo key + PAUSE :: Display the System Properties dialog boxWindows logo key + D :: Display the desktopWindows logo key + M :: Minimize all windowsWindows logo key + SHIFT+M :: Restore minimized windows to the desktopWindows logo key + E :: Open ComputerWindows logo key + F :: Search for a file or folderCTRL+Windows logo key + F :: Search for computers (if you are on a network)Windows logo key + L :: Lock your computer or switch usersWindows logo key + R :: Open the Run dialog boxWindows logo key + T :: Cycle through programs on the taskbarWindows logo key + TAB :: Cycle through programs on the taskbar by using Windows Flip 3-DCTRL+Windows logo key + TAB :: Use the arrow keys to cycle through programs on the taskbar by using Windows Flip 3-DWindows logo key + SPACEBAR :: Bring all gadgets to the front and select Windows SidebarWindows logo key + G :: Cycle through Sidebar gadgetsWindows logo key + U :: Open Ease of Access CenterWindows logo key + X :: Open Windows Mobility CenterWindows logo key with any number key :: Open the Quick Launch shortcut that is in the position that corresponds to the number....

Contre Jour (French for Against Daylight) was first introduced in October as part of Microsoft’s touting the new HTML5 capabilities in IE 10. The game is available on Windows Phone, Xbox 360, and now online with 20 new free levels to play. It’s a physics-type game where you need to get Petit’s character to different portals in the mysterious world. It’s best played on a touch tablet like the Microsoft Surface — it’s available on Android and iOS as well — but you can still have a lot of fun playing the free levels with your mouse at work too....

Here are a few ways to make your mobile photography even better by using Photoshop and Lightroom: Create an HDR Panorama Panoramas taken with phones are great. HDR photos are great, too. So let me ask you – Why not both? Here are the simple steps for making a HDR Panorama: Take a series of overlapping HDR Photos Load up your camera, set it to HDR mode and take as many overlapping photos as you like....

How To Disable The Firefox Add-On Version Checker Step 1 – Start Firefox First of all, you will need to call your trusty companion – Firefox. For XP, simply go to Start > All Programs > Mozilla Firefox 3.6 Beta 4 > Mozilla Firefox. Of course, if you are running Vista or Windows 7 you can always start it up more quickly by opening the start menu and typing in Mozilla then Pressing Return....