Categories
Microsoft Office

How to Format Text in MS Excel 2007

In MS Excel when you enter the information into your spreadsheet you need to be able to format the information and in this tutorial you will learn how can you use bold, italic as well as underline commands. You can also learn about Clearing History and Cookies in Microsoft Edge Browser.

Formatting Cells:

In order to format the cells you need to follow these simple steps.

Formatting text in bold or italics:

  • 1st of all left click a cell in order to select it or drag the cursor over the text in the formula bar to select it.
  • Now click on the Bold or Italics command.
  • You can select entire columns and rows or some specific cells. In order to select the entire column all you need to do is to left-click the column heading and all the column will be selected.

Formatting Text as Underlined:

  • Select the cell or cells which you need to format.
  • Now click on the drop down arrow next to the Underline command.
  • Now select the Single underline or Double Underline option.

Changing the Font Style:

  • 1st of all select the cell or cells which you want to format.
  • Now left click the drop-down arrow next to Font Style box on the Home tab.
  • Now select the font style from the list.

Changing the Font Size:

  • 1st of all select the cell or cells which you want to format.
  • Now left click the drop-down arrow next to the Font Size box on the Home tab.
  • Now select the font size from the list.

Changing the Text Color:

  • 1st of all select the cell or cells which you need to format.
  • Left click the drop-down arrow next to the Text Color command. You will notice that a color palette will appear.
  • Now select the color from the palette.

OR

  • Select the More Colors and a dialog box will appear.
  • Now select a color and then click OK.
Categories
Microsoft Office

Indenting Text in MS PowerPoint 2013

Indentation is one of the most important features which can be used for changing the way text is appeared on a slide. Indentation can be used for creating multilevel listss or for visually setting the parapgraphs apart from each other. Indenting of text will let you format the layout of text so it will appear in a more organized manner in the slide. Tab key is used for indenting the text quickly and the alternative way of creating an indent is to use Indent commands. With these command the indent can be increased or decreased. You can also learn about WordArt Styles in MS PowerPoint 2013.

Indenting Text using Tab Key:

For indenting the text using tab key you need to place the insertion point at the start of the tline which you need to indent and after that you are required to press Tab key.

Indenting Text using Indent Commands:

For indenting the text by using the Indent commands you need to place the insertion point at the start of the line which you want to indent and then from Home tab you need to press Increase Indent or Decrease Indent command. For decreasing the indent you need to select the line and after that press Shift+Tab.

FineTunning the Indents:

Sometimes there are scenarios where you want to fine tune the indents in your presentations and you can fine tune them by adjusting the indent markers on the ruler. The ruler is hidden by default which means you need to show the ruler first. In order to show the ruler you need to follow these simple steps.

  • 1st of all you need to select the View tab on the Ribbon.
  • Now in the Show group check the box located nex to Ruler and the ruler will appear.
Categories
Microsoft Office

Applying Themes in MS PowerPoint 2013

A theme is a predefined combination of colors, fonts and effects and it can be used in different slide layouts. By default Office theme is applies to all the slides but you can select any other one of your choice froma variety of new themes at any time thus giving your presentation an appealing look. You can also learn about WordStyles in MS Word 2013. Every theme is composed of various themes elements which are as under.

Theme Fonts: There are two theme fonts available at the top of the Font menu under Theme Fonts.

Theme Colors: There are 10 theme colors along with darker and lighter variations which are available from every Color menu.

Theme Effects: These effects can be found in the shape styles on the Format tab.

Applying Themes in your Presentation:

In order to apply themes in your presentations you are required to follow these simple steps.

  • 1st of all you need to select the Design tab loacted in the Ribbon menu.
  • Now you need to locate the Themes group and each image represents a theme.
  • Now in the next step you need to click the More drop-down arrow in order to see all of the available themes.
  • Now you need to select the desired theme from the list.
  • Once you select the desired theme it will be applied to the entire presentation.
  • Now for applying a different theme you need to simply select it from the Design tab.
  • With these simple steps you will be able to apply various themes into your presentations.