You can earn a commission for sales leads that you send to us by joining our Any affiliate commissions that weĮarn when you click a link to Amazon or other sites is reinvested in keeping Web site are provided "as is" and we do not guarantee that they can be used in all The Formulas, Functions and Visual Basic procedures on this provides examples of Formulas, Functions and Visual Basic proceduresįor illustration only, without warranty either expressed or implied, includingīut not limited to the implied warranties of merchantability and/or fitness forĪ particular purpose. SpecialCells(xlCellTypeFormulas, 2).EntireRow.Hidden = TrueĬolumns("F:F").EntireColumn.Hidden = True With Intersect(ActiveSheet.UsedRange, Range("E:E")).Offset(0, 1) If you wish, you can also "tidy up" the macro so that it reads as follows :. This selects the appropriate cells in column F. Intersect(ActiveSheet.UsedRange, Range("E:E")).Offset(0, 1).Select In order to avoid having to select ANY cells before running the macro, add the following line at the start of the macro :. Delete this line - before running the macro, you will first need to select the appropriate cells in column F. In the macro the first line will read :- Range("F1:F10").Select. You can record a macro for the above with the macro recorder.
Click OK.ħ.Select column F and unhide the hidden rows. Just choose the one that will work best for you.1.Let's say your data covers columns A:E and the last row is row 10.Ģ.In any blank column(let's say col F), select F1:F10 and type the formula :-ģ.With F1:F10 still selected, go to Edit>GoTo>Special>Formulas and check the Text box only. You see there are different ways to show and hide gridlines in Excel.
If you're interested in this method, feel free to find out how to change the default gridline color in Excel. If you change the default gridline color into white, gridlines will disappear in the whole worksheet. There is one more way to make Excel hide gridlines. Note: To bring gridlines back to the block of cells, choose Noneunder Presets in the Format Cells dialog window. Start with opening the worksheet where cell lines are invisible. In this case you need to check one of the following options in the Excel 2016 - 2010 Ribbon. Suppose you want to see gridlines in the entire worksheet or workbook, but they are just turned off.
In this case you may want them to become visible again. And you don't need to draw cell borders to make your data-table more readable.Īll Excel spreadsheets have gridlines by default, but sometimes you can receive a sheet without cell lines from another person. It is very convenient to show gridlines in Excel spreadsheets as the key idea of the application is to organize the data in rows and columns. When you open an Excel document, you can see the horizontal and vertical faint lines that divide the worksheet into cells. In this article you'll learn how to show gridlines in an entire worksheet or in certain cells only, and how to hide lines by changing cells background or borders' color. Today I'd like to dwell on another issue related to Excel grid lines. In the previous blog post we successfully solved the problem of Excel not printing gridlines.