How nice it would be if one wants to transpose the data of a column to a row and could do in just a few steps? If you are wondering whether if any such method exists then, we are extremely glad to tell you that if you are working on Excel then you can easily do that.
So, let’s see how to transpose in Excel?
How to transpose in Excel?
The literal meaning of transpose is to “INTERCHANGE.” So, talking regarding the MS EXCEL function, it transposes the parameter given to it. For instance, if a horizontal range is given as a parameter, then the transpose function will return a vertical range as the output. It is basically a worksheet function.
The general syntax of transpose function goes as “Transpose (range).” The field signifies the range of the cells that one wants to transpose. Additionally, one must be aware of this fact that the range of the transpose function must be entered as in the form of an array.
So, in the following read, I’ll walk you through “How to convert a row to a column in Excel the easy way.” So, let’s get started:
Step #1: The first step is quite obvious. All that you require doing is to open the MS Excel application on your system. For this, you can consider the following way. Go to the start button, navigate to the all programs option, go the installed “Microsoft Office version” folder, and select “Excel” from there. This way you can open MS Excel easily on your system.
Now, you have to look for our next steps in order to proceed further.
Step #2: Now, you need to open any existing worksheet on which you want to perform the transpose action. Alternatively, you can open a blank workbook and then enter data just in order to get equipped with the knowledge of “How to use the transpose function?“
By now, you should have the data on which you want to perform the transpose function.
Step #3: Now, in this step, you need to select all those data which you want to transpose. Always remember that all the data should belong to a particular cell. Like if you are selecting data horizontally then you should not select any data vertically.
Once you have selected the data, then you now need to copy it to the clipboard. For that, you can indeed use the keyboard shortcut “Ctrl + C.”
Now, look up for the next steps in order to transpose in excel.
Step #4: In this step, you now need to select the cell by which you want to transpose the chosen data. Been there, done that. If yes, then now right-click on that particular cell and select the “Paste Special” option.
This activity of yours will open a window with some options. From that window, you are required to select “Transpose.” After this, you only require clicking on “OK.”
You will have the desired result in front of you.
[Additional Information]: How to use formulas in Excel?
Now, you know How to transpose data in excel? So, you are somewhat familiar with the use of functions in Excel. Since transpose is a function in itself so, we thought of making you equipped with the knowledge of how to use formulas in Excel? So, We urge you to pay heed to this additional section as the use of functions in Excel is quite stupendous. So, without wasting any time further, let’s get started:
Step #1: In order to get started, let us first see the basic syntax of an Excel function. The Excel function starts off with an equal sign, followed by the function name and then the arguments or parameters of that particular function.
So, it will look something like this: =SUM(A1: 1A2) which implies that we want to add the element one and two of cell A.
Now, we are aware of functions so, let’s move on to our primary concern which is to tell you how to use functions?
So, for this, you will have to open the Excel workbook on your system. You can consider the following way, click on start and type MS Excel and after the appropriate result appears, click on it and this will open the Excel application for you.
Noe, all that you require doing is to open the desired worksheet over which you can perform the basic operations using functions, in order to learn them. Or you can open a blank worksheet and enter some random values.
Step #2: Now, let’s assume that you want to add elements of a cell using functions. In this step, we will tell you how to add values using the SUM function. So, all that you have to do is to click on the very next empty row, just below the last element.
Now, you need to click on the “fx” option. For your convenience, we have marked it red.
Clicking on it will open a dialog box, from which you can select any of the predefined functions. But, as we want to add the elements so, we have to select “SUM.”
From the subsequent window, you will be prompted to provide the argument or the parameters. Like, in this case, we want to add up all the elements of cell A. So, by default the parameters are A1: A4. However, you can change it if you wish. Once you are done all this stuff, then click on OK, and you will have your desired output in front of your screen as shown.
This way you can use any of the formulas in order to make your calculations a little easier.
So, this was all about How to transpose in Excel? We hope that after going through this very article, you must be able to do the desired work.
So, if you liked this article, then do let us know through the comments section down below. Additionally, do not forget to give us a thumbs up through our Facebook page and share this as much as possible.
Keep visiting and stay tuned for more of such informative articles.
How to Double Space in Word?
Microsoft Office Word is a widely used application for editing and writing documents. Documents serve their purpose well if their readability is excellent. So, for this, it becomes primarily necessary to format the text.
So, you might want to know how to double space in word? If you want to know about that, then you have landed in the right place. This article will also end your quest on “How to change line spacing in Word?“
In this article, we will tell you how you can do the same in easy and straightforward steps. We will try to equip you with the processes required for double spacing in word. So, let’s get started:
How to Double Space in Word?
Superficially, in a document, spacing is used to increase readability. The better the readability, the better the document serves its purpose. So, you should consider using a double space in word as it surely increases the readability.
In this section, we will make you aware of the steps required for applying a double space in a word document. The prerequisites for this method are a Microsoft Word application and a document file.
Method 1: In Microsoft Word 2007 and above.
This method will work only if you are using any of Microsoft Word version 2007 and above. So, make sure to have one before proceeding further.
Step #1: As the very first method, you will have to open the Microsoft Word application in your system. To do this, all that you have to do is to click on the start button (In a case of Windows 7) and then click on “All Programs” and then “Microsoft Office”.
From the list of options, you will then have to select “Microsoft Word” or “Word 2003/2007/2013” and this will open the word for you.
Alternatively, you can also search for the same and get your application open for you.
If you are done with this step, then you are good to go to the next step.
Step #2: This step will help you to set the whole document with similar line spacing. The changes will take place from the line where your cursor is currently at. To do this, all that you have to do is to navigate to the Home tab which is usually positioned at the top left corner of the window. Once found, you will have to click on it.
By default, you will have home tab selected.
Step #3: After successfully executing step #2, you need to click on the line spacing button which has four lines with an up down arrows. This will open a drop down menu for you from which you have to select “2.0” as an option because you wanted a double space.
However, you can choose any of the available numbers, and this will do the needful for you. You can get access to more options by clicking on the “Line Spacing Options” button from the menu.
If you want to change the spacing for a selected text only then, you can also do just by selecting the text and then doing the mentioned as specified above.
Step #4: Additionally, if you want to change the paragraph spacing then you can also do the same very easily. In this step, we will be showing you how you can do so. You will have to click on the “Page Layout” tab and after that, just below the navigation panel, from the “Paragraph” section; you will see the spacing section.
From that, you can change both the before and after spacing settings. By default, the before and after settings are set to 0 and 6 pt respectively.
Step #5: In this step, we will be listing some of the useful keyboard shortcuts which may come handy while looking for double space in a word document. This will save a heck lot of time of yours.
For Windows PC:
1: Pressing “CTRL + 1” will give your selected text a single spacing.
2: Pressing “CTRL + 1.5” will give your selected text a spacing of 1.5 pt.
3: Pressing “CTRL + 2” will give your selected text a double spacing.
For MAC operating system:
1: Pressing “Command + 1” will give your selected text as single spacing.
2: Pressing “Command + 1.5” will give your selected text a spacing of 1.5 pt.
3: Pressing “Command + 2” will give your selected text a double spacing.
Method 2: In Microsoft Word 2003.
If you are using Microsoft Word 2003, then this section will tell you how to double space in word 2003.
Step #1: Launch your word 2003 application and open the document in which you want to make the changes. Once you are done with all this, then you can proceed to the next step.
Step #2: Now, select the text which you want to be double-spaced. You can make use of “CTRL + A” if you want to select all the text.
Additionally, if you want to select a particular part of the text, then you should consider using the arrow keys and “Shift” key.
Step #3: Now, in this step, you will have to navigate as mentioned. First, go to “Format” and then navigate for “Paragraph”. After this, you have to click on line spacing drop down box which will open a drop down menu for you. Now, you can select the desired spacing, and once you are done with this, all that you have to do is to click on “OK” button.
This way you can easily double space in word either in Microsoft Word version 2003 or 2007 or above.
This wrapping up section brings us to the end of this tutorial cum guide on “How to double space in Word?” We hope that we were efficient enough to satisfy your curiosity about this topic.
We firmly believe that we have left no stone unturned while getting into the nitty-gritty of the topic and making you understand the entire concept of it. But if you still have any queries regarding double spacing in word then feel free to drop your query via comments below. We will try our level best to resolve that.
Moreover, if you found this article helpful and worthy, do show your love by sharing it socially.
How do you double space? We will love to know if you have any alternative methods.
Thank you for crossing by and giving it a read.
How to Strikethrough in Excel?
Microsoft Excel contains a variety of formatting options. Along with bold, italic, underline, you can also strikethrough in excel for highlighting the text.
There may be various reasons for using the strikethrough text. For example, you can use strikethrough to mark the tasks as completed, to highlight the particular text or a cell etc.
If you don’t know how to do a strikethrough in excel, then read out the guide.
However the procedure for making text strikethrough is just a few clicks step, but if you feel difficult to finding the options then the guide how to put line through text in excel will help you doing that.
How to Strikethrough in Excel
In this guide, along with strikethrough, we will also let you now how to remove strikethrough in excel.
The procedure for how to cross words out in excel contains just a few steps. Read out the guide and learn how to strikethrough word in excel program.
The steps are given below.
Step 1: First of all, open the MS excel program to your system. To do so, go to start menu and then select all programs. In the list of all programs, select MS office and then click on the programs MS excel.
Step 2: Now type any word or sentence you want to strikethrough in excel. For example, I have typed the word Strikethrough in Ms Excel in the first cell.
Step 3: Now to strikethrough word, first, go to Format cells. This is the window where, you can change the font type, font style, font size and can do various changes in texts.
One of the effects you can add to the text is Strikethrough them.
To go to the format cells, go to the menu bar and click on the arrow showing in the Font section. If you are unable to find the option, check out the image I have mentioned below. This is the screenshot, I grabbed for your better understanding.
Step 4: As sooner you click on the arrow, a dialogue box format cells will pop up. As I said above you can make various changes, add effects to the text, increase and decrease the size for the font via this dialogue box.
Apart from that, you can also change the color of the font. For this, you will have to go to the color section.
But since you are here to make the text strikethrough, go to the effects section. Check out the image I have mentioned below. I have marked the effects section with red. Check it out.
Step 5: Ok, now to make the text strikethrough, first, select the text, or cell and then mark the checkbox by clicking on it. And click on Ok.
As sooner you click on ok, the word, sentence, or cell, you selected would be converted to the crossed. And the crossed word would something like the image I have mentioned below. Check out that.
This is how you can convert the text to the strikethrough in excel. Apart from this, you can also go to the format cell by right-clicking on the cells.
For example, if you want to go to the format cell, then select any cell. As sooner you do this, a dialogue box containing various options would appear. One of the options would be Format Cells. Select that, and the same dialogue box that you saw in step 4.
Now simply select the strikethrough option and click on ok. the word would be converted to the strikethrough text.
Let me tell you, these words can be converted into normal fonts as well if you want. For this, you will have to follow all the above procedure and then uncheck the box you checked to make the word strikethrough.
Check out the image below. After seeing the image, I don’t think you will face any difficulty while removing the strikethrough from words.
This is how the strikethrough in excel is performed. I hope you have got all the steps clearly and have no more confusion regarding the procedure. If you have any, you can ask us by dropping the comment in the comment section. We will try to reach out to you ad soon as possible. Now let’s check out
However, there should not be nay doubt, since the procedure is very short and easy. But in case if you have any query, do drop the comment.
Now let’s check out strikethrough shortcut key for Ms excel.
First of all, to make any word, sentence, text or cell, strikethrough, select that. Once you are done with the selection, press the key CTRL+SHIFT+F or CTRL+1. This shortcut would immediately launch the format cell dialogue box.
Once the dialogue box is open, I am sure you know what you have to do next. Simply select the strikethrough and click on ok.
This was the shortcut for opening the format cell dialogue box. There is an another shortcut which will help you quickly apply or remove strikethrough formatting without using the dialog box. And the shortcut is CTRL+5.
All you will have to do is click on the cell, row or column you want to make strikethrough to. After selecting the text, you will have to press CTRL+5. And the word or cell would be immediately converted to the strikethrough.
You can create your own handy strikethrough button as well if required. For this, follow the below steps.
Step 1: First, click on the icon placed at the right of the Quick Access Toolbar to open the list I have mentioned below.
Step 2: In the list, select the option More Commands.
Step 3: Once done, select the option Commands Not in the Ribbon. You will find the option in the Choose commands from drop-down list.
Now simply scrolls down until you find Strikethrough and select it. Once done, click the Add button, and then OK. And you are done.
Excel has a lot to explore and you don’t need any technical skills for that. You can easily manage your data using MS Excel. Here is some basic of excel that you should know for using excel. You can add numbers in excel, you can easily divide the numbers in Excel. For finding the average, you should see how to calculate Average in Excel. Using these basics, you can do a lot of work on Excel.
So this is how we apply strikethrough to the text in MS Excel. If you liked and enjoyed the guide share it on social media platforms.
How to Find and Replace Text Using MS Word?
In today’s article, we are going to teach you How to find and replace text using MS Word.
Find and replace is one of the most useful features provided by MS word. Find and replace allows users to find a particular word from the large document. And replace is used to replace any particular word.
When you are working on a lengthy document, then making a single mistake can cost you a big loss. Especially when the document is official.
For example, you are working on a document, where you have to put some amount or so. What will happen if you have entered the rs 5000 instead of 50,000?? Or vice versa? And importantly the digit was written multi-time on the same document.
And you have very less time to edit that. What would you do then? Then you will use the Microsoft word find and replace feature. I will let you know the procedure. Also, take a look at converting Word document into PDF.
How to Find and Replace Text Using MS Word
Microsoft word is one of the best programs that allows creating and editing the documents. However, there is no need to tell you much about the MS word, since you might already know that.
Instead of discussing the MS word features, we will we discussing the find and replace feature of MS word.
Find and replace is one of the most used features. However in our daily life we don’t feel the much need of using it, but for the professionals, having knowledge regarding it is the must.
Simply read out the guide and learn how the find and replace feature is used to find or for replacing the words. In the first half of the guide, we will share the method to find the word and the other half would be telling you the procedure to replace the word.
Step 1: Assuming you have already a lengthy document and you want to find a particular word. For instance, we will be finding here the word MS word.
In the above image, as you can see there is a paragraph written. In this paragraph, we have to find a word MS word. And for that, you will have to go to the find and replace dialogue box. To do so, follow the next step.
Step 2: To open the find dialogue box click on the Find option. You will get the option to the right side of the home tab. Or, press the CTRL+f key from the keyboard.
Step 3: As sooner you press the key, a small dialogue box will pop up. The box would be looking like the image, I have mentioned below.
Step 4: Now in the find, box, type the word you want to find. As we are about the find the word MS word, I will enter the same in the find box.
Step 5: Once done with typing the word, hit enter. Or click on the Find Next button. As sooner you click on the find button or hit enter, you will see the word you made the search for, would go highlighted in the paragraph.
If you want to highlight all the words in the same document, then click on the button, Reading highlight. And select highlight all.
As sooner you click on the highlight all button, the word, you made a search for, would go highlight in all over the document. Check out the image I have mentioned below.
Apart from that, you can also find more options by clicking on the More>> button. If you want to make a search for the same word, you have previously searched for, click on the Match case option.
When you click on the match case option, at the top of the dialogue box, you will see a drop down button, where you can select the word, you want to make the search for.
Similarly, you can use other options too, when needed. The option find itself is a vast to use. You will get better if you try the option by yourself.
So this is how the find features are performed in MS word. Just like the find, find and replace is also very useful feature. Check out the steps how to use the replace option in MS word.
Step 1: First of all, to open the replace dialogue box, type the CTRL+h from the keyboard. Or, go to the home tab, and click on replace option from the editing section.
Step 2: After clicking on the replace option, a Find and Replace dialogue box will pop up. Here, you will see two text fields, one, Find what and the other one, Replace with.
Step 3: In the find what field, type the word, you want to replace in the document. For example, I want to replace the word, later with earlier. For that, first I will need the word later in the find text box. And, in the next texts field that is replace, I will enter the word, earlier.
Step 3: Now simply click on the Replace button. If you want to replace the word later, from everywhere it is written on the document, click on Replace All.
As sooner, you click on the replace all button, the word later would be replaced with the word earlier from all over the document.
Apart from that, just like find option, you can also use the advanced options by clicking on the More button.
Now after learning how to find and replace text using MS word, I am sure you have understood how this feature can be helpful when you have to correct the mistake or have to make the changes in a lengthy document.
Do let me know, how do you find the tutorial. If you have nay doubt or confusion or have any suggestion, do drop your comment below.
If you liked and enjoyed the guide, you can share it on your social media platforms. You share would be appreciated.
How to Recover Unsaved Word Document?
Writing an important article and forgot to save the document somehow? If ever you have encountered this problem, so here we are with mighty solutions for it.
This article will tell you how to recover unsaved word document? in easy and simple steps. So, let’s get started:
How to recover unsaved word document?
Method 1: Search for the document.
In this very first method to recover unsaved document, we will search for the document. For this, you will have to consider the following steps:
Step #1: The basic idea of this step is to get to the search box. You know that there are different methods to get to the search box. In windows 8 or 8.1, you will have to go to the right corner of your screen and from there you will get the search bar. While in Windows 7, you can simply go to the start menu and search for the specific file.
If the specified file is listed in the result then you can simply click on the file to open it up. If not, then go to the next step.
Step #2: Now, you need to type “*.docx” or “*.doc” in the search box. This will display the files which are of the document type. Care to see if the desired document is present over there or not.
If this method ain’t working for you then you should move on to the next method.
Method 2: How to recover a word document using Recover Unsaved Document option.
In this method, we will make use of the Word inbuilt feature which helps us to recover unsaved documents. So, let’s see how.
Step #1: First of all, you will have to open a Word application on your system. Doing this will complete your very first step.
Step #2: Now, if you are using Windows 2013, you will see an option named as “Open Word Document” at the end of the leftmost pane.
Step #3: The previous step will open another window which will show all your recent documents. You need to scroll down to the bottom where you will see an option named “Recover Unsaved Documents”. In order to recover the documents, you need to click on it.
Step #4: After completing the previous step, you will see a Windows prompt which will open all the unsaved documents which are being saved at the unsaved document folder. Unfortunately, we do not have any unsaved file as of now but you will see all your unsaved files at the following window prompt.
Once you have found the specific file, then you now need to click on open, and this will open the file for you in Word interface. We recommend you to save the document immediately. Also, take a note that the unsaved documents are saved with “.asd” extension.
Alternatively, there is one more method to reach this stage. All that you require doing is to open a word and a blank document afterward. Now, you need to click on the “info” section at the top.
Now, you need to look out for the versions section. Under the versions section, you need to click on the “Manage Versions” option and this will open the drop-down menu for you. From the menu, you need to select “Recover Unsaved Document”.
After this, you will see a window from where you will have to choose the specific file which you want to recover. To save that, all that you require doing is to open it and save it using the normal procedure.
Method 3: How to recover word document using a temporary file method.
In Windows operating system, for any desktop applications, a temporary file is created so that necessary user editing can be handled. MS Excel, MS Word-like application makes extensive use of this feature.
This means that there are chances of recovering the unsaved document from the temporary folder. However, this method doesn’t guarantee the stuff but it’s better to give it a try if nothing else is working out for you.
So, let’s get started with this method:
Step #1: First of all, you will have to open the word application on your system. Once you have done the same then you are required to move on to the next steps.
Step #2: Now, you need to click on open and then browse to the following location “C:\Documents and Settings\Administrator\Application Data\Microsoft\Word“. You can consider replacing the “Administrator” with your system name.
At this location, you will see the unsaved files, if any. Just click on the desired file in order to open it. We recommend you to save it immediately so as to prevent any data loss.
[Additional Information]: Did you know that word autosaves your document?
Well, you should be aware of this fact that Word autosaves your document every 10 minutes [Default]. However, you can change the settings. So, just in case if you want to know, we will be telling you the exact method to do that.
Step #1: First of all, you need to open the word application and open a word document (be it blank). Now, you need to click on the file option from the uppermost ribbon. Now, you need to click on “Options” from the subsequent window.
Step #2: Now, click on the save button. Now, you can easily change the autosave time by going through the “Save AutoRecover information every” option.
Step #3: As the last step, you are required to click on OK and this way you are done with it.
This marks the end of this article on “How to recover unsaved word document?” Do we hope that following the mentioned ways you can easily get to know how to recover document in Word?
If you have any other method of how to recover an unsaved Word document, then do share it with us through the comments section. We would love to hear from you. If you liked this article, then do not forget to share it with your peers. Thank you for passing by and giving it a read.
How to Set the Default Font in Word?
Without any doubt, fonts are one of those elements which can create a spectacular impact on the reader. So, in order to make your document super impactful, you would like to use good fonts in a document.
But how can you set your favorite font as the default one in Microsoft Word? If you are going through this query then this article has all the answers.
So, in this article, we will tell you How to set the default font in Word? After going through this article you will be capable of changing the default font in Microsoft Word. So, let’s get started:
How to Set the Default Font in Word?
Step #1: In this very first step of this method, you are first required to open Word application on your system. For that, you can consider going this way. First, go to the start section and type “Word.” After getting the relevant result, click on that and this will open the Word application for you.
Now, after this, you are required to open any word document which has some content in it. Alternatively, you can open a blank document and enter some random text on it. Go for whatever suits you best.
Once you have done this then, you are required to look out for our next steps.
Step #2: In this step, you will have to select some part of the text so that we can select the font and then set it as the default one. So, for this, you can place the cursor and drag it till the point you want to select the text.
Step #3: After you have selected the text then now you are required to make a click on the “font” icon at the home tab. It looks very similar to a diagonal arrow placed in an inset.
Clicking on it will open a dialog box as shown below.
Step #4: Now, click on the down arrow button at the font field. This will open a list of the available fonts. Now, you need to select the appropriate font which you want to set as default. You can also see the preview of the font in the font section.
Once you have selected the font and other fields according to your needs, then you are now required to move on to the final step.
Step #5: Now, in this final step all you need to do is to click on “Set as default.” This will open a dialog box that will ask you whether you want to set the default font for the current document only or all other documents as well.
Since you require setting the selected font as the default one so, you need to choose the checkbox next to which “All documents bases on Normal.dotm template” is written.
Just confirm your action and click on OK.
This will set the default font in Word. See, how easy it is.
[Additional Information]: How to add fonts in Microsoft Word?
Many times, you would find the pre available fonts in Microsoft word not appropriate for your needs. So, in that case, you would like to install other fonts. If you want to know how you can do that, then you are certainly in the right place.
In this additional section, we will walk you through all the steps that are required to add a font in Microsoft Word.
So, let’s get started with the same.
Step #1: First of all, you are required to download the desired font. For this you can make a search on your favorite search engine or visit some good free fonts sites like “dafont.com” or “1001fonts.com”.
You can visit any of those and download the fonts which suit your requirements. Once you have downloaded the font, then you can indeed proceed with the next steps to look into the proceedings.
Step #2: In the most general cases, the font will be downloaded in zipping or RAR format. So, after downloading the font in step #1, you now need to extract that font.
For this, you should have any good zip or RAR file extractor. WinRAR is one such good software to do the needful. However, if the font comes as a sole otf or ttf file then you can skip this step.
In order to extract the font, all that you need to do is to make a right-click on the downloaded folder and then select “Extract here” or “Extract files”.
The latter one will open a window to which you have to specify the path of where you want to extract the font while the former one will extract the font to the current folder.
We recommend you to extract the font at the current folder and then copy it to the desired folder of which we will be telling you in the next step.
Step #3: After you have extracted the font from its folder then you are now required to copy the font to the following location “C:\Windows\Fonts“. Now, you will have to navigate to this folder and look out for your desired font.
Been there, you now need to double click on that font in order to install it. The font will now be installed once you click on the install button.
Step #4: Now, you will be able to see the font on your Word application. You can now set it as the default font in Word by using the method provided above (if only you wish).
So, this wrapping up section brings us to the end of this article on “How to Set the Default Font in Word“. We hope that after going through this article, you will be able to know ” How to set and keep your preferred default font in MSC Word“.
If this article has helped you in any manner, then do not forget to share it with your peers. Additionally, if you have any other method, suggestion or query regarding this topic then do let us know through the comments section below. We would love to hear from you.
Thank you for passing by and giving it a read.
Stay tuned and keep visiting.
Computers1 year ago
How to Reset Macbook Air?
Mac3 years ago
How to Use Apple Thunderbolt Display with PC?
iOS1 year ago
How to Stream Torrents on iPhone?
Tech7 months ago
How to Tame a Horse in Minecraft?
Tech8 months ago
How to Make a Yahoo Account Without a Phone Number?
Tech8 months ago
How to Solve Yahoo Mail not Working?
Tech9 months ago
How to Receive Money through PayPal?
Windows1 year ago
How to check RAM type (DDR, DDR2 or DDR3) in Windows?