Thursday, November 8, 2018

Cell Formatting



Cell Formatting in Excel

The Format Painter


The format painter lets you copy all formatting from one object and apply it to another one.
  1. Select the text or graphic that has the formatting that you want to copy. 
  2. On the Home tab, click Format Painter. The pointer changes to a paintbrush icon. 
  3. Use the brush to paint over a selection of text or graphics to apply the formatting. This only works once. 
  4. To change the format of multiple selections in your document, you must first double-click Format Painter
  5. Then to stop formatting, press ESC.
format painter in excel

Note: If you want to copy text formatting, select a portion of a paragraph. If you want to copy text and paragraph formatting, select an entire paragraph, including the paragraph mark.  

Cell Merging and AutoFit

Cell Merging


There are a few cells merging;
  1. Combine and center the content of selected cells in a new larger cell. This is a great way to create a label that spans multiple columns.
    merge center excel
  2. Merge selected cells in the same row into one large cell. 
    merge into same row to one large in Excel
  3. Merge selected cells into one cell.
    Merge selected cells into one cell Excel

AutoFit


AutoFit will enable you to resize and adjust height and width rows and columns instantly. Learn the exact steps on how to apply to autofit in your Excel-spreadsheet.
  1. Select the columns or rows that you want to change. 
  2. On the Home tab, in the Cells group, click Format
  3. Under Cell Size, click AutoFit Column Width or AutoFit Row Height.
autofit excel