![]() ![]() To ungroup specific columns, select those columns, and then click the Ungroup button on the Data tab or press the Shift + Alt + Left Arrow key combination.To ungroup all the columns at any existing levels, go to the Data tab > Outline group, click the arrow under Ungroup, and then click Clear Outline.To remove grouping, do one of the following: To unhide the columns, click on either the minus (-) sign or the outline number 2: In the screenshot above, clicking on 1 will conceal all the columns between A and G, so that only these two columns are visible. To hide the columns, click on the minus (-) sign above the group.Īlternatively, you can collapse and expand groups by using the outline numbers in the upper-left corner. Obviously, you choose Columns and click OK.Īs an example, we are going to group columns B through I that contain item details and monthly sales figures:Īs we've selected the whole columns, clicking the Group button immediately creates the grouping, and the outline symbol appears at the top of the worksheet. If you didn't select entire columns, the Group dialog box will pop up, asking you to select Rows or Columns.On the Data tab, in the Outline group, click Group (or press the Shift + Alt + Right Arrow keys together).Select all the columns you want to group, or at least one cell in each column.To group columns in Excel, this is what you need to do: If your worksheet contains a lot of columns, it may be handy organize them in groups to easily show and hide different sections of the sheet. Hide and expand columns using the Group feature Done!Īs the result, the workspace is cleaned up and only the relevant information is displayed to the users: Press the Ctrl + 0 key combination to hide the selected columns.Press Ctrl + Shift + Right Arrow to highlight all the unused columns to the end of the sheet.Select the column to the right of the last column with data.To make only the working area of your sheet visible, you can hide all unused (blank) columns to the right of your data. To hide other columns, change the column letters in the codes.All the codes hide column(s) on the currently open worksheet.To indicate that the entire column should be hidden, the corresponding properties ( EntireColumn and Hidden) are added: To specify the column, we use the Range object. To hide a single column, say column C, the codes are: To do "concealing" programmatically, you can use either the Range or Columns property. In fact, it's a very simple operation, and we'll try to explain the whole concept here. Like many other things, hiding columns in Excel can be automated with VBA. On the Home tab, in the Cells group, click Format > Hide & Unhide > Hide Columns.ĭone! The information that you don't want to view or print is hidden.Select the column or any cell within the column(s) you want to hide.To hide unwanted columns by clicking a ribbon button, the steps are: How to hide a column in Excel using the ribbonĪs its name suggests, this option is tucked away deep in the menus, so you need to know where to look for it :) Voila! Now you can easily review your data skipping the extra details. ![]() Right-click the selection and pick the Hide option from the menu.Select one or several columns to be hidden.How to hide columns using a context menuĭon't want to bother remembering the hotkeys? Here's another amazingly simple way to hide columns in Excel: In this case, use another method of unhiding columns in Excel. The bad news is that this key combination does not work in some versions of Windows for unknown reasons. To make the hidden columns visible, highlight at least one cell in the columns on both sides of the hidden one(s), and use the shortcut. ![]() The shortcut for unhiding columns in Excel is Ctrl + Shift + 0. To hide non-adjacent columns, click on the header of the first column, press and hold the Ctrl key while clicking on each additional column to select them, and then use the hiding shortcut.To hide multiple columns, select one or more cells in each column, and then press the key combination.To hide a single column, select any cell within it, then use the shortcut.The shortcut for hiding columns in Excel is Ctrl + 0.įor the sake of clarity, the last key is zero, not the uppercase letter "O". ![]() See how to lock cells and protect sheets.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |