You can also use borders to change the color or thickness of lines around selected cells. If you want only selected lines to print, use Border tools to () to your cells. When you're done, follow the steps to set lines to print or change color.Įxcel prints all the grid lines in a worksheet. To print lines or change color on selected sheets, hold down Shift (for adjacent sheets) or Ctrl (for non-adjacent sheets) and select the sheets to group.To apply the print command or a color change to a workbook, right-click on a sheet in the tab menu at the bottom of the screen and select Select All Sheets before checking the Print box or changing the color.MrExcel ® is a registered trademark of Tickling Keys, Inc.Īll contents © 1998 - 2022 MrExcel Publishing | All rights reserved. View our Privacy Policy, Cookies Policy, and Terms of Use.Įxcel ® is a registered trademark of the Microsoft Corporation.

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.

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.

Remove print lines excel 2016