Excel 2013 –

Dưới đây là danh sách Format a cell in excel hay nhất được bình chọn

Video Format a cell in excel

/en/excel2013/modifying-columns-rows-and-cells/content material/

Advent

All cellular content material makes use of the similar formatting via default, which may make it tricky to learn a workbook with a large number of data. Fundamental formatting can customise the feel and appear of your workbook, permitting you to attract consideration to precise sections and making your content material more uncomplicated to view and perceive. You’ll additionally follow quantity formatting to inform Excel precisely what form of information you’re the use of within the workbook, corresponding to percentages (%), foreign money ($), and so forth

Not obligatory: Obtain our follow workbook.

To switch the font:

By means of default, the font of each and every new workbook is about to Calibri. Alternatively, Excel supplies many different fonts you’ll be able to use to customise your cellular textual content. Within the instance underneath, we’re going to structure our name cellular to assist distinguish it from the remainder of the worksheet.

  1. Choose the cellular(s) you wish to have to change.
  2. Click on the drop-down arrow subsequent to the Font command at the House tab. The Font drop-down menu will seem.
  3. Choose the specified font. A reside preview of the brand new font will seem as you hover the mouse over other choices. In our instance, we’re going to make a choice Georgia.
  4. The textual content will exchange to the decided on font.

When making a workbook within the place of business, it would be best to make a selection a font this is simple to learn. In conjunction with Calibri, same old studying fonts come with Cambria, Instances New Roman, and Arial.

To switch the font measurement:

  1. Choose the cellular(s) you wish to have to change.
  2. Click on the drop-down arrow subsequent to the Font Dimension command at the House tab. The Font Dimension drop-down menu will seem.
  3. Choose the specified font measurement. A reside preview of the brand new font measurement will seem as you hover the mouse over other choices. In our instance, we can make a choice 16 to make the textual content greater.
  4. The textual content will exchange to the decided on font measurement.

You’ll additionally use the Build up Font Dimension and Lower Font Dimension instructions or input a customized font measurement the use of your keyboard.

To switch the font colour:

  1. Choose the cellular(s) you wish to have to change.
  2. Click on the drop-down arrow subsequent to the Font Colour command at the House tab. The Colour menu will seem.
  3. Choose the specified font colour. A reside preview of the brand new font colour will seem as you hover the mouse over other choices. In our instance, we’re going to make a choice Inexperienced.
  4. The textual content will exchange to the decided on font colour.

Choose Extra Colours on the backside of the menu to get right of entry to further colour choices.

To make use of the Daring, Italic, and Underline instructions:

  1. Choose the cellular(s) you wish to have to change.
  2. Click on the Daring (B), Italic (I), or Underline (U) command at the House tab. In our instance, we’re going to make the chosen cells daring.
  3. The decided on taste might be implemented to the textual content.

You’ll additionally press Ctrl+B for your keyboard to make decided on textual content daring, Ctrl+I to use italics, and Ctrl+U to use an underline.

Textual content alignment

By means of default, any textual content entered into your worksheet might be aligned to the bottom-left of a cellular, whilst any numbers might be aligned to the bottom-right. Converting the alignment of your cellular content material permits you to make a choice how the content material is displayed in any cellular, which may make your cellular content material more uncomplicated to learn.

Click on the arrows within the slideshow underneath to be informed extra concerning the other textual content alignment choices.

  • Screenshot of Excel 2013

    Left align: Aligns content material to the left border of the cellular

  • Screenshot of Excel 2013

    Heart align: Aligns content material an equivalent distance from the left and correct borders of the cellular

  • Screenshot of Excel 2013

    Proper Align: Aligns content material to the suitable border of the cellular

  • Screenshot of Excel 2013

    Most sensible Align: Aligns content material to the highest border of the cellular

  • Screenshot of Excel 2013

    Center Align: Aligns content material an equivalent distance from the highest and backside borders of the cellular

  • Screenshot of Excel 2013

    Backside Align: Aligns content material to the lowest border of the cellular

To switch horizontal textual content alignment:

In our instance underneath, we’re going to alter the alignment of our name cellular to create a extra polished glance and additional distinguish it from the remainder of the worksheet.

  1. Choose the cellular(s) you wish to have to change.
  2. Choose some of the 3 horizontal alignment instructions at the House tab. In our instance, we’re going to make a choice Heart Align.
  3. The textual content will realign.

To switch vertical textual content alignment:

  1. Choose the cellular(s) you wish to have to change.
  2. Choose some of the 3 vertical alignment instructions at the House tab. In our instance, we’re going to make a choice Center Align.
  3. The textual content will realign.

You’ll follow each vertical and horizontal alignment settings to any cellular.

Mobile borders and fill colours

Mobile borders and fill colours can help you create transparent and outlined limitations for various sections of your worksheet. Under, we’re going to upload cellular borders and fill colour to our header cells to assist distinguish them from the remainder of the worksheet.

So as to add a border:

  1. Choose the cellular(s) you wish to have to change.
  2. Click on the drop-down arrow subsequent to the Borders command at the House tab. The Borders drop-down menu will seem.
  3. Choose the border taste you wish to have to make use of. In our instance, we can make a choice to show All Borders.
  4. The decided on border taste will seem.

You’ll draw borders and alter the line taste and colour of borders with the Draw Borders gear on the backside of the Borders drop-down menu.

So as to add a fill colour:

  1. Choose the cellular(s) you wish to have to change.
  2. Click on the drop-down arrow subsequent to the Fill Colour command at the House tab. The Fill Colour menu will seem.
  3. Choose the fill colour you wish to have to make use of. A reside preview of the brand new fill colour will seem as you hover the mouse over other choices. In our instance, we’re going to make a choice Gentle Inexperienced.
  4. The decided on fill colour will seem within the decided on cells.

Structure Painter

If you wish to replica formatting from one cellular to any other, you’ll be able to use the Structure Painter command at the House tab. Whilst you click on the Structure Painter, it’s going to replica all the formatting from the chosen cellular. You’ll then click on and drag over any cells you wish to have to stick the formatting to.

Watch the video underneath to be informed two other ways to make use of the Structure Painter.

Mobile types

As an alternative of formatting cells manually, you’ll be able to use Excel’s predesigned cellular types. Mobile types are a snappy approach to come with skilled formatting for various portions of your workbook, corresponding to titles and headers.

To use a cellular taste:

In our instance, we’re going to follow a brand new cellular taste to our current name and header cells.

  1. Choose the cellular(s) you wish to have to change.
  2. Click on the Mobile Types command at the House tab, then make a choice the desired taste from the drop-down menu. In our instance, we’re going to make a choice Accessory 1.
  3. The decided on cellular taste will seem.

Making use of a cellular taste will change any current cellular formatting apart from for textual content alignment. You would possibly not wish to use cellular types in the event you’ve already added a large number of formatting on your workbook.

Formatting textual content and numbers

One of the vital robust gear in Excel is the power to use particular formatting for textual content and numbers. As an alternative of showing all cellular content material in precisely the similar method, you’ll be able to use formatting to switch the semblance of dates, instances, decimals, percentages (%), currency ($), and a lot more.

To use quantity formatting:

In our instance, we’re going to exchange the quantity structure for a number of cells to change the way in which dates are displayed.

  1. Choose the cells(s) you wish to have to change.
  2. Click on the drop-down arrow subsequent to the Quantity Structure command at the House tab. The Quantity Formatting drop-down menu will seem.
  3. Choose the desired formatting possibility. In our instance, we can exchange the formatting to Lengthy Date.
  4. The chosen cells will exchange to the new formatting taste. For some quantity codecs, you’ll be able to then use the Build up Decimal and Lower Decimal instructions (underneath the Quantity Structure command) to switch the collection of decimal puts which are displayed.

Click on the buttons within the interactive underneath to be informed about other textual content and quantity formatting choices.

Problem!

  1. Open an current Excel 2013 workbook. If you wish to have, you’ll be able to use our follow workbook.
  2. Choose a cellular and alter the font taste, measurement, and colour of the textual content. In case you are the use of the instance, exchange the name in cellular A3 to Verdana font taste, measurement 16, with a font colour of inexperienced.
  3. Follow daring, italics, or underline to a cellular. In case you are the use of the instance, daring the textual content in cellular vary A4:C4.
  4. Take a look at converting the vertical and horizontal textual content alignment for some cells.
  5. Upload a border to a cellular vary. In case you are the use of the instance, upload a border to the header cells in in row 4.
  6. Trade the fill colour of a cellular vary. In case you are the use of the instance, upload a fill colour to row 4.
  7. Take a look at converting the formatting of a host. In case you are the use of the instance, exchange the date formatting in cellular vary D4:H4 to Lengthy Date.

/en/excel2013/worksheet-basics/content material/

Related Posts