Excel provides many ways to handle and apply various types of formatting to your spreadsheets. I remember when I was first force-fed Excel, many moons ago. I found it amazing that some people could make the plain column/row spreadsheet look like a document that had been produced in Word. Sure, being a Word expert at heart, I would prefer to format a Word doc and just insert the data I needed into a table. But when repeated analysis and calculations are needed, Excel is the better way to handle a document of that type. So many users opt to create a Word looking document in Excel that they can easily recalculate and print...while still having the page printout looking less like a spreadsheet and more like a formal report.
In this article I'll show you many ways to manually and automatically handle various formatting issues...from direct cell formatting to borders and size adjustments.
But before you get into this lesson, if you're new to Excel, be sure you've studied lesson 1, first.