The benefit of hiding columns in Excel is that you (or anyone else viewing the spreadsheet) can’t see them. What is the Benefit of Hiding Columns in Excel 2010? This includes anyone that is collaborating on a spreadsheet with other people, or anyone that has a column of data with information that is important to a formula and they don’t want that data to be changed. Who Should Hide Columns in Excel 2010?Īnyone that has a spreadsheet with either a lot of columns, or columns that they don’t want to be easily seen or edited can benefit from hiding columns in Excel. If you are working with a spreadsheet that contains a lot of hidden columns, and you want to unhide every column in that worksheet, then you can click the gray button above row 1 and to the left of column A, then right click on a selected column and choose the Unhide option. You can unhide a column by selecting the two columns surrounding the column (for example, if you hid column B, you would select columns A and C), right-clicking one of the selected columns, then clicking the Unhide option. Simply right-click the row heading at the left side of the window, then click the Hide option. Note that this method will also work on rows that you want to hide. If the multiple columns you want to hide are not contiguous, then you can hold down the Ctrl key on your keyboard and click each individual column that you want to hide, then right-click one of the selected columns and click Hide. Note that you can simultaneously hide multiple contiguous columns by clicking the leftmost column heading, then dragging your mouse to select the rest of the columns you want to hide. Step 2: Click the column heading at the top of the spreadsheet to select the entire column. Step 1: Open the spreadsheet in Microsoft Excel 2010 that contains the column(s) of data that you want to hide. I have also found the ability to hide columns in Excel 2010 to be very beneficial when I am printing out my spreadsheets and I can exclude certain irrelevant columns of data from the printed copy. Even though the column is hidden, the old expression “out of sight, out of mind” comes into play here, and there is a chance that you will forget that data exists. The procedure outlined below is best used on columns that contain data that you know you will either not be using, or will not need to change. Hiding Columns in Excel 2010 (Guide with Pictures) Our article continues below with additional information on hiding spreadsheet columns in Microsoft Excel 2010, including pictures of these steps. Right-click the selected column and choose Hide.Select the column heading of the column to hide.Open the spreadsheet with the columns to hide.
How to unhide a column in excel 2013 how to#
So even if you have a formula that references a cell that is now hidden, the formula cell will still be showing the correct value.ġ0 See also How to Hide a Column (or Columns) in Excel 2010
This is a very helpful method for optimizing the viewing screen in Excel 2010, and it does so without deleting any of your data.Īll of the columns retain their original lettering, just not all of them can be seen. When you get frustrated with scrolling right and left to keep finding the column of data that you need, you will inevitably wonder how to hide columns in Excel 2010. Most of the trouble lies in the size of the screen on which you are viewing the spreadsheet and the amount of data that you can see at once. This is not a fault of Microsoft Excel, however. But if you haven’t had to hide something before, especially a lot of data, then you may be wondering how to hide a column in Excel.ĭealing with large amounts of data in Microsoft Excel 2010 can be a bit of a headache. This is the perfect situation for using the “hide” feature in Microsoft Excel, which will keep the data in the sheet, but remove it from view.
:max_bytes(150000):strip_icc()/UnhideColumnsDialogBox-5c1955edc9e77c0001995574.jpg "how to unhide a column in excel 2013")
Step6: close the current Visual Basic Editor window, and you can try to select TRUE or FALSE item from the drop down list box, and you should see that the column B or Column C is hidden or unhidden.Sometimes you will have data in a spreadsheet that you don’t need to display, but you don’t want to delete. Note: the $A1$2 is the Cell Reference of the drop down list in your worksheet. Private Sub Worksheet_Change(ByVal Target As Range)
How to unhide a column in excel 2013 code#
Step5: paste the below VBA code into the code window. Step4: Double click on the current sheet name in the VBAProject section to open the code window. Step3: then the “ Visual Basic Editor” window will appear. Step2: open your excel workbook and then click on “ Visual Basic” command under DEVELOPER Tab, or just press “ ALT+F11” shortcut. (just go to DATA tab, click Data Validation command, then you create a drop-down list in Cell A2) Step1: you need to create you drop-down list with TRUE and FALSE items in Cell A2.
0 kommentar(er)
