Constructing and formatting an Excel worksheet

In this chapter, you will learn methods to quickly input and work with Excel data, and then apply and modify cell formats. You will enhance these skills by merging or splitting cells, and learning how to hide and show rows and columns. You will also apply cell styles, insert and delete rows and columns, set column and row widths/heights, and work with worksheets, workbooks, and sheet tabs.

Inputting data efficiently

To input data into Excel, simply click on a cell and start typing. When you are done, press the Enter key on the keyboard. Values are always aligned to the right, and text aligned to the left of the cell. You can use the Formula Bar to enter data into a cell, although...