If you are used to using older versions of Excel, the conditional formatting options in Excel 2007, 2010, and 2013 will amaze you. So why would you want to bother using conditional formatting? Well, here are a couple of reasons why I love using this feature of Excel: To make your data more visually appealing. To make your spreadsheets easier to understand at a glance. To identify certain types of numbers for help in problem solving....
Wondering why your Mac is running slower than it used to? Maybe, you ran out of space on your device, and that’s affecting your Mac’s performance. Even if you haven’t seen the “Your disk is almost full” error message, it may be worth checking how much free space you have left on your hard drive. This article will show you how to find out how much storage space you have left and how to manage your Apple MacBook storage....
Our smartphones go everywhere with us, and lots of the places we go are wet! If you have water in your iPhone, you can do a few things to rectify the situation. Liquid exposure isn’t the immediate death sentence it used to be, but it can still wreck your phone. Here’s what to do when things get splashy. Water Resistant Doesn’t Mean Waterproof Before we get into how to deal with water in your iPhone, let’s clarify what your iPhone is designed for regarding water resistance....
Caller ID is a handy tool that lets you see the person or phone number for incoming calls. But what if you don’t want the person you’re calling to know it’s you ahead of time? Here’s how to hide caller ID on iPhone. Hide Caller ID in the iPhone Settings If you want to keep your name and number hidden for all outgoing calls you make, you can adjust a simple setting on your iPhone to disable caller ID....
When you want to make text stand out in your document, you can highlight it using a color. Unlike Microsoft Word, Apple Pages doesn’t have a simple button to color text. Here’s how to highlight in Pages on Mac, both specific text and paragraphs. How to Highlight Text in Pages You can highlight a specific portion of text in your Pages document on Mac. Select the text you want to highlight by doing one of the following, either on the page or inside of a text box: Drag your cursor through the text....
Good habits protect your online privacy and strengthen your security, while the bad ones put you at risk. Learn to control how you behave on the internet and turn it around by adding a few healthy practices to your online activity. How To Improve Your Online Privacy and Security Whether it’s the annoying ads from your internet searches that follow you around, or spam that’s pouring into your email inbox that made you think about your online privacy, it’s never too late to change things....
If you are experiencing performance issues with Tomcat, a common cause is the lack of JVM (Java Virtual Machine) memory allocation. The default setting of the maximum heap size is 64MB or 128MB. You can increase the maximum heap size of applications by setting the -Xmx JVM parameter. For example, -Xmx512m allows maximum 512MB heap to be allocated for the JVM. To adjust this parameter, right click the My Computer icon, then choose the Advanced tab....
It seems odd to invite the competition in, but Microsoft now lets you run Linux inside Windows. It’s easier to install than you think and more flexible and powerful than we imagined. Why Install Windows Subsystem for Linux? It seems contradictory to install one operating system (OS) inside another. What’s the point? And why Linux? We can think of six reasons to use Linux in Windows off the top of our heads....
Minecraft offers subscription-based personal servers called Realms. These are always online and designed for up to 10 players at a time. More than 10 can join, but only 10 can play at once . The always-online nature of a Realm means that anyone can play at any time, setting it apart from multiplayer games that require the host to be online. You can make a Realm of your own or join an existing one....
If your Windows files are corrupted or damaged, it may be difficult to open them in Microsoft Word or Excel. Many times, it’s not easy to narrow down the source of the problem. For instance, Word loads elements like the Normal.dot template, registry data key, and other templates or add-ins in the Office startup folder. You can start Word or Excel in safe mode without such elements so you can narrow down what’s causing the problem....
Have you got a private document or important work presentation you don’t want people to see? You can protect private and sensitive information in a Word or PDF document by password-protecting the file. This encrypts the file’s contents so it can’t be accessed by anyone, or read by any program without entering the password first. There are several options to password-protect the contents of a Word or PDF document, and limit access permissions on your Word and PDF documents....
There’s something exciting about being the first among your friends to play the latest Xbox games. Whether you’re into first-person shooters, RPGs, survival horror games, or something else entirely, there are a number of different ways you can get your hands on the newest Xbox games before anyone else does, and be the envy of all your friends. So, if you’re wondering how to play games early on Xbox, we’ll explain all....
Are you having trouble sharing an image because the file size is too large? The answer is to reduce the file size of your pictures. You can compress your images, change your image resolution, or remove the metadata from your images to reduce the file size. We will show you several ways to make your image file size smaller without sacrificing image quality. Compress the Image Size with Online Tools There are several online tools that you can use to reduce the file size of your images....
Whether you use a Windows PC or a Mac machine, your keyboard has all the standard functions keys at the top. These keys are assigned with various functions by the operating system of your computer. Some of the actions these keys perform are things like increasing and decreasing brightness levels, increasing and decreasing volume levels, opening certain functions, and so on. On a Mac machine, these keys trigger some of the macOS’ default actions, such as opening the Mission Control view....
Do you want to remove the Search button from the iPhone’s Home Screen? Here’s how to do that on any iPhone running iOS 16 and later. Spotlight Search on the iPhone is crucial for faster access to apps, documents, and other stuff. That’s why Apple did away with the older Home Screen page indicator in favor of a Search button with iOS 16. However, if you prefer other ways to trigger Search or need that familiar page indicator back, then feel free to remove the Search button from the iPhone’s Home Screen....
When you surf the web and run across an issue with loading websites, the advice you’ll hear most is to try to clear your browser cache and delete cookies. Most computer users are familiar with these terms. However, not everybody knows what exactly cached data and cookies are and why you should clear them from time to time. If you ever wondered what kind of data your browser collects when you search the web, there are a few places where you can look for it....
If you’ve recorded a video and you want to send that large video file to friends or family, you may find it’s a bit more difficult than you might have thought. Video files can get very large, very quickly. There are lots of options to send other types of large files, but video files are different. Those techniques may work for smaller video files, but for larger ones they won’t work....
Do you know who’s who in your company? Can’t figure out who’s at the bottom—or right at the top? When you’re using Microsoft Teams , it’s important to send the right message to the right user. If you’re unsure, you can use the organization chart in Microsoft Teams. This feature shows you the hierarchy of your company, based on the information used in Azure Active Directory for your company’s organisation....
The iPhone is not just an incredible smartphone, but also a potential life-saver. Suppose you ever find yourself in a situation that requires immediate help. In that case, your iOS device lets you take advantage of a feature called Emergency SOS to call in emergency services quickly. It’s always on by design, so you don’t have to enable anything to start using it. However, it is possible to reconfigure Emergency SOS and modify the default way it functions on your iPhone....
Are you looking for a way to access hidden files and folders in Linux? You might be surprised to learn that Linux has several hidden files that are not visible by default. These files usually start with a dot (such as .config ) and are often used to store configuration settings, user preferences, or system information. If you want to know how to show hidden files in Linux, follow the steps below....
