4. 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 wouldbe better organized, more visually appealing, and easier for you to use and share.
In this video, you will continue making formatting and organizational changes.
You will: Add a new column,Freeze your new column, Assign each row a Sale I-D number,And add borders.
To begin, assign each sales transaction an identification -- or I-D -- number. This helpsyou organize the purchases. Two people placing an order might have the same name, or twotransactions could be so similar that it’s difficult to tell them apart. Sale I-D numbersseparate each order clearly. To do this, insert a new column to the leftof your first column.
Freeze your column. Freezing rows and columns keeps them from moving when you scroll throughyour 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 I-D by hand, but this would take a long time andmay 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 typedthe sale I-D into. In this case, it’s one, two, and three.
And drag the handle. Nice work! Selecting several numbers in thesheet demonstrated the pattern you want to follow.
Next, divide your spreadsheet into a grid so that it’s easier to tell which informationbelongs to which product. To do this, add borders between columns.
Choose a border style.
And add borders around your headers. To make the headers more eye-catching, addfill colors. Next, change the borders in the first rowso 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 manageablesize, 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.
Nice work! Your spreadsheet is now clear and easy to read. But, if you’re planning toshare with others on your team or within your organization, you might want to make it eveneasier to update and analyze. Move on to the next video to add data validation to yourspreadsheet. 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.