You can't change the color of selected grid lines - Excel applies the change to the whole sheet - but you can use borders to change the color and style of lines around selected cells.You can also use borders to change the color or thickness of lines around selected cells. This tip will show you how to hide certain points on the chart axis using custom label format. If you want only selected lines to print, use Border tools to () to your cells. Sometimes you need to omit some points of the chart axis, e.g., the zero point. In case you are wondering how to remove (or. Linnets How To Remember to like and subscribe See all my videoes in playlist / categories here. I think removing gridlines makes the charts and worksheets more presentable. You can also use this with non contiguous ranges.

Change 'A1:G1' in the macro to the cells you want. After the loop it print the sheet and then unhide the rows. When you're done, follow the steps to set lines to print or change color.Įxcel prints all the grid lines in a worksheet. I like to hide grid lines on my spreadsheets and charts whenever possible. This example will loop through every row in this one column range (row 1 - 30) Set rng Sheets ('Sheet1').Range ('A1:A30') If every cell in column A:G is empty it will hide that row.

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.

Hide print lines excel 2016