How to Paste Data Vertically When it is Copied Horizontally in Excel One important tool in Excel 2013 that we will be using is the Paste Special utility. Microsoft understands that copying and pasting is not always as simple as moving data, and that sometimes you just want the values from a group of cells and you do not want to paste everything exactly as it was originally copied. So once you have followed the steps below to learn how to paste your horizontal data into a vertical area, you should explore the Paste Special options a bit to see if they can help you....

How to Print on Your Canon Pixma MX340 from your iPad 2 The ability to print from your iPad 2 is pretty interesting, and it is nice to see how easy it is to connect your device to the Canon MX340 printer. You can go from nothing to printing in less than five minutes. Ensure that your iPad 2 and your Canon MX340 are on the same network. Launch the App Store on your iPad, then type “Canon” into the search field at the top-right corner of the window....

How to Print the Last Page First in Word 2010 This method is specific to the Word 2010 program, so it does not matter which type of printer you are using to print the document. Additionally, you are going to be changing the default settings. So if you only want to print this specific document in reverse order, then you will need to change this setting again before you print your next document....

When working with large spreadsheets that need to be printed, it can be difficult to determine which row or column contains which type of data. This problem is increased as you move to pages beyond the first, as your titles are no longer visible by default. Fortunately, however, Excel 2010 has an option that will allow you to print your titles at the top or left of every page to make it easier for readers to correctly identify data....

Powerpoint 2010 has a pretty impressive amount of options when it comes to placing objects in your slideshow. But aside from the variety of items that can be in a Powerpoint file, there are also a number of ways that you can edit, move or position those items. So if you have initially placed a text box in a slide, then you insert an image, you may be wondering how to re-position these objects so that the text box is on top of the image....

For example, changing the font size or using a different font may not make the text any more or less readable. But if you draw a line through some of your text, it’s possible that some people might have trouble reading it. Our guide below will show you how to remove strikethrough in Google Sheets if you no longer wish to use that effect on your data. How to Get Rid of Google Sheets Strikethrough Our guide continues below with additional information on how to remove strikethrough in Google Sheets, including pictures of these steps....

There are a lot of things that you can do on your iPhone when you do things like swipe or use a long press. Our tutorial below will show you how to save a picture from a Web page on your iPhone 5 so that it will be in your Photos app and you can do the same things with that image that you would do with pictures that you take yourself with the Camera app....

Optimizing Images for the Web in Photoshop CS5 There is a lot of unnecessary file information in most of your images that can be harmlessly compressed or removed to reduce the size of an image file. This is where the majority of the file size reduction will come from. However, if you want to see some drastic file size changes, then there is going to be some loss of quality....

Instagram Posts are out there to be seen, enjoyed and at times saved up, to be watched later. As Instagram users we are often curious to know who have seen and saved our posts or which ones have turned out to be the popular ones. One feature that Instagram possesses is that of saving posts you like. But what about the posts that you put up and how do you know who all have seen and saved them to see them later?...

But your friends are not included in Game Center by default, so you need to send them Friend Requests so that they are accessible. Our tutorial below will show you where to go in order to start inviting friends to your games. Sending a Friend Request Through the Game Center App on Your iPhone The steps in this article were written using an iPhone 6 Plus, in iOS 8.4. Exact steps and screen may vary for different versions of iOS....

Besides limited video size, there is also a restriction over the format of the files. WhatsApp supports video formats – MP4, 3GP, MKV, AVI,and MOV. Also, you might have to keep H264 video codec and AAC audio codec to successfully share a video to Whatsapp contacts. What are these limitations for? Well, WhatsApp servers need to be clutter free. Only then can they work in a hassle-free manner. No matter what file we share with our WhatsApp contacts, usually it is a file saved on your mobile storage....

One of these features is an alarm clock that you can use to wake you up in the morning, or alert you to an event that is occurring at a specific time. The alarm clock feature is included on your iPad by default, so continue reading below to learn how you can set an alarm on your iPad. The iPhone has a similar alarm clock feature, which we discuss in our how to set alarm on iPhone 11 article....

The Maps app will give you directions in the default type of transportation that is set. You are able to change the transportation type, but you might find that it is always, for example, giving you driving directions when you will actually be taking public transportation. Our tutorial below will show you where to find the setting that controls this default choice so that you can select the one that is most appropriate to you....

The Netflix app can be downloaded to your device for free (aside from the cost of the monthly subscription) and you can start watching videos on your iPhone in only a few minutes. All that you will need to do is know the email address and password for your Netflix account, then you are all set to begin streaming all of the great content that Netflix has to offer. Plus you have the added bonus of being able to use that same Netflix account to stream videos to your Xbox, computer, iPad, Roku and more....

If you are already using Gmail as your primary email account, then you are probably aware that it is one of the best free mail services that you can use. It is especially adept at handling large volumes of email, as it is able to leverage Google’s excellent searching functionality to help you locate a specific email message. But sometimes you don’t have a lot of information to go on while you are looking for a message, and the search feature might not be too helpful....

Fortunately the ruler is still part of Microsoft Word 2010, although you may need to adjust a setting in the program to make it visible. Fortunately adjusting the ruler visiblity setting requires just a few short steps, which we will walk you through in the guide below. How to Get the Margin Ruler in Word 2010 The steps in this guide were performed in Microsoft Word 2010. However, this setting is located in the same place in Word 2007 and Word 2013 as well....

If you use the calendar on your iPhone to manage your schedule, then you are likely accustomed to the large number of calendar event notifications that can occur during the course of the day. If you work in an environment where everyone uses their calendar, and frequently sends out calendar invitations for meetings and events, then these notifications can become overwhelming. Fortunately, you can modify a lot of the calendar notification settings on your device, and you can even specify settings that apply directly to calendar invitations....

Some media apps, such as Hulu Plus, Netflix and Spotify, can quickly use your cellular data. One way to ensure that they don’t, however, is to simply adjust the cellular settings on your iPhone so that certain apps can only use data when they are connected to a Wi-Fi network. Our tutorial below will show you how to stop Spotify from using cellular data on your iPhone. Restrict Spotify to Wi-Fi on an iPhone The steps in this article were performed on an iPhone 6 Plus, in iOS 8....

It’s pretty common now for this to happen, and you might like to be able to quickly view the different inbox for those email address. Our tutorial below will show you how to easily switch between email inboxes on your iPhone. How to Go to Another Mail Inbox on You iPhone Our guide continues below with additional information on how to switch between email accounts on your iPhone, including pictures of these steps....

The Clock app on your iPhone has some helpful utilities such as setting alarms, timers or running a stopwatch. You can even customize those features even further, such as setting your alarm so that it only vibrates. But there are some clock-related settings that you might need to adjust, such as whether or the clock on the device is in the 12 or 24-hour format, that you won’t be able to adjust in the Clock app....