Does using a drop-down list in Microsoft Excel make data entry easier for you or your co-workers? If you said yes and want to go a step further, you can create a dependent drop-down list just as easily. With a dependent drop-down list, you select the item that you want in the first list, and that determines the items that display as choices in the second one. For example, you might select a product, like a shirt, and then pick a size, a food item, like ice cream, and then pick a flavor, or an album, and then pick a song....

There are a few ways to create an Instagram page. One way is to create a new account on Instagram, and the other way is to convert an existing Facebook account into an Instagram account. To create a new account, open the Instagram app and tap “Create Account.” Then, enter your name, email address, phone number, and password. To convert an existing Facebook account into an Instagram account, open the Instagram app and tap “Log In With Facebook....

PDFs are great for sharing your work. There are free PDF readers available for Windows, macOS, Linux, iOS, and Android, and PDF file retain their formatting no matter where they’re displayed. Best of all, you can quickly create PDFs from other documents in Windows using tools you already have. Creating a PDF in Windows is extremely easy, whether you’re building one out of word documents, web pages, images, or whatever else you have....

Creating a playlist for music in iTunes and on your iPhone is easy; simply grab the songs you want, chuck them into a new playlist, and you’re done. With so much ease of use available to album listeners, you would think the same would be true for the iOS Podcasts app – but not so. Getting a few of your favorite podcasts all lined up in a row for a long flight or a run in the hills isn’t nearly as convenient as it is for regular tunes, so here’s our guide that will make sure you aren’t left scrambling to hit play the next time your last Radiolab episode is over....

When you’re using any of Apple’s computers, smartphones, or tablets, an Apple ID is integral to not only setting devices up in the first place but getting the best out of them as you use them, too. When you pay a premium to use an ecosystem that “just works,” not having an Apple ID cripples the experience. Note: For this guide, we are going to make the assumption that you already have an iPhone or iPad up and running, and that you need to create an additional Apple ID....

If you’ve ever received an email that prompted a meeting or conference call, you’ll appreciate this built-in Gmail feature. You can select an email you receive and create an event in Google Calendar right from the message. Maybe you received an email from a customer that you and your coworkers should discuss. Perhaps you received a list of project tasks that you and your team need to review. Or maybe you received an email from your boss that warrants a one-on-one....

Cortana now lets you create and manage lists with your voice, and even lets you connect to Wunderlist if you want. Here’s how to do it. Cortana in Windows 10 is billed as a personal assistant—much like Siri on Apple devices—and to be sure, you can do some pretty useful things with it. Until recently, though, Cortana was not able to perform one of the more tasks you might expect of a personal assistant—making lists....

If you just need encryption for internal server connections or non-user facing sites, signing your own SSL certificates is an easy way to avoid dealing with an external certificate authority. Here’s how to set it up in nginx. If you are more interested in getting free SSL certificates, you can always use LetsEncrypt, which is more suitable for public servers with user-facing websites because it will show up as coming from a recognized certificate authority in user’s browsers....

With contact groups, you’ll never have to manually add the same people to an email over and over. By grouping regularly used contacts, you can save tons of time in the future. Here’s how to do it on a Mac. Creating a New Contact Group Open the Contacts app on your Mac. You can find it in your “Applications” folder or search for it with Spotlight. Make sure to select the account (in the left sidebar) where you want to create the group and then click the “+” button....

An ISO file is a complete disc image of a CD or DVD bundled into a single file. You can mount an ISO file to make it available as a virtual CD or DVD, allowing you to convert physical discs to virtual ones. ISO files are particularly useful if you want to use old game or software discs on a modern computer that doesn’t have a disc drive. Although, you should note that some DRM copy protection schemes won’t work with ISO files, unless you jump through additional hoops....

We have been talking about Apple’s new Photos application since it was recently released as part of a larger OS X system update. Today we want to cover how to create slideshows and other projects like calendars, cards, and books. Photos isn’t an overly complex application. It’s intended to be OS X’s go-to native photo management tool. You can use it to edit photos and sync everything to iCloud so all your Apple devices – other Macs, iPhones, iPads – have the same photos on them....

Sway is designed for a new era of publishing and communication. An age that focuses on the web and mobile. It’s is also available as a modern application on Windows 10 and mobile platforms such as iOS and Android. Publish Content Using Microsoft Sway If you are running an older version of Windows or an alternative platform such as macOS, you can access the service through a supported web browser to create your Sways....

The shortcut to crop an image in Illustrator is to use the Crop tool. To crop an image in Illustrator 2022, open the File menu and choose “Crop. To crop an image in Adobe Photoshop, select the Image > Cropping tool and then click on the desired area of the image to crop. Yes! You can cut photos in Illustrator using the “Cut” button on the toolbar. There are a few reasons why you can’t crop an image in AI....

There are many ways to crop a screenshot. One way is to open the screenshot in an image editor like Microsoft Paint or Gimp, and then use the cropping tool. Another way is to take a screenshot of your computer screen, and then crop it using the free program SnagIt. The screenshot function is not a cropping tool. It is simply a way to take a snapshot of your screen....

To crop an artboard in Illustrator 2022, you can use the following steps:Choose the Artboard > Crop tool.Change the size of the crop area.drag and drop the artboard onto a new layer or object. To crop an artboard in Illustrator 2022, you can use the following steps:Choose the Artboard > Crop tool.Change the size of the crop area.drag and drop the artboard onto a new layer or object. To crop a sheet in Illustrator, first select the area you want to crop and then press the Command (Cmd) key....

In Microsoft Excel, it’s a common task to refer to cells on other worksheets or even in different Excel files. At first, this can seem a little daunting and confusing, but once you understand how it works, it’s not so hard. In this article, we’ll look at how to reference another sheet in the same Excel file and how to reference a different Excel file. We’ll also cover things like how to reference a cell range in a function, how to make things simpler with defined names, and how to use VLOOKUP for dynamic references....

Generally speaking, being in the backseat of a car means that you are not in the driver’s seat. This can be a sign of subordination or dependence, depending on the context. The backseat of a car is typically called the “rear seat. It is not advisable to put a carseat in the backseat of a car if there are other passengers in the vehicle. The backseat can become dangerously crowded and a carseat could be crushed or injured....

Set Your Theme, Background, and Color There are three core aspects to customizing the way your Xbox looks: the theme, background image, and user color. Changing the theme is a simple case of switching between a light and a dark Xbox dashboard. To change it, launch Settings. Then, under General, choose “Personalization,” followed by, “Theme & motion.” You can also pick “Scheduled,” which changes your theme dynamically to match the time of day....

Sony’s PlayStation 4 has a social media-style dashboard. Your friends can view your PlayStation activity along with your real name, and your account may be discoverable to your Facebook friends if you’ve linked your PlayStation 4 with Facebook. You can manage these privacy settings in your PlayStation 4’s Settings screen, tweaking them to whatever you’re comfortable with. To access these settings, head to your PlayStation 4’s home screen, press “Up,” scroll to the right, and select the “Settings” icon....

To cut out a shape in Illustrator, you can use the following steps: 1. Choose the object you want to cut out and click on the Edit button. 2. On the Edit menu, choose Cut. 3. In the Cut dialog box, enter the dimensions of the shape you want to create and click on OK. 4. Click on the OK button to close the Cut dialog box and start cutting out the shape....