Monday, September 7, 2009

How to Print Empty Cells with Borders in Excel

Normally, Excel will not print empty cells, and will only the print the header row that contains data in the cell. Here's how Excel can print empty cells with gridlines/borders
  • Add the Borders
  • Select the cells to be printed
  • Go to File > Print Area > Set Print Area
  • Go to File > Print and now all the cells that were selected will display in the print preview.

No comments:

Post a Comment

Only comments in English will be considered. Thank you!