There may be hidden columns in different places.Ģ. Go to ‘ Unhide’ option and click it to unhide the hidden columns.ġ. In the example we have selected column E to I.Ģ.Then right click on the title cells of the selected columns to get the list of options.ģ. Not necessary to select the immediate left or right columns. Identify the hidden column/s and select the from a left column to right beyond the hidden column/s. Unhide other single or multiple column/sġ. This method can also be used to unhide any single column. Then go to ‘ Visibility’ > ‘ Hide & Unhide’ > ‘ Unhide Column’Ĥ. Then go to ‘ Home’ tab > ‘Format’ button to get the dropdown menu.ģ. Type ‘ A1’ in the ‘ Name Box’ and press Enter Key to select the first hidden column.Ģ. When it comes to unhide the columns, there are a few ways to do it as explained below.ġ. The hidden columns can be identified because the numbers are skipped and a double line will be displayed when the cursor is on the place of the hidden columns. When you have some data columnsthat you don’t want to display can be hidden from the sheet.
0 Comments
Leave a Reply. |