Posts

This allows you to change the formatting of any cells that obey a specific set of conditions that you create. You could, for instance, highlight all of the cells that are above a certain value or contain a specific word. Conditional formatting has many uses, such as highlighting errors or comparing data. Another useful application of conditional formatting is highlighting duplicates. This allows you to quickly spot any duplicate text or values within a large spreadsheet....

There are two ways you can do this. The first is automating a straight copy and paste of an existing range from Excel into a new table in a Word document. The second is performing calculations in Excel, creating a new table in Word, and writing the results to the table. You could try to record a macro to do this, but macros will only let you automate tasks inside of Word....

You can create playlists based on mood, activities, or anything you want really. While creating a playlist by yourself is great, you might want to make a collaborative playlist on Spotify with your friends. You can share a Spotify playlist and collaborate with others to create the perfect list of songs. Perhaps you and a friend want to add new music to the playlist to listen to together. If you haven’t created a collaborative playlist on Spotify before, we’ll show you how to do it on the desktop or mobile app below....

If you’re in an audio-only channel, for instance, you might be expected to keep chatting, or you’ll be taking up space for somebody else. You can deal with this problem yourself in your own Discord server using an AFK (or away from keyboard) channel. You can move a user from a voice channel into an AFK channel automatically if they become inactive. Here’s how to make an AFK channel in Discord....

Make Microsoft Edge Suggest Strong Passwords To get started, launch Microsoft Edge on your desktop, click the Settings and more (three dots) button, and click Settings. Then from the left-hand column, click on Profiles. Next, from the list on the right, click on the Passwords option from the menu. First, turn on the “Offer to save passwords” switch at the top. Then turn on the “Suggest strong passwords” button. Note that when it’s on, Edge will suggest strong passwords, and if you choose it, it will save the password....

Starting today, Microsoft is making Windows 10 version 1803, aka “April 2018 Update,” available for the public to download and install on their PCs. It will then begin rolling out in staggered stages globally starting May 8th, but if you’re an early adopter and don’t want to wait, you can get it now. Here is a look at where you can find it and manually install it. Manually Install Windows 10 1803 Of course, you want to make sure your computer is ready for the update....

While it isn’t as feature-packed as Microsoft Word, there’s still plenty you can do in a Google Docs document. One feature you might not know how to use, however, is text rotation. If you want to know how to rotate text in Google Docs, it’s still possible (if you know where to look). This guide will show you how. How to Rotate Text in Google Docs Using the Drawing Tool If you’re looking to rotate text in Google Docs (rather than basic, vertical text), then you’re going to need to use the drawing tool....

We’ll explain how you can view hidden files on your Mac, but first, let’s cover a few important details. Why Should Your Mac Hide Files From You? Some files on macOS need to stay safely where they are—unaltered. You could even go so far as to brick your Mac if you accidentally delete or change one of these files. These include directories, libraries, and files that keep macOS running smoothly....

The term performance monitor (also commonly known as “perfmon”) sounds like an advanced IT tool, but it’s very accessible even for a regular computer user. In this article, you’ll learn more about the “performance counters” that give you insights into every aspect of your computer. You’ll also learn how to graph the relevant counters so you can identify where any problems might be. What’s a Performance Counter? You can think of a performance counter like a sensor inside your computer that constantly measures the health of different systems and processes....

Make the Google App Read Articles Aloud on iPhone or iPad To get started, open the Google app on your iPhone or iPad. Then scroll down the feed under the Search bar to find an article. Or search for an article you want to be read to you. If the site supports the Read Aloud feature, you’ll see an icon of a person speaking at the top-right corner. Tap on it....

Note: This will work with Windows 8, Windows 7, Vista, and XP We previously showed you how to run Disk Cleanup and how to clean temp files it misses. But remembering to run it regularly is the challenging part. Set Windows to Run Disk Cleanup Automatically First, some command line magic — click Start and type: cmd in the search box. Hit Enter. At the command prompt, type: cleanmgr.exe /sageset:1 then hit Enter....

Microsoft aggressively focused on delivering a similar experience for the Windows PC. Eventually, Microsoft’s fight against new rivals Google on the web and Apple in mobile took center stage. It was no longer about PC software but about tapping into the new trends in computing: mobility, internet search, and touch. Eventually, software like Windows Essentials suffered. The last version was released in 2012 and included support for Windows 8; there is no Windows 10 release for Windows Live Essentials, but the last version is still available for download....

As is generally the case with cumulative updates, there are no new features here. But there are a few security fixes and overall system improvements. In fact, this round of updates is relatively small. KB4530684 for Windows 10 1903 and 1909 Today’s update will bump your Windows 10 1903 build to 18362.535and version 1909 to 18363.535 and it includes the following fixes and improvements: Updates to improve security when Windows performs basic operations....

Windows 10 Redstone 5 Build 17763 Here is the list of fixes, changes, and improvements for this latest build: The build watermark at the lower right-hand corner of the desktop is no longer present in this build. This doesn’t mean we’re done…We fixed an issue where touching a Flash element in Microsoft Edge with two or more fingers could result in the tab crashing.We fixed an issue where thumbnails and icons might not be rendered if there were any video files saved to the desktop....

Windows 11 Preview Build 22000.194 When it comes to app updates, Microsoft is starting to rollout updates for several of the built-in apps on Windows 11. According to the Microsoft post: We are beginning to rollout updates for several apps that come included as part of Windows 11 to Windows Insiders in the Beta Channel. Today’s rollout includes the following app updates: Snipping Tool, Calculator, and Clock with Focus Sessions! Check for updates in the Store and try these apps out and let us know what you think!...

Unfortunately, however, that command is not enabled by default on any folder except the Deleted Items folder. So, as you can imagine, this tip can be a lifesaver. But, before I start, let’s first go over the basics around deleting email in Outlook. Yeah yeah, I know… what could be simpler than deleting an email? True, it’s a complex task but, a lot of people honestly don’t fully understand it so let’s spend a paragraph to review it quickly....

Photo Courtesy: Margaret Wozniak Here’s a story he told me about Steve Jobs back in the day. The two had just sold their worldly possessions -– Wozniak his expensive Hewlett-Packard calculator and Jobs his Volkwagon van — to get the $1,000 they needed for 50 Apple I circuit boards to show and sell to tech enthusiasts at the Homebrew Computer Club. Photo Courtesy: Alan Luckow The following is an excerpt from interviews I recorded for iWOZ: How I Invented the Computer and Had Fun Doing It (Steve Wozniak with Gina Smith, W....

Since the online simulator doesn’t have an array of “always-on” microphones listening, you can’t just say: “Alexa” to trigger it as you do with an actual device. Instead, click and hold (or tap and hold on a touch screen device) the microphone button and speak your command (obviously, your computer or mobile device need a working microphone and speakers for it to work). Then Alexa will reply to you as it does from any of the three echo devices that include it....

The errors were happening a lot when I tried to save screenshots from Snip. It wasn’t until I tried saving to a different partition I came across something weird; I didn’t have a single byte of disk space left on my system drive. I thought, how could this be? I don’t work with large applications or files, if I do watch a video, it’s immediately archived to my external drive; old files no longer used are archived to the drive too....

First, make sure you have second screen notifications enabled on your Fire TV. To do that, head to Settings > Display & Sounds > Second Screen Notifications and make sure it’s switched to On. The movie or TV show will start playing on your Fire TV, and then your tablet turns into the second screen experience. You will get a full screen of IMDB data where you can look at the cast and characters currently in a scene, find out other shows an actor has been in, learn interesting trivia, and more....