How to Change a Cell Format


When talking about spreadsheets, a cell is box created by the intersection between a column and a row. Usually, a cell's identity consists the letter of the column, followed by the number of the intersecting row. Cells display text, numbers and show solutions to formulas. Cells have many formatting options including color, size, number type and orientation. You can also format cells to include bordering and shading to highlight important data. Microsoft Excel--a popular spreadsheet program--provides all the tools needed to change the formatting in a cell.

  • Open the Microsoft Excel worksheet you wish to edit.

  • Right-click the preferred cell and select "Format."

  • Change the number formatting by clicking the "Number" tab and choosing a format. There are many options such as currency, percentage and date.

  • Edit the cell's alignment by clicking the "Alignment" tab and changing the orientation.

  • Change the cell's font, color and size by selecting the "Font" tab and editing the options.

  • Click the "Border" tab to add a border around the cell. You can customize each side of the cell by selecting a side and choosing a border. Borders can also contain color.

  • Choose the "Fill" tab to add shading, patterns and color to the inside of your cell.

Related Searches


  • Photo Credit Steve Cole/Photodisc/Getty Images
Promoted By Zergnet


You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!