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 MS EXCEL function, it transposes the parameter given to it. For instance, if a horizontal range is given as 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 want 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 “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 that 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 it 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 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, the 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 Insert a Line in Word?
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:
- Open the MS office word file in which you want to insert the line.
- Navigate to the Insert tab. Click on the option Shapes and select the line shape.
- 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.
- 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:
- 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.
- Select the option Horizontal Line and a line will be inserted in the Word document.
- 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.
- 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:
- 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.
- Type three hyphens together (—) to form a single Horizontal line.
- Type three equal signs (===) to form a double horizontal line.
- Type three asterisks (***) to form a dotted line. (…..)
- Type three underlines (___) together, to form a broader and darker horizontal line.
- Type three tildes together (~~~) to form a tilted design line.
- 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:
- Place your mouse cursor on the text that you want to be displayed in columns.
- Choose Page Layout ribbon tab and select Columns. At the bottom of the list, choose More Columns.
- In the Columns dialog box, you can see an option called Line between. Tick mark the checkbox next to it.
- 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.
- 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.
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.
How to Show Formulas in Excel Function?
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:
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.
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:
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.
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.
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.
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”.
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:
The steps start with selecting the cell on which you want to enter the formula.
Now, you need to enter an equals to sign (=) either at the formula bar or in the cell itself.
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.
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.
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.
How to Alphabetize in Excel?
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.
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.
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.
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.
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?
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.
How to Unhide Columns in Excel?
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:
- First of all select one column on either side of the hidden column.
- Now, just right-click on the column header, with all these columns selected.
- A popup menu appears on the screen
- 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 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:
|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:
- 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.
- Click Region and Language within the Control Panel.
- Choose the Keyboards and Languages tab.
- Then click Change Keyboards.
- Click the Advanced Key Settings tab, and then click Change Key Sequence.
- Select Not Assigned in the Switch Keyboard Layout section
- 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:
- Navigate to the location in your table where the columns are hidden.
- Now, select the columns to the left and right of the column you want to unhide.
- Let’s say, if you want to display column B, select columns A and C.
- Go to the Home tab in Excel.
- Click on the Format icon -> Hide & Unhide -> Unhide columns.
- 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:
- Go to Home -> Find & Select -> Go To
- You will see the Go To dialog box. Enter C1 in the Reference field.
- Click OK.
- Although it won’t be visible to you, cell C1 will be selected.
- Now, go to Home -> Format -> Hide & Unhide -> Unhide Columns.
- 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
- Press Alt+F11 to open VBA Editor
- Insert a Module for Insert Menu
- Copy the above code and Paste in the code window
- Save the file as macro enabled workbook
- 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:
- In order to select the entire table, click on the Select All button, which is at the intersection of row numbers and column letters.
- Right-click on the highlighted list and pick the Format Cells.
- On the Format Cells window, go to the Protection tab.
- Now, unselect the Locked checkbox.
- Click OK to save the changes.
- Now select the columns you want to protect from being unhidden.
- Click on one of the highlighted columns and select the “Format Cells” option again.
- When you see the Format Cells window, go to the Protection tab and tick the Locked checkbox.
- Hide the columns: select them and right-click above one of the columns and pick the Hide option from the menu.
- 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.
- And the Unhide option is disabled.
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.
How to Hide Columns in Excel?
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.
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.
- 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.
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.
Once the selection is done, simply right click on the column and click on Hide. That's it.
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.
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.
Tech1 year ago
How to Receive Money through PayPal?
Tutorials1 year ago
How To Find New Movies On Netflix
Tech1 year ago
How to Make a Yahoo Account Without a Phone Number?
Tutorials1 year ago
How To Enable/Disable Chrome Pop Up Blocker
Mac1 year ago
How to Install GIMP for Mac
Tech1 year ago
How to Tame a Horse in Minecraft?
Mac1 year ago
How to Use Apple Thunderbolt Display with PC?
Computers1 year ago
How to Reset Macbook Air?