See all Microsoft Excel tips
Strategy: Highlight the extra cells and choose white text color. Use the dropdown next to the Font Color icon, as shown in Fig. 1222. When you choose the dropdown instead of the icon, you can choose a white color, as shown in Fig. 1223.
As shown in column M & N of Fig. 1224, this will prevent the cells from being seen or from printing (assuming the cell background color is also white).
Additional information: If you need to troubleshoot these cells, reselect the columns. As shown in Fig. 1225, against the dark highlighting you can see the results in white.
Summary: Selecting an area and choosing white text will prevent the cells from printing and the user from seeing them.
Commands Discussed: Format – Cells – Color
See all Microsoft Excel tips
