There is a solution that will make the manager happy. It won’t be found in the ribbon. Remember that the options in the ribbon are there to make Excel novices happy. If you are reading this book, you frequently have to go beyond the ribbon. In the ribbon, they offer two types of underlines.
Figure 592 Two underline types in the ribbon.
Skip the ribbon choices. Instead, click on the dialog launcher at the bottom of the Font group of the Home tab of the ribbon.
Figure 593 Click the dialog launcher.
The underline dropdown in the Format Cells dialog offers four choices instead of two. Choose Single Accounting underline.
Figure 594 The good choices are not in the ribbon.
The result are bottom underlines that extend almost all the way across the cell, but not quite all the way. When printed, this will give the same look as back in Figure 590.
Figure 595 These underlines appear similar to gaps between columns.
Alternate Strategy: If your manager still demands the blank columns, you can put a word, just as “blank" in the headings of the blank columns. Change the font color to white to no one sees those headings when printed. This will allow the entire data set to be treated as a contiguous column.