The steps 1 and 2 are shown in the following image.
Step 2: Once the columns to be hidden (columns B and C) are selected, press the keys “Ctrl+zero (0)” together. Next, press the keys “Shift+right arrow” to select column C. Note: Alternatively, select any cell of column B and press the keys “Ctrl+space” together. When the mouse pointer is placed on the label of column B, it changes to an arrow pointing downwards. For this, click the label of column B with the mouse and drag it across to column C. Step 1: Select columns B and C, which need to be hidden. The steps to hide the stated columns using the given technique are listed as follows: We want to hide columns B and C by using the shortcut “Ctrl+zero (0)” in Excel. These are displayed because the “ignore error” option from the “trace error” button has not been clicked, unlike in step 1 of the preceding example (example #1). Ignore the green triangles in column A of the subsequent images.
#How to hide columns in excel 2016 full
Columns A to D are displayed, which consist of the employee ID, first name, last name, and full name respectively. Notice that the number of columns has been reduced this time. The following image shows a dataset similar to that of example #1.
After label A, labels B and C are skipped, and straightaway label D is displayed.Įxample #2–Hide Excel Columns Using the “Ctrl+Zero (0)” Shortcut These lines indicate that columns B and C have been hidden.Īnother indication of hidden excel columns is the change in the sequence of the column labels. Notice that there are double vertical lines (shown in a red box) between the column labels A and D. The final dataset, with columns B and C hidden, is shown in the following image.The same is shown in the following image. Right-click the selection and choose “hide” from the context menu.From the “trace error” button, we clicked “ignore error” (for each cell) to remove such green triangles. Note 2: When the numbers of column A were formatted as text, green triangles (shown in the first image of example #2) had appeared on the upper-left corner of each cell. When the shortcut “Shift+right arrow” is pressed after selecting a cell, the selection is extended to an adjacent cell on the right. When the shortcut “Shift+right arrow” is pressed after selecting a column, the selection is extended to an adjacent column on the right. Note 1: For “Shift+right arrow” to work, hold the “Shift” key, and at the same time, press the right arrow. This has been done to place zeros before each number in cells A2 to A9. Notice that in column A, the numbers have been formatted as text. The selection is shown in the succeeding image. Next, press the keys “Shift+right arrow” to select the entire column C. With the help of the mouse, click the label of column B appearing on top.The steps to hide excel columns is listed as follows: So, the dataset begins from column A (emp ID) and ends with column G (department). Consider one column of the table as one column of an Excel worksheet. The following table displays the IDs, names, gender, age, and department of some employees of an organization. Example #1–Hide Columns Using the “Hide” Option of the Context Menu For hiding multiple non-adjacent columns, refer to the second question under the heading “frequently asked questions.” This is given at the end of this article. Note: All the following examples demonstrate the process of hiding adjacent (contiguous) columns.
Let us discuss these methods one by one with the help of examples. The techniques of hiding columns in Excel are listed as follows:
#How to hide columns in excel 2016 how to
How to Hide Columns in Excel? (Top 4 Methods) The purpose of hiding an excel column is to allow viewing the relevant areas of a worksheet at a given time. This helps avoid confusion amongst users of a shared worksheet.Ī column is hidden when its data needs to be concealed from other Excel users, it is unused and not required for a while, its presence is making comparisons between the remaining columns difficult, and so on. However, to use a hidden column again, it needs to be unhidden at first.įor example, a column containing calculations may be hidden. In Excel, one can hide both contiguous and non-contiguous columns. This means that it does exist and has been only temporarily held from view. A hidden column is not deleted from the worksheet. Hiding a column in excel implies making it invisible so that it is removed from display.
0 kommentar(er)
