Formatting cells in microsoft excel
Download
1 / 19

Formatting Cells in Microsoft Excel - PowerPoint PPT Presentation


  • 101 Views
  • Uploaded on

Formatting Cells in Microsoft Excel. In the ribbon on the right is Format. Highlight the cells you want to format. When you click on Format, select Format cells at the bottom.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Formatting Cells in Microsoft Excel' - kezia


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Formatting cells in microsoft excel

Formatting Cellsin Microsoft Excel



Highlight the cells you want to format when you click on format select format cells at the bottom
Highlight the cells you want to format.When you click on Format, select Format cells at the bottom


A dialogue box pops up on top of your worksheet.So here are tabs, sort of like flipping through folders in a drawer. Each tab has options.The tab that is active shows white. “Protection” is the tab active here. This can lock certain cells so that only the person with the password can change it. Often used in budget worksheets.


When you click on number you can see the options general means just that no specific formatting
When you click on Number you can see the options.General means just that, no specific formatting.


When you select Number (under the Number tab)you can pick the number of decimal places that show up in the cell.The default is 2 decimal places.There are times you’ll want whole numbers without any decimals. This is where you’d set that. Use the arrows to indicate 0 decimal places.


Pause here set decimal places to zero and enter the following data
Pause here, set decimal places to zero and enter the following data:

A1 1,000

B1 2,000

C1 3,000

D1 4,000

E1 5,000


As you enter the data you ll see the cell that is active here and it s value here
As you enter the data, following data:you’ll see the cell that is active here and it’s value here.


You’ll see that you’re not looking at numbers, but rather ####The number is still there, it’s just that the column is too narrow to display it.


When you click on the Alignment tab there are lots of options!You can dictate the horizontal and vertical alignment in the box.You can Wrap Text by checking the box in front of the words ~which means the text automatically wraps in the cell.Here you can change the angle of the text. Grab the red diamond in the orientation box and drag it to 45 degrees (shown on next slide)


When you get the red diamond to this position, click OK at the bottom of the dialogue box.

Your sheet should now look like this:


The font tab allows you to change the font style, size, and color.There are shortcuts for these. But here is where you can add effects like strikethroughs, superscripts and subscripts.



Fill effects
Fill Effects: color.

A1 Horizontal 2 color white and yellow

B1 Vertical 2 color blue and red


For cell C1, use color 1 green, color 2 orange, but then click on variant that shows the orange in the middle.The sample box in the lower right shows what the effects will look like if you click OK.


Patterns are also available. click on variant that shows the orange in the middle.Set D1 to Pattern Thin Diagonal Crosshatch ~ the bottom right choice.Color ~ red


Fill effects for e1
Fill Effects for E1 click on variant that shows the orange in the middle.

Pattern Style Horizontal Stripe

color blue


If you did it correctly your worksheet will look like this
If you did it correctly, your worksheet will look like this: click on variant that shows the orange in the middle.


Please add your name in cell a3 and print
Please add your name in cell A3 and print click on variant that shows the orange in the middle.


ad