Today I’ll show you how to create a drop-down list in a cell using Data Validation. Although I’m taking the screenshots using Excel 2016, the steps are the same if you’re using older versions. The steps are also the same in modern versions of Excel in the Microsoft 365 (formerly O365) suite. Create a Data Table and the List of Options First, set up a basic data table. You can either type your data in manually or copy and paste it from another source....

One of the more common object types in Publish is an image. Whether this is an image that you took yourself, or one that you got from another source, it’s very possible that your projects will require pictures. But if there are elements of your image that you don’t want, then you may be looking for a solution that will let you crop them. Fortunately you can crop pictures in Publisher 2013 directly by following our tutorial below....

The Status Bar is the handiest of tools that displays information, provides quick access to actions, and is fully customizable. If this nifty part of Office is new to you, we’re here to help! Here’s how to use the Status Bar in your Microsoft Office applications. Where You Can Find the Status Bar The Status Bar is located at the bottom of each Office application. And it’s not just for Word, Excel, and PowerPoint....

But as you are making the slides and adding content, you may find that a slide that you thought was important isn’t actually needed. If you have one or more slides that fit this description then you may be looking for a way to delete not just a single slide, but multiple slides from your slideshow. You can delete more than one slide at a time in Google Slides by holding down the Ctrl key on your keyboard (or Command on a Mac) then clicking each slide to remove....

This variety can let you hear a lot of music, but it can also make it difficult to find certain things in your collection. Luckily you are able to manage your Pandora account from your iPhone app and remove stations that are in your collection if you don’t listen to them anymore. How to Delete Pandora Stations on the iPhone app Our article continues below with additional information on how to delete a station in the Pandora app, including pictures of these steps....

The screen recording feature on your iPhone makes it easy for you to take a video of what you are seeing on your screen. Whether you are recording a game or a series of actions, the ability to create a video and save it to your Camera Roll is very useful. But if you don’t like the screen recording feature, and don’t want your child or another user to be able to take a video of your device’s screen, then you may wish to disable screen recording on the iPhone....

Unfortunately, touchscreens on laptops aren’t perfect. They soon start to collect nasty fingerprints, smudges, and other forms of dirt. You may prefer to keep your hands off your screen—if that’s the case, you’ll be better off disabling your touchscreen entirely. If you prefer to use a mouse or touchpad, you can disable the touchscreen on a Windows 11 PC using the Device Manager or by using the command line....

One particular example is when your spreadsheet has a lot of data in it, but you want to draw your reader’s attention to a specific formula result. Our article below will show you how to display an Excel formula result in a text box. A text box in Microsoft Excel provides an option for displaying text which can be moved to nearly any location on your spreadsheet. You may have tried to enter a formula into a text box, only to find that the results of the formula will not calculate....

But you may be editing or viewing your presentation in a way that this is not the most efficient way to view all of the slides. If so, then you might prefer to view all of your slides as a grid. Fortunately this change can be made with the help of a single button in the Google Slides interface. How to Switch to Grid View in Google Slides The steps in this article were performed in the desktop version of the Google Chrome Web browser, but will also work in other desktop browsers like Edge or Safari....

But one of the best things about having an iPhone 5 is the App Store, from where you can download apps, services, games and more. There are hundreds of thousands of apps in the App Store, and likely dozens that you will find helpful. So continue reading below to learn how to download and install your first app. Getting Apps on the iPhone 5 In case you are unfamiliar with what an app is, it’s basically just a small program that is downloaded directly to your phone that allows you to perform a specific task....

However, the only major problem it came with was GTA Vice City game’s free download in PC and laptop. Notably, even after 18 years of GTA, a frequently asked questioned remains, “How to download GTA Vice City in laptop?” While free downloads until recently rarely meant privacy and ethical ways, we do have a good news for the classic GTA Vice City fans. Epic Games and Rockstar Games have announced that GTA Vice City is going to be made available for free....

The scribble shape allows you to make a freehand drawing directly in your document. Word will then convert the drawing to a shape object, where you can adjust the appearance of the shape that you just drew. Note that Word will create a new shape every time that you let go of your mouse with the scribble shape, so you will need to re-select it after letting go. You can also select one of the other shapes on the menu in our guide below, if your needs require a specific shape or straight lines....

The good news is you can enable dynamic refresh rate on Windows 11 to do exactly that. If you have the right hardware, you can let Windows 11 decide when you would benefit from a higher refresh rate, and when it’s better to turn the refresh rate down to save battery. We’ll explain how to enable a dynamic refresh rate on Windows 11 using the steps below. What is Dynamic Refresh Rate?...

Our guide below will show you how to turn on the Handoff feature on your iPhone so you can begin using this feature on other compatible device on which Handoff has also been enabled. Turning On Handoff on an iPhone 6 The steps below were performed on an iPhone 6 Plus, in iOS 9.2. Once you have followed the steps in this guide, the Handoff feature will be enabled on the device....

However, this setting is not always turned on by default, so you may be looking for a way to enable it if it isn’t currently active. The steps below will show you how to turn on the Speak Selection feature on your iPhone in iOS 10. How to Turn on the iPhone’s “Speak Selection” Setting The steps in this article were performed on an iPhone 7 Plus, in iOS 10....

Luckily there are several options for how to expand cells horizontally in Excel. We discuss three of those options in our guide below. How to Enlarge a Cell Horizontally in Excel 2013 Our guide continues below with additional information on how to expand cells horizontally in Excel, including pictures of these steps. You will eventually need to know how to enlarge a cell horizontally in Excel or how to expand all rows in Excel when you enter data into a cell and find that all of the data is not visible....

There is no expiration date on the post that you make to your Facebook page. Any posts made directly to your Facebook feed will be archived until you delete them manually. There are currently no plans to begin to sunset Facebook posts that users make. With that being said, it can be difficult to dig through hundreds of posts that you have made over the years to find the one that you are looking for....

The good news is you can find your printer information easily in Windows 11. It will display the printer model, manufacturer, serial number, and other important information. We’ll show you how to find printer model and serial numbers on Windows 11 below. How to Find a Printer Model or Serial Number on Windows 11 When you need new printer ink or troubleshoot an issue with your printer, it’s essential to get the model and serial number....

If you read our article on how to determine the architecture, edition, and channel of Windows currently installed, you’ll notice when you upgraded to build 10240, and Windows maintained the licensing status according to the channel. So if you upgraded from Windows 7 OEM or Retail, your free Windows 10 upgrade would inherit those channels. Details on Finding Key With build 10586, this is not as clearly defined since all November updates are automatically defined as from a retail channel....

But if you are new to using podcasts on Spotify, then you might be having trouble keeping track of or remembering the good podcasts that you have listened to. Fortunately you are able to follow podcasts in the iPhone Spotify app, which will cause them to appear in your library. Then it’s simply a matter of navigating to that menu and selecting an episode of your podcast to continue listening to it....