![]() ![]() 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.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. Sometimes you will have data in a spreadsheet that you don’t need to display, but you don’t want to delete.
0 Comments
Leave a Reply. |