Formatting in Excel involves changing the appearance of cells and data, including fonts, colors, borders, and number formats, to enhance readability and presentation.