How to Change a Cell Format

Save

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.

References

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

Comments

You May Also Like

Related Searches

Check It Out

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

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