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 which 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 at 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 most general case, the font will be downloaded in zip 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 the 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 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.

A student of life, writer, technology freak, and a thinker.

Continue Reading
Click to comment

Leave a Reply

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

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

Microsoft Office

How to Unhide Columns in Excel?

Published

on

Microsoft Excel has been gaining popularity and is pervasive in almost every business today. It is a perfect tool for business analytics. If sources are to be believed, then 98% of the organizations use it daily for applications ranging from petty cash reconciliations to more complicated aspects of preparing management reports and budgets.

Microsoft Excel is, basically, equipped with so many fundamental and advanced features that most of the people, barely know from where to start. One such feature is How to Add columns in excel. But you are here to unhide a column in excel. So here it is:

Hide and Unhide Columns

Most of the people have reported that they experience a lot of complications when it comes to unhide columns in excel. In order to avoid unnecessary confusions, it is better to hide these columns. But sometimes, these columns need to be viewed.

Let’s have a look at the process of how to unhide all columns in excel:

  1. First of all select one column on either side of the hidden column.
  2. Now, just right-click on the column header, with all these columns selected.
  3. A popup menu appears on the screen
  4. Select the ‘unhide’ option and the hidden columns will be visible.

This is by far, the easiest way via excel unhide all the columns.

How-to-unhide-columns-in-excel

How to Unhide Columns in Excel Using the Shortcut Way

There are certain shortcut keys imbibed in your spreadsheets for hiding rows and columns. Let’s have a look at some of them:

Shortcut Key Details
Shift+ Space It is used to select an entire row.
CTRL+9 Hide the selected rows.
CTRL+0 Hide the selected columns.
Ctrl+ Space It is used to select an entire column.
Ctrl+ Shift+= (equal sign) It is used to insert rows or columns.
CTRL+SHIFT+9 Unhide the hidden rows within the selection.
CTRL+SHIFT+0 Unhide the hidden columns within the selection
ALT, O, R, E It opens the Row Height window.
Alt,O,C,W It opens the Column Width window.

 

These keyboard shortcuts are, basically, used while working with rows and columns in Excel. All these shortcuts are not only convenient but even helps to save a lot of time. There are tons of shortcuts available to make your task easier.

However, in order to make these shortcut functions, you need to make some changes in the settings. Follow the following steps for the different version of windows:

Windows 8

  • Click on Language within the Control Panel.
  • Click Advanced Settings, and then click the Change Language Bar Hot Keys link.
  • Click Change Key Sequence
  • Under ‘Switch Keyboard Layout’, set the radio button to Not Assigned
  • Click the ‘Ok’ button and now the unhide column shortcut key will start working in Excel.

Windows 7

  • Click Region and Language within the Control Panel.
  • Choose the Keyboards and Languages tab.
    How-to-unhide-columns-in-excel
  • Then click Change Keyboards.
     unhide-columns-in-excel
  • Click the Advanced Key Settings tab, and then click Change Key Sequence.
     unhide-columns-in-excel
  • Select Not Assigned in the Switch Keyboard Layout section
    How-to-unhide-columns-in-excel
  • Click OK as needed.

Thus, in order to synchronize the keyboard shortcuts with the functionality of Microsoft Excel, you need to change the Keyboard Layout shortcut. As far as Windows XP is concerned, no Control Panel changes are necessary.

Unhide the columns selectively

If you have an Excel table where multiple columns are hidden and want to unhide a few of them only, just follow these steps:

  1. Navigate to the location in your table where the columns are hidden.
  2. Now, select the columns to the left and right of the column you want to unhide.
  3. Let’s say, if you want to display column B, select columns A and C.
  4. Go to the Home tab in Excel.
  5. Click on the Format icon -> Hide & Unhide -> Unhide columns.
  6. And you are done.

You can even carry out this process by using Go To and Format options. Let’s have a glance at how to do this via Go To option:

  1. Go to Home -> Find & Select -> Go To
    how-to-unhide-all-columns-in-excel
  2. You will see the Go To dialog box. Enter C1 in the Reference field.
     how-to-unhide-all-columns-in-excel
  3. Click OK.
  4. Although it won’t be visible to you, cell C1 will be selected.
  5. Now, go to Home -> Format -> Hide & Unhide -> Unhide Columns.
    how-to-unhide-cells-in-excel
  6. And you are done.

Unhide Columns in Excel using a VBA Solution

It is actually difficult to hide entire columns of data based on the value of a particular cell. Now, in case you want to unhide your spreadsheet columns by using a code then you can use the following method for how to unhide cells in excel.

First of all, let’s see the code-

  • Sub Unhide_All Columns()
  • Cells.EntireColumn.Hidden = False
  • End Sub

Now, follow this process:

  • Open an excel workbook
    how-to-unhide-cells-in-excel
  • Press Alt+F11 to open VBA Editor
    unhide-rows-in-excel
  • Insert a Module for Insert Menu
    How-to-unhide-columns-in-excel
  • Copy the above code and Paste in the code window
    unhide-rows-in-excel
  • Save the file as macro enabled workbook
    unhide-rows-in-excel
  • Press F5 to run it.

In case, you also want this macro to unhide rows in excel as well then simply add a line:

ActiveSheet.Cells.EntireRow.Hidden = False  

There are some data in sheets which is important but not required to present. So, for that kind of data, can also hide columns in Excel.

How to Disable the Unhide Column Option

In case, the spreadsheet columns contain some confidential or important information, thus, in order to make sure that no one unhide the columns, use this process:

  1. In order to select the entire table, click on the  Select All button, which is at the intersection of row numbers and column letters.
    How-to-unhide-columns-in-excel
  2. Right-click on the highlighted list and pick the Format Cells.
    How-to-unhide-columns-in-excel
  3. On the Format Cells window, go to the Protection tab.
    How-to-unhide-columns-in-excel
  4. Now, unselect the Locked checkbox.
    How-to-unhide-columns-in-excel
  5. Click OK to save the changes.
  6. Now select the columns you want to protect from being unhidden.
    How-to-unhide-columns-in-excel
  7. Click on one of the highlighted columns and select the “Format Cells” option again.
    How-to-unhide-columns-in-excel
  8. When you see the Format Cells window, go to the Protection tab and tick the Locked checkbox.
  9. Hide the columns: select them and right-click above one of the columns and pick the Hide option from the menu.
    How-to-unhide-columns-in-excel
  10. Go to the Review tab and click on the Protect Sheet icon. Make sure that the checkboxes Select locked cells and Select unlocked cells are ticked. Do enter and re-enter the password.
    How-to-unhide-columns-in-excel
  11. And the Unhide option is disabled.

Conclusion

Excel comes with ample options to simplify the tasks. You can do a lot of calculative tasks within a seconds. You can find the average of big numbers in Excel within seconds. The possibility to hide columns in Excel is really helpful. Just follow these simple keystroke commands, listed above and the process of How to unhide columns in excel becomes a cake walk.

Continue Reading

Microsoft Office

How to Hide Columns in Excel?

Published

on

Lately, we have been providing tutorials on Microsoft Excel program. If you have been reading our articles, you must know that. So continuing the series, we have again come up with a fresh and interesting tutorial on excel that is How to hide columns in excel. Also learn, how to move columns in Excel.

Hiding and Unhiding cells in excel are just a few clicks steps. All you need to do is press a command. Yes, hiding data in excel don't take much efforts and time. If you have a little bit of knowledge in excel,  hiding cells in excel would not be at all a tough job for you.

There can be various reasons to hide columns and cells in excel sheet, for example, if you have some extra data worksheets that are the citation, but don’t require to be viewed. Or maybe you have a few rows or columns of data of the worksheet that need to be hidden or are not shareable.

How-to-hide-columns-in-excel

In such situations, guides such as how to hide cells in excel prove to be very handy. In today's guide, we will share the ways to hide columns in excel. Apart from that, we will also see some best shortcuts for rows and columns that can help you work done faster.

How to Hide Columns in Excel

Adding columns in Excel is pretty easy but to hide the confidential data may seem like a hard job. Hiding command in excel is just a few clicks steps as I said above. You can hide any cell at any time from the excel sheet. And the best part of hiding the cell is, it can be un-hided easily that too anytime you want.

Though, we are not going to cover the procedure of un-hiding in detail here. Instead, we will see all the possible ways to hide the rows in excel. The procedure of hiding the rows and columns is almost the same. If you want to hide the column then replace the word column with the row in this tutorial.

Since I am not going to cover the rows here. I will tell you the procedure of hiding columns. So what are you waiting for? Let's begin the guide and check out the ways to hide columns in excel programs.

Read out the complete guide till the end and learn to hide columns/rows in the excel program. First, we will see the traditional approach to hiding rows and columns. And here go the method.

#Method 1:

  • To hide a column in excel, first of all, select the column you want to hide. To select a single cell click the cell, or press the arrow keys to move to the cell. If you want to hide an entire row or column, right-click on the row or column header.
  • Ok, after you have decided and have selected the column, right-click on it and click on Hide. Check out the screenshot I have taken for you.

hide-columns-in-excel

After you hide the columns if you want to confirm if they are actually hidden or not, see the series of the letters or numbers at the head.

For example, if you have hidden the column ‘C' then you will see in the series, column C is missing. Plus the double lines between the column B and D indicates hidden columns or rows.

In case, you want to hide multi columns then you will have to select them together and click on Hide option to make them invisible from the sheet. To select the

To select the multi-columns, either select by dragging the mouse from the first cell to the one you want to select. Or, select the first cell and press the arrow keys to make the selection.

hide-columns-in-excel

Once the selection is done, simply right click on the column and click on Hide. That's it.

#Method 2:

Another way to hide a column in excel is by changing the row height or column width to 0 (zero). This is one of the easiest way to hide, column or rows. You can hide the columns by dragging them to previous or next column manually as well.

For example, if you want to hide the column D then select the D column and drag it to either column E of C. Check out the image mentioned below. In the image, if you notice I have selected the column D.

That's all! Just a few clicks and you are done. Isn't hiding columns in excel is very easy.

If you want to unhide the column then you will need to select the hidden columns and click on unhide.

For example, as I hidden the column D in the above method. Now to unhide the same I will have to select the sided column like column C and column E.

how-to-hide-cells-in-excel

After the selection, right click on the column and click on Unhide option and the hidden columns will go visible. You can see the complete guide to unhide the columns in Excel.

Now as you have learned How to hide columns in excel, let's check out some shortcuts for rows and columns that would help you while using excel. Below I am sharing some of the best excel shortcuts, hoping it will help you job done faster.

  • Shift+Space to select an entire row. Select any cell and press Shift+Space. And the entire row would be selected. And to select entire column press Ctrl+Space. 
  • To insert a new cell, row and column press Ctrl++ (plus character) from the keyboard. After pressing the key combination a small dialogue box will be opened up. Choose any of the required options from the list.
  • To delete a cell, row or column, press Ctrl+- (minus character)
  • To hide row and column, press Ctrl+9  and Ctrl+0 (zero) respectively. And to unhide the row and column press Ctrl+Shift+( and Ctrl+Shift+) respectively.

The shortcuts I shared are one of the most useful shortcuts in the excel program. So, how do you like the article? Do let us know in the comment section below. If you have any other methods to hide columns in excel then you can also share with us.

And if you have any suggestion or doubt don't hesitate to drop your comment in the comment section below.

Continue Reading

Microsoft Office

How to Double Space in Word?

Published

on

Microsoft Office Word is a widely used application for editing and writing documents. Documents serve its 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.
How-to-double-space-in-Word
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.

How-to-double-space-in-Word
How-to-double-space-in-Word
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.

How-to-double-space-in-Word

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.

Wrapping up.

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

Continue Reading

Microsoft Office

How to Strikethrough in Excel?

Published

on

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.

Wanted to represent numerical data in an attractive manner? Here is how to create charts in Excel. Along with that, you can also create the Bar graph in Excel.

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.

strikethrough-in-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.

strikethrough-in-excel

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.

how-to-do-a-strikethrough-in-excel

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.

how-to-remove-strikethrough-in-excel

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.

How-to-Cross-Words-Out-in-Excel

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. 

How-to-Cross-Words-Out-in-Excel

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.

how-to-put-line-through-text-in-excel

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.

how-to-put-line-through-text-in-excel

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.

how-to-put-line-through-text-in-excel

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.

how-to-put-line-through-text-in-excel

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.

Continue Reading

Trending