You can freeze, hide, and group the columns and rows in Excel to give you a better view of your data. Here, we’ll show you how to do all three. Freeze and Unfreeze Columns and Rows in Excel If you have a lengthy spreadsheet or one that covers many columns, freezing can help. You can freeze the top row or the first column to keep it in view when you scroll....
First of all, add the extension, which you can find here, to Google Chrome — you’ll need to give it some permissions to use it. Once added, you’ll notice that opening a new tab has become something completely different. Every time you do so, you’ll see a Google Now-like page, which includes all sorts of useful information with the familiar cards. You’ll have a Google Now-style wallpaper on top of the tab and there’s a list of your most accessed websites underneath that....
Don’t do it. There are actually communication techniques you can use whenever you have a dialogue on Facebook that can reduce the chances of having a negative experience. Perfect these tips, and transform your time on Facebook into one that’s uplifting and fun, rather than stressful and annoying. Give Good Advice People often turn to Facebook to ask random strangers for advice. It could be anything from eating tips, health advice, technology shopping pointers, or anything else....
By grouping spreadsheets in a workbook, you can change one sheet and have it automatically applied to the others. This is handy when you need to add a formula or format a range of cells on more than one Excel spreadsheet. About Grouping Sheets in Excel The most important thing to know about grouping sheets to make a change is that the sheets should be set up the same way....
Searching Windows 11 the Easy Way The process is simple if you need to search for a file, folder, app, or other items on your Windows machine. All you need to do is hit the Windows key on your keyboard and start typing for what you need. For example, I hit the Windows key in the shot below and started typing: cmd to find and open the Command Prompt. The Start menu has a search field at the top, but it automatically puts the cursor there when you start typing your query....
Export Outlook.com Contacts First, you’ll need to export your contacts from your Outlook.com. Log in to your account and click the arrow next to the Outlook logo on the top left side of the screen. Then select People. Then click Manage > Export. Then download the CSV file that contains all of your contacts and save it to a convenient location on your computer. Import Contacts to Gmail Now log in to your Gmail account and click the arrow next to Gmail then Contacts....
So first, let’s review the command for Lorem Ipsum and then consider the command for inserting Random Text into a word document. Editors note: As of 2017, only the Windows version of Microsoft Word supports inserting Lorem Ipsum. Microsoft Word for Mac only supports inserting Random text. Insert Lorem Ipsum into a Microsoft Word document Type =lorem() into a new or existing Word document and hit the enter key....
If you want to find the lowest and highest numbers possible to answer a mathematical problem, you’ll need to install and use the Solver add-in. Here’s how to install and use Solver in Microsoft Excel. What is Solver for Excel? Solver is a third-party add-in, but Microsoft includes it with Excel (although it’s disabled by default). It offers what-if analysis to help you determine the variables you need to answer a mathematical problem....
Update: Windows 8.1 has reached the end of mainstream support. According to the company: Note: You’ll need to be running Windows 8 Pro to install the Media Center Pack. Earlier this year, we covered how to install Windows Media Center on the Release Preview, and while the steps are essentially the same, there are some differences to note. Get Windows Media Center Pack Product Key To get Windows Media Center (WMC) for free, head to Microsoft’s special offer site and enter your email address....
If you’re on a limited data plan, however, this can cost you money. If you reach (or breach) your data cap, you could end up paying out in extra charges or see your internet speeds throttled as a consequence. To avoid this, you can limit your data usage on Windows 11—here’s how. Set Your Windows 11 PC to a Metered Connection One of the simplest methods to cut down on Windows 11’s data use is to set your network as a metered connection....
You get a lot more options when using an Android phone compared to the iPhone. Android is more open than iOS and allows for a lot more cooperation between operating systems. It allows you to answer calls, share photos, send and receive texts, and a lot more. Currently, with iPhone, you can only send webpages from your phone to your PC and vice versa. For this article, the screenshots I’m using are for linking an Android phone....
On the other hand, you can make a playlist private on Spotify. To make a playlist private on Spotify, you need to do more than remove it from your profile. If you want to make a playlist private on Spotify and hide your music tastes from your friends, here’s what you’ll need to do. How to Make a Playlist Private on Spotify If you listen to Spotify on your PC or Mac, you can quickly make a playlist private by using the Spotify desktop app....
This allows Alexa to get a better sense of your voice cadence and pronunciation. And, you can go through this process as many times as you like. Set your Location. For the most personalized information that pertains to your local area, it’s best to make sure Alexa knows where you are located. This is an obvious one, but the Echo doesn’t come with your location set by default. To set your location, open the Echo app and go to Settings > Your Echo’s Name > Echo Device Location....
Instead of broadcasting to the world, you might want to make your Twitter account private. That allows your tweets only to be seen by your followers and can’t be retweeted. In addition, your older tweets will be protected too. If you want to protect your tweets, you can make your Twitter account private to have a modicum of privacy on the social media network. This guide will show you how....
Also, since the new Edge isn’t part of Windows 10 anymore, Microsoft can automatically update the new browser more frequently. The company should be adding new and improvements approximately every six weeks. But there may be times when you want to manually check for updates to make sure you have the latest version up and running. Manually Update Microsoft Edge on Desktop To manually grab updates for the new Microsoft Edge, head click the Options (three dots) button in the upper-right corner....
If you’ve never merged cells in an Excel spreadsheet, groovyPost is here to help! We’ll walk you through how to merge cells into a single cell and then unmerge them if you change your mind. How to Merge Cells in Excel Open your Excel workbook to the spreadsheet you want to work with and follow the steps below to merge cells. Keep in mind that the upper-left or far-left cell data will remain, but any data in the other cells you’re merging will be deleted....
Method 1: Export vCard from iCloud (Any Platform Web Browser) Method 2: Export Contacts from iTunes (Windows) If you have iTunes installed on a Windows computer, you can skip the iCloud step by pulling your contacts directly off your phone. (Note: If you are already syncing your iPhone contacts with iCloud, you will need to toggle this off in Settings > iCloud.) Method 3: Export iOS Contacts from Desktop macOS Contacts (macOS) If you are running macOS, your contacts are already synced to your desktop, and you don’t have to go to iCloud....
Did you know that it’s possible to mirror your iPhone to your TV even if you don’t have a Wi-Fi connection? If you have the right devices or the right adapter, you can mirror your screen without the need for Wi-Fi at all. Here’s how to mirror iPhone to TV without Wi-Fi. Can I Mirror iPhone to TV without Wi-Fi Using Any Apple TV? If you have an Apple TV, you may be able to mirror your iPhone to your TV without either device being connected to Wi-Fi....
Here’s how to get yours working, too. Installing Apple Mighty Mouse or Magic Mouse Drivers in Windows 10 If your computer has Bluetooth, that’s half the equation. Drivers are the second half. I am using the discontinued Apple Mighty Mouse, model A1197. Apple makes official Windows drivers for their peripherals, including the Mighty Mouse and Magic Mouse. They are bundled up with Boot Camp, which lets you boot Windows on your Mac....
If you’ve ever recorded macros in Word, then you’ll be familiar with the process. You could write your own macros using VBA (Visual Basic for Applications), but it’s much easier to record them visually using the Macro Recorder tool. Here’s how. How to Record an Excel Macro For most Excel users, the easiest method for recording a macro in Microsoft Excel is to use the Macro Recorder. While the Macro Recorder is recording, you complete an action....
