Sheets: Continue Formatting and Organizing — Freeze Cells, Columns, and Rows, Add Borders, Set Fill Color, Add Borders, and Change Fonts and Sizes

In the previous video, you began changing the format of your spreadsheet so it would be better organized, more visually appealing, and easier for you to use and share.

In this video, you will continue making formatting and organizational changes.

To begin, assign each sales transaction an identification -- or ID -- number.

This helps you organize the purchases.

Two people placing an order might have the same name, or two transactions could be so similar that it's difficult to tell them apart.

Sale ID numbers separate each order clearly.

To do this, insert a new column to the left of your first column.

Freeze your column.

Freezing rows and columns keeps them from moving when you scroll through your sheet, making it easier to line up your data with the correct heading as you scroll.

Now, label the first row for a header.

Then, make the first purchase number one.

You could type the number for each sale ID by hand, but this would take a long time and may not be possible for spreadsheets with hundreds or thousands of data entries.

Instead, drag the handle to populate each cell with the numbers.

Oops! Instead of filling in the numbers sequentially, the last number was copied to each row.

To automatically fill in sequential numbers, select each of the cells you typed the sale ID into.

In this case, it's "1," "2," and "3." And drag the handle.

Nice work! Selecting several numbers in the sheet demonstrated the pattern you want to follow.

Next, divide your spreadsheet into a grid so that it's easier to tell which information belongs to which products.

To do this, add borders between columns.

Choose a border style.

And add borders around your headers.

To make the headers more eye-catching, add fill colors.

Next, change the borders in the first row so the cells are clear.

Merge the cells to create another header.

Type a title for your sheet add formatting.

And change the font style, if you'd like.

To make your spreadsheet a more manageable size, adjust the column widths.

Select all the columns in your sheet.

And resize them to fit the data.

Then, delete the columns you're not using.

Limiting the number of columns reduces the need to scroll through your sheet.

Now, it's your turn: insert a column, freeze the column, number the rows by dragging to populate the cells, add borders, resize the columns to fit the data, and delete columns you're not using.