We have already dealt with some of the basic functions of Microsoft Excel, an application of the MS Office suite. In this part, we look at the various kinds of formatting capabilities Excel provides.
Merged cells break sorting and tables—use a macro to apply Center Across Selection with one click instead.
Removing Excel's gridlines reduces visual clutter, enhances charts and tables, and helps you design more app-like dashboards.
Q. I would like to accent the columns of my dataset by showing the headers diagonally. Is that possible in Excel? A. Want to make text stand out in your spreadsheet? Or just want to try some different ...