Hide Blanks in a Pivot Table When you create a Pivot Table and the source data contains empty cells, the empty cells are reported as “Blank” in the pivot table. Depending on the organization of your Pivot Table, the Blanks can appear in Rows, Columns or in both Columns and Rows. In most cases, “blank” in a Pivot Table serve no purpose at all and you can easily Hide Blanks in Pivot Table by following the steps below....
Hide Caller ID On iPhone When Caller ID feature is enabled on iPhone, you will be able see Names and Phone Numbers of people making Calls on your iPhone. Since, this feature works on a reciprocal basis, other people will also be able see your Name and Phone Number, whenever you call them from your iPhone. If required, you can easily Hide Caller on iPhone, which Hides your Name and Phone Number from others....
Internet Explorer Missing in Windows 10 Users have reported the issue of Internet Explorer not being installed or missing on new computers that come pre-installed with Windows 10 operating system. Another case where Internet Explorer goes missing on a Windows computer is whenever a fresh installation of Windows 10 operating system is installed on the computer. Apart from this, you may also find Internet Explorer missing on computers that were upgraded to Windows 10 from an earlier versions of Windows operating system (Windows 7 or 8)....
Turn OFF iPhone X So far iPhone users have been using the Power button or the ON/OFF button to power OFF their iPhone. However, the Power Button on iPhone X has been renamed as the Side Button, as it performs more functions than the traditional ON/OFF Button as available in other models of iPhone. You can no longer Power OFF iPhone X holding the Side Button, because holding the side button activates Siri on iPhone X and Siri won’t be able to reboot your iPhone....
Print From Android Phone Using Google Cloud Print Google’s Cloud Printing Technology allows almost any connected device including Android Phones and Tablets to print to almost any printer that is registered with Google. Hence, the first requirement to be able to print from an Android Phone or Tablet using Google’s Cloud Printing technology is to go ahead and register your printer with Google. Although, the process to register a printer with Google is a bit complicated, you will be fine as long as you follow the steps below and allow Google to automatically list printers connected to your network....
Remove Camera From iPhone Lock Screen All that is required to access the Camera on your iPhone is to swipe on its Lock Screen and you will find the iPhone Camera ready to shoot Photos and Videos. As you will agree, this convenient setup is a lot better than having to unlock iPhone and lauch the Camera App. However, there are times when you may want to disable such easy access to the Camera on your iPhone....
Reset NVRAM or PRAM on Mac NVRAM (Non-Volatile Random-Access Memory) is a storage location designed to store user preferences and settings on the computer like Time Zone, Screen Resolution, Volume Level and other information. PRAM (Parameter Random-Access Memory) pretty much performs the same functions as NVRAM. PRAM was used in the older versions of Mac, NVRAM is being used in newer versions of Mac. Both NVRAM and PRAM can retain Data, even after the powered is switched OFF on the computer....
Run Startup Repair in Windows 10 The Startup Repair Tool in Windows 10 can be run from within the Desktop, from the Lock Screen and also from outside Windows 10. If the installation of Windows 10 becomes corrupted, you should still be able to Run Startup Repair by using Recovery Drive or by forcing your computer into Recovery Mode. You will find below multiple ways to access the Startup Repair option in Windows 10....
Setup & Use VPN on iPhone The most common reason for using VPN is security, especially while using public Wi-Fi Networks at a Coffee shop, Airport, Library and other public places. You can get more information about VPN and how it can protect your privacy by referring to this guide: What is VPN and How Does it Work. If your preferred VPN Service is available in the form of an App, the procedure to Setup VPN on iPhone can be as simple as installing the VPN App on your device and logging into VPN Service....
Stop Mac From Going into Sleep Mode By default, all Mac computers automatically go into sleep mode after a certain period of inactivity. This feature on Mac is designed to save power and also to prevent unauthorized access, while you are away from your Mac. Usually the period of inactivity after which the Mac automatically goes into sleep mode is 2 minutes while on battery and 10 minutes when the Mac is plugged into a direct power supply source....
COUNTIF Function in Excel The COUNTIF Function in Excel can be used to count cells containing Numbers, Dates and text matching a specific criteria. For example, if there is a list of people with Names and Ages, the COUNTIF function can be used to count number of people above the age of 18 or people having the same family name. The COUNTIF Function supports logical operators (=, <, >) and wildcards (*,?...
Use WhatsApp on iPad Without SIM Currently, the only way to Get WhatsApp on iPad without jailbreaking your device is by making use of the Web Version of WhatsApp known as WhatsApp Web. Unfortunately, in order to use WhatsApp Web on iPad, you will still need an active WhatsApp Account installed on your iPhone. If you do not have WhatsApp on iPhone, you can refer to this guide: How to Setup and Use WhatsApp on iPhone....
iPhone Keeps Restarting Randomly While the problem of iPhone Restarting randomly has mostly been reported by owners of older devices, this issue can also occur on newer devices. The reason for iPhone Restarting can range from minor software glitches, malfunctioning apps and corrupted software to hardware related problems. Before going ahead with the steps to fix this issue, it is recommended that you download a complete Backup of your device to Mac or Windows PC....
You can use the smartphone projector to show videos and pictures of your holidays to your friends, instead of having people cramped at a tiny screen, you can beam pictures and videos on a wall so that everyone can see them at the same time. The picture quality is fairly good if you have a really bright phone. You don’t need a stand because the projector has one built in for your phone....
Microsoft Office “You Are Not Authorized to Access This Page” Error If you are using a work or school Account, it is likely that you do not have the required permission to access certain Microsoft Services or Files. In such cases, you will have to ask the Admin responsible for managing the network in your company or school to provide you with the required permissions on the network. If the problem is occurring on your personal Home or Office computer, you should be able to fix the problem using any of the following methods....
Disable “Sign in with Apple” Option for Apps & Websites In general, most websites and Apps provide multiple SSO (Single Sign-on) options and allow users to Sign-up for their services using Facebook, Twitter, Google, Phone Number and Email Address. In addition to above, you may see “Sign-in with Apple” button on participating Apps and websites, which allows you to Sign-in using your Apple ID. A clear advantage of using “Sign in with Apple” option is that it there is no need to use your Social Media Account, fill out forms, Create and manage new passwords....
In order to answer this question, we need to understand as to what is actually covered by Apple’s standard one year Warranty, and explore whether purchasing an additional Warranty from SquareTrade is worth the effort and the money spent. Apple’s 12 Month Warranty – What Does it Cover Here is a paragraph from Apple’s Warranty terms and conditions that more or less describes as to what is actually covered by Apple’s Limited One Year Warranty for iPhone and iPad....
Stop iPhone from Automatically Connecting to WiFi Networks When you connect iPhone to any WiFi Network, it automatically stores Network Name, WiFi Network Password and other details in its memory. The next time you happen to be within range of this Network, your iPhone will immediately recognize this Network and will be able to automatically to this known WiFi Network, using login information stored in its memory. While this default setting on iPhone helps in connecting to known WiFi Networks (Home, Office, Library), without the need to remember and enter Network Password, it can sometimes lead to security and network related issues....
Universal Clipboard Not Working On Mac When you copy anything on a computer, the copied data is stored in a temporary storage location on the computer known as the “Clipboard” and this allows you to paste the data anywhere elsewhere on the device. The “Universal Clipboard” feature in Apple Devices extends this concept further, allowing you to copy and paste content between multiple devices – Mac to iPhone, iPhone to iPad and vice versa....
Change Default Search Engine in Microsoft Edge to Google Although, Microsoft’s Edge browser uses Bing as its default Search Engine, it can also be setup to use Google and other Search Engines that support OpenSearch Technology. You can find below the steps to change the default Search Engine in Microsoft Edge to Google. 1. Change Search Engine in Microsoft Edge to Google Open Microsoft Edge browser on your computer > type www....
