After data has been added to a spreadsheet, it can be formatted to highlight or organize it. Click to select a cell for formatting, or click and drag to select more than one or a range of cells. Press ctrl on a Windows device or command on a Mac, and select multiple cells by clicking on them, from there, you can choose from a number of formatting options. You can change the background color of a cell or range of cells with the change Fill color toolbar icon. Select cells A1 to N1, click the change Fill color icon, And change the color to orange. Google sheets also allows you to set alternating colors by header and row, and apply conditional formatting which assigns a color based on rules for cell contents. Select row one and row two and change the font weight to bold. Borders are the lines around a cell, cell borders can be eliminated or styled as appropriate for the display of the data in the sheet. The options for borders include, changing the style of the outline, including line thickness, dotted or dashed, and color. Borders can be applied on any side of a cell or group of cells, select the populated cells in the spreadsheet, click on the Border icon in the toolbar, and assign a solid border. Data can span multiple cells by merging those cells together, cells can be merged horizontally, vertically, or both. Select multiple cells C2, to E2, which represent quarter one, and then click Merge cells or click the drop down to select merge type for additional options. Let's also merge quarter two, quarter three, and quarter four, choose left, right or center alignment for the cell data, choose top, bottom or center alignment for the cell data. Select row one and row two, then use the Format menu to align contents middle and center. When adding data to a cell, long numbers or text strings may fill its visible space. Choose an option for how sheets deals with displaying the data, overflow, wrap or clip. Overflow will allow the data to overlap in adjacent cell, wrap will resize the cell to accommodate the data entered into it. Clip will display a portion of the data although all the data will still be figured into formulas and functions. Reduce the width of column B, so that the trailing text is no longer visible. Then select column B, from the Format menu, choose text wrapping and then wrap. Text entered into a cell can be rotated in nearly any direction, options for text rotation include tilt up, tilt down, stack vertically, rotate up, and rotate down. If none of these options are appropriate, a custom angle can be applied to text in the cell. Select cells A3 through A7, then merge the cells, in cell A3 from the Format menu, choose Text rotation, then rotate up. Align the cell contents middle and center and increase the font size, any changes in formatting can be undone or redone by selecting the undo or redo in the toolbar. This will also reverse or apply changes in data entry and calculation in addition to formatting. Note that, formatting is normally applied to all of the data in a cell, but double clicking the cell allows selection of a portion of the data in it, which can be formatted separately.
