Or no fill to let the underlying cell’s fill color show through Set the fill color to whatever you want for the background color, Position it over the cell where you want the data to appear.įormat it visually as you want. In that case, for each cell that that you want to display but not print: If that’s good enough for you, you’re done.īut you might want the excluded cell(s) to appear inside the print area Put the cell(s) that you don’t want to print outside the print area.
It builds on the idea of using a “Print Area”, This solution doesn’t require you to take special actionīefore and after each time you need to print the file.