Hiding a column allows you to leave data in a spreadsheet, while simultaneously making it more difficult to view or accidentally edit it.
That may have been valid, even self-obvious, many years ago, but is not the case these days.Learning how to unhide columns in Excel is important for anyone that has data in their spreadsheet that they might need to hide from their audience. It does seem a poor design, based on the core assumption that the primary purpose of Excel is to manage financial (or numerical) data. I have populated the "summary" column with data from two of them: "Gender | Age". For example, one of my groups is "Patient data", which contains a bunch of details about each individual. I get around the annoyance of empty columns by finding something useful to put into them. That's what shows when the groups are collapsed. Oh, and if you want to see titles or labels for the groups, put them in the header row at the top of the blank columns. In some ways, this is a bit pointless: when the group is collapsed, all you see is an empty column! And if you subsequently delete the empty column, Excel simply joins the two groups (either side of deleted column) back together. Without that, the only way I can get it to work is to add a blank column at the end of each group (including the last group, if you are working with a table), then select all the columns in the desired group (including the blank column), then group. It works fine for me if the last column in each group is some sort of subtotal column (for example, it SUMS the columns in the group). 3 ways to remove spaces between words in Excel cells.Create calendar in Excel (drop-down and printable).CONCATENATE in Excel: combine text strings, cells and columns.How to merge two or more tables in Excel.Compare 2 columns in Excel for matches and differences.How to insert a hyperlink to another worksheet.Helpful Insert Row shortcuts to use in Excel.How to insert a tick symbol (checkmark) in Excel.
Be happy and excel in Excel! You may also be interested in Hope you found the tips helpful and they will simplify your daily work with tables. You also know how to group and ungroup columns to show or hide them. You learnt how to use the Excel Hide columns option. This is especially useful if you created a hierarchy of grouping.
For example, in my table on the screenshot, clicking on 1 will hide the entire table and clicking 2 will hide columns C and E. They let you hide and unhide all groupings of the same level at once. You can also use the small numbers in the top left corner.
Clicking on the minus icon will hide the column and the icon will change to the plus sign letting you to instantly unhide the data.It's not possible to select several non-adjacent columns.Īs soon as you press the hotkey, you will see the minus sign icon added to the outline above your selected columns. Open your worksheet and select one or several columns you want to hide.If you want to hide one or several columns in your table, you can easily deal with this task Use the Group option to hide and show columns in a click.In this article you'll also find an interesting way to hide columns via the Group option which adds special icons to quickly conceal and display certain columns. Read on to see how Excel enables you to hide columns in an instant.
You can learn how to protect your columns from being displayed if you have a look at Disable the Unhide column option in Excel.