These columns then appear in the table on the screen and if you want to print the sheet out, they will also appear on the printed copy. Right-click, find the option Unhide which will make the hidden columns visible again. You can do it by selecting one column on the left- and one on the right-hand side of the column or columns you want to unhide. Here’s one of them! The First Way How to Unhide Columns in Excelįirst, you’ve got to select the columns you want to unhide. In this case, however, we see the column C right next to the column F, which means that the columns D and E have been hidden.Īnd it’s time to learn two simple ways how to unhide these columns. Normally, the letters would go A, B, C, D, and so on. Skipped letters of the alphabet is another sign how to recognise that some columns have been hidden. One way to find them is to look for ‘a double-line’ among the column headings. How to Spot the Hidden Columns in a Spreadsheet Generally, it’s quite easy to spot the hidden columns in a spreadsheet. In the previous tutorial, we learned how to hide columns in Excel. 5 How to Unhide All Columns in the Whole Spreadsheet
0 Comments
Leave a Reply. |