But this feature is only applicable when Scroll Lock in Excel is disabled. How to disable Scroll Lock in Excel : Arrow keys in excel that move sheet cell up, down, Left & Right. Set the fonts to wingdings and use the formula Char(252) to get the symbol of a check mark. How do I Insert a Checkmark in Excel 2016 : To insert a checkmark in Excel Cell we use the symbols in Excel. We need to delete or remove the Dropdown list as the user will be able to input any data instead of choosing from a list. How to Insert Row Shortcut in Excel : Use Ctrl + Shift + = to open the Insert dialog box where you can insert row, column or cells in Excel.ĭelete drop down list in Excel : The dropdown list is used to restrict the user to input data and gives the option to select from the list. We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. And also you can follow us on Twitter and Facebook.

If you liked our blogs, share it with your friends on Facebook. Find more articles on calculating values and related Excel formulas here. Hope this article about How to Unhide multiple columns at once in Excel is explanatory.

Filtering or manually, you can hide values in excel.

Selecting columns is crucial and necessary as both options only make those columns visible, within selected columns.

Here are all the observational notes using the formula in Excel Right click from mouse and select hide or unhide to make columns hide or unhide respectively.

You can use one other way to perform the above task using mouse right click. This will make hidden columns visible between the selected columns. Go to Home tab > Format > Hide & Unhide > Unhide Columns to unhide columns. Select the columns and follow further instruction below. Important part is choosing the columns where hidden columns exist. First is by using the Format option in excel. There are two ways you can hide or unhide cells in excel.

Here we learn where to find the hide & unhide columns option in excel via some snapshots. Let's understand how to use the function using an example. Right Click selected cells > Click Unhide to unhide columnsĪll of these might be confusing to understand. Go to Home tab > Format > Visibility (Hide & Unhide) > Unhide selected column Learn How to unhide columns in excelįirst and most important thing when you unhide columns, you need to select the columns where the hidden columns make visible. But for rows it's different, rows can be hidden by two ways, first is the obvious above mentioned reason for columns and other is filtered rows using Sort & Filter columns. Hiding columns is easy, just select the column and right click to hide. Sometimes we don't need to see the unrequired values in excel, so we hide the matching rows and columns. Rows and Columns combine to make a sheet in excel. In this article, we will learn How to Unhide multiple columns at once in Excel.

How to unhide a column in excel 2013