Formatting spreadsheets in Excel can create them easier to understand as well as more visually pleasing. The tools used to format elements of spreadsheets are controlled in the Format menu. Some of the items that users can format in Excel spreadsheets contain cells, rows, columns as well as the sheet.

Instructions

Format Cells

1. Step 1
Click on the "Format" button on the menu bar and after that click on "Cells." The "Format cells" dialog box includes selection you can make use of to format the contents of a cell. The tabs contained in this box are: Number, Alignment, Font, Border, Patterns with Protection.

2. Step 2
Make use of the "Number" tab to format numerical data in the cells. You can make use of the categories in the listing to adjust the way Excel displays numbers, percentages, fractions, date, time as well as currencies.

3. Step 3
Make use of the "Alignment" tab to alter the position, direction along with control of text in the cells.

4. Step 4
Choose the "Font" tab to alter the properties of fonts. You can modify the font, font style, size as well as color. You can too emphasize the text as well as select additional special effects.

5. Step 5
Make a boundary with the "Border" tab. make a custom border by means of the line styles, color as well as border type.

6. Step 6
Make use of the "Patterns" tab to make cell shading. The color palette includes standard colors as well as you can choose a pattern to emerge with the background color.

7. Step 7
Set the security level of your spreadsheet with the "Protection" tab. You can lock a cell, or group of cells, when you confirm the "Locked" checkbox. "Hidden" hides the formula stored in a cell.

Format a Row

8. Step 1
Adjust the height of a row. Click the row header to choose it. Click on "Format" on the menu, highlight "Row" as well as choose "Height." Type in a number for the new height and click "OK."

9. Step 2
Use "Autofit" to change the row for best fit. Click on the row header to choose it and afterward click on "Format." Highlight "Row" and after that select "Autofit."

10. Step 3
Hide a row. Click on the row header, select Format, highlight "Row" and afterward click "Hide." This selection hides the row from sight but the numbers in the row heading will show that there is a row missing.

11. Step 4
Display a hidden row. Highlight cells above as well as below the hidden row. Highlight "Row" on the Format menu and choose "Unhide."
Format a Column

12. Step 1
Adjust the width. Click on the column header of the column you desire to alter. Highlight "Column" in the Format menu as well as choose "Width." Enter a new number for column width in the "Column Width" box.

13. Step 2
Make use of Autofit selection to correct the column to its best fit. Choose the column you want to adjust. Highlight "Column" in the Format menu and select "Autofit."

14. Step 3
Hide a column. Click on the column header of the column you want to hide. Highlight "Column" in the Format menu as well as click on "Hide."

15. Step 4
Display a hidden column. Choose cells in the columns on also side of the hidden column. Choose "Column" in the Format menu as well as click on "Unhide."

16. Step 5
Adjust the default width for all columns in the existing worksheet. Choose "Column" from the Format menu as well as select "Standard Width." Enter a fresh default width as well as click "OK."
Format a Sheet

17. Step 1
Alter the given name of a sheet in the workbook. Select "Sheet" from the Format menu as well as choose "Rename." Enter a fresh name at the base of the present worksheet as well as press the "Enter" key.

18. Step 2
Hide the existing sheet. Select "Sheet" from the Format menu and choose "Hide."

19. Step 3
Display a hidden sheet. Highlight "Sheet" in the Format menu as well as choose "Unhide." Click on the name of the sheet you want to display in the "Unhide" box.

20. Step 4
Change the background of your existing worksheet. Choose "Sheet" from the Format menu as well as choose "Background." Make use of the "Sheet Background" box to find the image you want to make use of as a background as well as click "Insert."

21. Step 5
Use Autoformat to apply preset designs to your worksheet. Spot to "Sheet" in the Format menu as well as choose "Autoformat." Select one of the presets in the Autoformat box as well as click "OK."

22. Step 6
Make use of Conditional Formatting to monitor dynamic data in your worksheet. Choose "Sheet" in the Format menu as well as select "Conditional Formatting." Enter the conditions for the information you desire to monitor as well as click "OK."

23. Step 7
Add or remove style elements set beforehand with the "Style" button. Highlight "Sheet" in the Format menu as well as click on "Style." Check the boxes matching to the elements you wish to insert or uncheck the boxes for those you want to eliminate.