formatting cells in microsoft excel
Download
Skip this Video
Download Presentation
Formatting Cells in Microsoft Excel

Loading in 2 Seconds...

play fullscreen
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
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
slide4

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.
slide6

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

slide9

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.

slide10

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)

slide11

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:

slide12

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:

A1 Horizontal 2 color white and yellow

B1 Vertical 2 color blue and red

slide15

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.

slide16
Patterns are also available.Set D1 to Pattern Thin Diagonal Crosshatch ~ the bottom right choice.Color ~ red
fill effects for e1
Fill Effects for E1

Pattern Style Horizontal Stripe

color blue

ad