Web
Analytics
Connect with us

Microsoft Office

How to Set the Default Font in Word?

Published

on

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.

changing the default font in Microsoft word

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.

changing the default font in Microsoft Word

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.

changing the default font in Microsoft Word

Clicking on it will open a dialog box as shown below.

changing the default font in Microsoft word

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.

changing the dafault font in Microsoft word

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.

changing the default font in Microsoft word
changing the default font in Microsoft word

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”.

How to Set the Default Font in Word

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.

How to Set the Default Font in Word

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).

Wrapping Up.

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.

Continue Reading
Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *

Microsoft Office

How to Recover Unsaved Word Document?

Published

on

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.

How to recover unsaved word document

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.  

how to recover documents in word

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.

How to recover unsaved word document

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.

How to recover unsaved word document

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.

How to recover unsaved word document

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”.

How to recover unsaved word 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.

How to recover unsaved word document

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.

How to recover unsaved word document

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.

Continue Reading

Computers

How to Move Columns in Excel?

Published

on

How to use Microsoft excel

Do you ever want to know how to move columns in excel? If yes, then you are in the perfect place. We will be guiding you through the entire process via two methods.

The skill of moving columns in excel may come handy when you want to transfer data from one column or row to another quickly. So, give a thorough read to this article and equip yourself with this skill which will help you in the longer term.

How to Move Columns in Excel?

Method 1: Using Excel Menus.

In this process, we will make use of the options available in the Excel menu. So, without being a twerp by unnecessarily focusing on the less important stuff, let's dive straight into the method.

Step #1: In this very first step, you need to open up the worksheet on which you want to perform the respective manipulation that is the moving of the column. For this, you can move on to the storage folder of the document and double click on it. This way you can open your excel workbook.

How to Move Columns in Excel

Now, once you have your workbook open in front of you, so you can indeed proceed with the next steps.

Step #2: Now, it's kind of obvious that if you want to move something, then you will first have to select it. In this step, you are required to do the same. Select the column(s) which you want to move. You can simply click on the column header to select the whole. One can spot the column header easily as the letter over the data.
This makes the step way easy.

How to Move Columns in Excel

By performing this step, half of the battle is won. Now, we are a few steps away from the desired result.

Step #3: Now, head towards the navigation ribbon and click on “Home”. This will open a bar with many options.

Locate the “cut” option and click on it. Alternatively, you can use the default keyboard shortcuts like “CTRL + x” in windows and “Command + x” key in the Mac operating system. Go, whichever way it feels like going.

After going through the cut option, the selected column will look like this. If you are getting something similar to this on your workbook, then you are going great. Now, just follow the next steps.

Step #4: Now, select the column where you want to move the desired column. For that, you can choose any blank column and click on the header of it.

How to Move Columns in Excel

To insert the column, Right Click on the column you wanted to insert the column, select “insert cut cells”. The moment you have done this, you will have the column moved to the desired position.

The final result will look like this.

How to Move Columns in Excel

Method 2: Using Drag and Drop.

This method is by far the easiest way in this series. All that you require doing is to drag your column to the desired position. To make it easier for you, we will be showing you the step by step processes backed up with illustrations.

This method will help you in your quest for How to move columns with Drag and drop? Or How to easily reorder rows using drag and drop?
So, let's get started:

Step #1: Open the Excel document on which you want to perform the action.

Step #2: In this very second step, you need to select the desired column in which you want to move. For that, consider clicking on the top header which will ultimately select the entire column for you.

Now, let us suppose that we want to move the B column to the C column. So, we will do the thing for which you will have to look out for our next step.

Step #3: Now, position your mouse at the column till you get the following kind of cursor. Once you have got the following cursor, you are now free to drag the column to the desired position.

So, this way you have successfully moved the data of a column to another.

Now, here comes the turn of the rows. If you want the move one row to another, then all that you require doing is to select the row, position the mouse till you get the four directional arrow-like cursor and then move the data to the desired position.

Kindly take note that if you will try to move your data from a row to another which is already having some data, then you will get a prompt like this. Just confirm your action, if you wish to and this way you can easily move data from a row.

Just in case, if you want to move multiple columns then you can also apply the same tactics as mentioned. All you need to do is to select all the columns which you want to move to another. Do not forget to press and hold the Alt key while selecting multiple columns else you won't be able to select them all together.

After this, you can drag the selected portion to your desired columns, and this will do the needful for you.

So, these are the two methods with which you can switch Excel rows and columns. Do we hope that by using any of these methods, you will be able to know how to move columns in excel? 

If you are aware of any other ways, then do let us know through the comments section right below. Also, if you have some queries then kindly give us a line through the comments section. We would love to hear from you.

Additionally, if you liked this article then do not forget to share it with your peers.

Thank you for stopping by and giving it a wonderful read.

Stay tuned and keep visiting.

Continue Reading

Microsoft Office

How to Insert a Line in Word?

Published

on

How to Insert a Line in Word is one of the most frequent questions asked by Word users. Inserting a file between a word file is a common phenomenon. Adding borders and lines in Word is easier and just takes a few seconds. To segregate any line of text you can simply add horizontal lines to the file.

Not only it lends a neat look to the document but even makes it easier for the user to read and identify various segments in the text. How to draw a line in word is not as difficult as it seems to.

There are actually three or four different methods using which you can insert lines in Word. It all depends on your preference and the method which most appropriately matches your convenience.

Let’s take a detailed look at the methods on how to add lines in a word:

Inserting Lines with Shapes tool

It is a tool in Word that contains almost all geometrical shapes, be it rectangles, back arrows, lines, stars & banners, etc. Basically, any shape that is imaginable can be created via a Shapes tool. Take a look at how to add a line in the word:

  1. Open the MS office word file in which you want to insert the line.
  2. Navigate to the Insert tab. Click on the option Shapes and select the line shape.
  3. A plus sign will appear on your word document. Drag the mouse along this sign to get the required length of the line on the Word document.
  4. Click the line to open the “Drawing Tools” tab. As soon as it opens, see at the top to see the “Shape Styles” section of the ribbon. From here you can easily give colors to the line, change its thickness and shadow.

Now, in case you want to draw another line you can simply copy and paste the same line. Just press Ctrl + C to copy and Ctrl + V to paste.

How to Insert a Line in Word via Paragraph Tool

Word includes a built-in horizontal line feature to easily add lines. It quickly inserts a horizontal line in the document. Take a look at how to insert horizontal line in word:

  1. Keep the cursor where you want to insert it. Now, open the Home tab and in the Paragraph group, you will see a small square box and along with it a drop-down button. Click it.
  2. Select the option Horizontal Line and a line will be inserted in the Word document.
  3. Once a horizontal line is created, double- click on the line to select it. Format Horizontal Line dialog box will appear, where further adjustments related to height and width can be made and even color to the line can be added.
  4. In fact not only a Horizontal line, but you can also even add inside and outside horizontal and vertical borders via the same option.

Note- To remove or delete the horizontal line, just click it once and it will be selected. Now, simply press either the Delete or Backspace key.

Inserting Lines via Auto-Format

The best and the most convenient method to insert lines in Word file is by using the AutoFormat function. These are basically small tricks using which you can easily insert lines in your Word document. However, this trick works only on MS Word and MS Outlook.

When you type at least three dashes, underscores, or equal signs in a paragraph and press “Enter”, automatically a single, double horizontal line or a dotted line is formed, i.e. just by typing these characters and pressing Enter, the desired line will be formed.

Take a look at various such characters used to insert line in word:

  1. First of all, place the cursor where you want to add a line. Now, here enter any of the characters accordingly, and Press Enter. The line inserted will cover the full width of the page.
  2. Type three hyphens together (—) to form a single Horizontal line.
  3. Type three equal signs (===) to form a double horizontal line.
  4. Type three asterisks (***) to form a dotted line. (…..)
  5. Type three underlines (___) together, to form a broader and darker horizontal line.
  6. Type three tildes together (~~~) to form a tilted design line.
  7. Type three-pound or number signs (###) together, to form a bunch of broad and sleek horizontal lines.

Note- In case you add this line to the column, the line will cover the full width of the column.

Adding Lines between Columns

It is obvious that while writing any document, you display text in columns, instead of standard paragraphs. In case you want to add or draw vertical lines between columns, you can easily do it Word. Some people may prefer doing it via a Shapes tool, but there is a much easier way to do this.

Take a look at how to make a line in word columns:

  1. Place your mouse cursor on the text that you want to be displayed in columns.
  2. Choose Page Layout ribbon tab and select Columns. At the bottom of the list, choose More Columns.
  3. In the Columns dialog box, you can see an option called Line between. Tick mark the checkbox next to it.
  4. You can even adjust the column width and spacing between these columns via this box.  You can specify the number of columns you want to use from the number of columns list.
  5. In the Apply To box, click the drop-down arrow and select This Point Forward. By doing so, the column will be inserted only where you have placed the cursor, and not in the entire document. Click OK.

Your text will be now displayed in columns with a line between each one.  Adding a vertical line between columns in Word is easier and can be done by the above-stated method, easily.

Conclusion

Considering spacing via lines is usual while designing or formatting a document.  It adds appeal to your document and makes it easier for your audience to read. Moreover, adding lines is really useful if you preparing a questionnaire, i.e. to be filled by the audience.

So, go ahead with the methods stated in How to Insert a Line in Word and pick any one method that appeals to you to add lines to the Word document easily.

Continue Reading

Microsoft Office

How to Show Formulas in Excel Function?

Published

on

Mastering Excel skills have their advantages. You can easily organize your numerical data easily. Also, you can easily manipulate the data.

Formulas are used to simplify our calculations. We all make use of Excel formulas. So, there might be a case that you wanted to know how to show formulas in excel.

If that’s the case, then this article is probably the best place you’ve landed in your recent times.


You will get to know how to show excel formulas in easy and straightforward steps.

So, let’s get started:

How to Show Formulas in Excel?

One of the easiest methods to show all the formulas used in an Excel sheet is to use a simple Shortcut key.

The shortcut key is Ctrl + ` (Grave accent Key, which precedes one on the keyboard).
By making use of this shortcut key, you will easily get to see all the formulas used in an excel sheet.

One alternative method to display formulas in Excel is to make use of the Show Formulas option.
To do this, you will have to follow the following steps:

Step #1:

Open the Excel sheet of which you want to show excel spreadsheet formulas. To do this, you will have to locate the Excel file and double click on it. This will open the document in Excel.

Once you are done with this, then you are good to go to the next steps.

Step #2:

Now, you need to navigate to the “Formulas” tab on the top navigation bar. Once you have found it, then you need to click on it.


Now, from the tab, you have to locate the “Show Formulas” button. The moment you have found it, you are required to click on it, and this will show formulas in excel.

One point to take a note of that is even if the formula is not being displayed to you initially but whenever you select a column, you will get to see the method associated with it at the formula bar.

So, if you want to display formulas in Excel then you can consider selecting that particular column and the rest will be done by Excel itself.

How to hide formulas in Excel?

Since you were curious to know how to show formulas in excel, we thought that you might be interested in knowing how to hide formulas in excel? So, for that purpose, we bring you here in this section. This will equip you with the knowledge of the counterpart of how to display formulas in excel?

So, let’s get started:

Step #1:

First, open the desired document in which you want to perform the operation you want.

After this, you are required to select those columns of which you want to hide the formulas.

Step #2:

Now, you need heading toward the home tab. From the home tab, go for the Cells section and from there, you need to click on “Format”. This will open a drop-down menu for you from which you need to select “Format Cells”.

Once you are done with this, then you are all set to head towards the next step.

Step #3: 

The Previous activity of yours will result in a dialog box. From that Format Cells dialog box, you need to check the checkbox beside “Hidden.” After doing that, you now only need to hit the OK button.

Step #4:

To hide all the formulas, you will have to protect the spreadsheet. This requires minimal effort. All that you need doing is to follow a few more steps as specified.

Once again, you will have to follow the route of the first home tab and then the Format option. But this time, instead of selecting format cells, you have to select “Protect Sheet”.

Step #5:

On the dialog box which appears after executing Step #4, make sure to check the checkbox against “Select Locked Cells” and “Select Unlocked Cells.”

Also, you will have to enter a password, just in case if you wish to unprotect the sheet sometime in the future.

Additionally, if you want to grant access to any other user corresponding to the options specified, then you can certainly do that.

Once you are done with all the stuff, then it’s the time to hit the OK button.

After this, you will be prompted to enter the password again. This is to confirm your action. Just do whatever is required and hit the OK button.

Now, you will see the difference in your excel sheet. If you had executed the steps well, then you cannot see the formulas from now onwards.

However, you can unprotect and display the formulas as and when required by making use of the password.

[Additional Information]: How to type formulas in Excel?


Just in case, you might be interested in knowing how to type formulas in excel? If it is a yes from your side, then this section has something worthy for you. So, here we go:

Step #1:

The steps start with selecting the cell on which you want to enter the formula.

Step #2:

Now, you need to enter an equals to sign (=) either at the formula bar or in the cell itself.

Step #3:

After this, you will have to enter an open parenthesis. According to your formula function, you might need to enter several other parentheses. So, if necessary do whatever is needful.

Step #4:

Now, all that you need to accomplish in this move is to create a cell reference. Just do the mentioned and proceed for the next steps.

Step #5:

Just type in the formula as structured by you and once you are done with it then all that you need to finalize the process is to hit enter. One key thing to take note is that do not ever forget to type the closing parenthesis after entering the formula.

This way you can quickly type an excel function formula and execute it.

So, this was all about how to show formulas in excel?
We hope that this article surely has added good value to your knowledge base.

Do share if you liked it and thank you for giving it a read.

Continue Reading

Microsoft Office

How to Alphabetize in Excel?

Published

on

By

Microsoft Office is one of the widely used (if not the popular) office suite available today. And, Excel is their spreadsheet software we get along with other tools in the MS Office package.

I hope you know there are some formulas and shortcuts available in Excel using which, you can make the tabulation effortless.

Today, I am going to walk you through some methods to alphabetize in Excel. Trust me; you will thank me later for this!

How to Alphabetize in Excel?

Before getting deep into the core of this post, you must know what the term ‘alphabetization’ in Excel means.

What is Alphabetization in Excel?

Have you heard of sorting? Alphabetization is more of a type of sorting in Excel. Here, you will sort available data in alphabetical (A to Z) or reverse-alphabetical (Z to A) order. If you have a lot of numbers to present, you should present that data in Charts. Here is how you can create charts in Excel.

That’s all. I hope you know what alphabetization means now.

Uses of Alphabetization

#1. Alphabetization makes the data in a spreadsheet more sensible and easy to search for a particular item.

#2. After alphabetization, the duplicate data can be identified without sweating.

How to Alphabetize in Excel?

Now we are here, in the central section of this post. You are going to learn how the alphabetization can be done in Excel.

Method 1: Quick Alphabetization with Buttons

Follow the steps given below to sort columns in Excel.

Step 1: Open the Excel file you want to sort or alphabetize. You can either double-click on the file or use the open option within Excel. If you go with the latter, you should browse the file in which the alphabetization of data is needed.

Step 2: As we are using Excel sort by column, you have to select the column containing the data for alphabetization. The selection of an entire column is done easily by a single click on the letter label (A, B, C, etc. ) of the column.

How-to-alphabetize-in-excel

Step 3: Now, you must look at the ribbon-like menu with a set of buttons. There, you can see a button with a funnel, A and Z with name Sort and Filter. Click on to see a new menu with a bunch of new options.

excel-sort-by-column

Step 4: You will see four options there; Sort A to Z, Sort Z to A, Custom Sor, and Filter. The first choice is for proper alphabetical order and the second for reverse alphabetical order. The third, Custom Sort needs you to make a few setups.

As we are quickly sorting data here, you need to choose either A to Z or Z to A. If you have something really confidential, it is always a good idea to hide the columns in excel.

Now you can see that all the data are sorted. Though I explained the process in four steps, you

Method 1: Using Custom Sort

Here, you will have to do a few steps more as compared to the previous method.

Step 1: You have to make the necessary selections first. I recommend selecting the entire table so that, sorting based on site headers will be easier.

Step 2: Click on the Sort& Filter button. (If you don’t find the ribbon-like bar with the buttons, consider reading the next section).

Step 3: The third option just above Filter (Custom Sort) is the one we need here. So click on Custom Sort option.

Also Read:- How to Hide Columns in Excel?

Step 4: Now, you will see a new dialogue box (check the image down below to get an idea of it). Under column, you can spot a Sort by option. In order to sort columns in Excel, you must adjust the option.

sort-columns-in-excel

Clicking on the drop-down menu just right to the Sort by option reveals the column headers. That particular option determines on the basis of which column; the data should be sorted or alphabetized.

So, you should choose one column header.

Step 5: If your Excel sheet lacks headers, uncheck ‘My data has headers’. Don’t miss this step because Excel will not sort the first row if you uncheck this one.

Step 6: By default, the selection under Sort on the option is Value. If you find anything else, don’t forget to change the same to Value.

Step 7: Next option is Order. As you are going to alphabetize data in Excel, you don’t need a lot of orders but two; A to Z and Z to A.

Clicking on the Order drop-down menu gives you both the alphabetization options. Choose one that suits you the best.

Step 7: Finally, hit the OK button to finish the process.

What if You Don't Find Sort& Filter Button in Excel?

The situations are rare when you can’t find Sort& Filter button. If you are in such a situation, check the Data tab. There, you can find alphabetization and custom sort buttons separately.

sorting-in-excel

If the above solution doesn’t rescue you, go to View tab and click on Menu bars. There, you can find some checkboxes. Enable Standard from the menu bar options.

Method 3: Using Shortcuts

I know you are familiar with computer shortcuts, aren’t you? Shortcuts are time savers for those who use it efficiently.

Three keyboard shortcuts are available which can assist you in sorting Excel data within no time.

Alt+ H, S, S – For alphabetical sorting

Alt+ H, S, O – For reverse-alphabetical sorting

Alt+ D, S – To open Custom Sort dialogue box

N.B. – Don’t forget to select the necessary columns before hitting the shortcut keys. In earlier versions of Office, A to Z and Z to A quick sorting only arrange the selected columns. So, you must select the entire table in order to sort all the cells.

Also Read:- How to Create a Pie Chart in Excel?

Wrapping Up

Don’t you know how to alphabetize in Excel? I have explained three different methods for sorting.

In addition to all the above methods to sort columns in Excel, you can make use of VLOOKUP and COUNTIF statements as well. Also, learn to create bar graphs in excel.

We already have a VLOOKUP Excel tutorial here on ExpertHoot. You should check out the same for basic information.

If you face any difficulty in sorting data, don’t forget to let us know using the comment section down below.

And, have a second to hit one of the share buttons to help your needy social media friends.

Continue Reading

Trending