The formatting toolbar In Excel, the Formatting toolbar can be used to change the format of cells without displaying the Format Cells dialog box. The most commonly used formatting options are available via this toolbar. To remove a format, simply reselect the range and then click the same toolbar button again. In this regard many of the toolbar buttons work like toggle switches, turning the desired formatting on and off. A couple of the formatting notes.
All button is located at the intersection of the row and column headings.
This indicated that the newly formatted value in that cell is now too big to fit within the current column width. The easiest way to adjust a column's width is to point to the border between two columns in the columns heading area and when your mouse pointer changes into a double arrowhead, simply drag the column to the desired size. In addition, you can either double-click on a column heading to make it resize to accommodate the largest entry in that column or use the menu choice Format, Column, Width . Copying and pasting formats When you copy and paste cells into a new location by using the Edit, Paste command, the formulas, values and formats within those cells are also copied and pasted. To paste only specific attributes, you would use the Edit, Paste Special command.