In: Categories » » Microsoft office » Formatting fonts and text styles. Navigating a Spreadsheet
Different fonts can emphasize parts of your spreadsheet, such as using one font to label columns and rows and another font or font size to display the actual data. Text styles (bold, underline, and italic) can also emphasize data that appears in the same font or font size. To change the font, font size, and text style of one or more cells, follow these steps:
1. Select the cell or cells that you want to change the font and font size.
2. Click the Home tab.
3. Click the Font list box. A pull-down menu of different fonts appears.
4. Click the font you want to use.
5. Choose one of the following methods to change the font size:
• Click the Font Size list box and then choose a font size, such as 12 or 16.
• Click the Font Size list box and type a value such as 7 or 15.
• Click the Increase Font Size or Decrease Font Size icon until your data appears in the size you want.
6. Click one or more text style icons (Bold, Italic, Underline).
Formatting with color
Each cell displays data in a Font color and a Fill color. The Font color defines the color of the numbers and letters that appear inside a cell. (The default Font color is black.) The Fill color defines the color that fills the background of the cell. (The default Fill color is white.) To change the Font and Fill colors of cells, follow these steps:
1. Select the cell or cells that you want to color.
2. Click the Home tab.
3. Click the downward-pointing arrow that appears to the right of the
Font Color icon. A color palette appears.
4. Click the color you want to use for your text. The color you select appears directly on the Font Color icon. The next time you want to apply this same color to a cell, you can click the Font Color icon directly instead of the downward-pointing arrow to the right of the Font Color icon.
5. Click the downward-pointing arrow that appears to the right of the
Fill Color icon. A color palette appears.
6. Click a color to use to fill the background of your cell. The color you select appears directly on the Fill Color icon. The next time you want to apply this same color to a cell, you can click the Fill Color icon directly instead of the downward-pointing arrow to the right of the Fill Color icon.
Adding borders
For another way to highlight one or more cells, you can add borders. Borders can surround the entire cell or just the top, bottom, left, or right side of a cell. To add borders to a cell, follow these steps:
1. Select one or more cells.
2. Click the Home tab.
3. Click the downward-pointing arrow to the right of the Border icon. A pull-down menu appears.
4. Click a border style.
Navigating a Spreadsheet
If you have a large spreadsheet, chances are good that information may be hidden by the limitations of your computer screen. To help you view and select cells in different parts of your spreadsheet, Excel offers various ways to navigate a spreadsheet using the mouse and keyboard.
Using the mouse to move around in a spreadsheet
To navigate a spreadsheet with the mouse, you can click the scroll bars or use the scroll wheel on your mouse, if you have one. To use the scroll bars, you have three choices:
Click the up/down or right/left arrows on the horizontal or vertical scroll bars.
This moves the spreadsheet one row (up or down) or column (right or left) at a time.
Drag the scroll box of a scroll bar. Click the scroll area (any area to the left/right or above/below the scroll box on the scroll bar).
This moves the spreadsheet one screen left/right or up/down. If your mouse has a scroll wheel, you can use this wheel to move through a spreadsheet by two methods: Roll the mouse’s scroll wheel up or down to scroll your spreadsheet up or down. Press the scroll wheel to display a four-way pointing arrow, then move the mouse up, down, right, or left. (When you’re done, click the scroll wheel again.)
Using the keyboard to move around a spreadsheet
Using the mouse can be faster to jump from one place in a spreadsheet to another, but sometimes using the mouse can be frustrating, trying to line it up just right. For that reason, you can also use the keyboard to move around a spreadsheet. If you know the specific cell you want to move to, you can jump to that cell by using the Go To command. To use the Go To command, follow these steps:
1. Click the Home tab.
2. Click the Find & Select icon in the Editing group. A pull-down menu appears.
3. Click Go To. The Go To dialog box appears. You can also choose the Go To command by pressing Ctrl+G.
4. Click in the Reference text box and type the cell you want to move to, such as C13 or F4.
5. Click OK.
Naming cells
One problem with the Go To command is that most people won’t know which cell contains the data they want to find. For example, if you want to view the cell that contains your total amount of money you owe for your income taxes, you probably don’t want to memorize that this cell is G68. To help you identify certain cells, Excel lets you give them descriptive names. To name a cell or range of cells, follow these steps:
1. Select the cell or cells that you want to name.
2. Click in the Name box.
3. Type a descriptive name without any spaces and then press Enter. After you name a cell, you can jump to it quickly by following these steps:
1. Click the downward-pointing arrow to the right of the Name box. A list of named cells appears.
2. Click the named cell you want to view. Excel displays your chosen cell. Eventually, you may want to edit or delete a name for your cells. To delete or edit a name, follow these steps:
1. Click the Formulas tab.
2. Click the Name Manager icon.
3. Edit or delete the named cell as follows:
• To edit the name, click the cell name you want to edit and then click the Edit button. An Edit Name dialog box appears, where you can change the name or the cell reference.
• To delete the name, click the cell name you want to delete and then click the Delete button.
4. Click Close.
Searching a Spreadsheet
Rather than search for a specific cell, you may want to search for a particular label or number in a spreadsheet. Excel lets you search for the following:
Specific text or numbers All cells that contain formulas All cells that contain conditional formatting Searching for text
You can search for a specific label or number anywhere in your spreadsheet. To search for text or numbers, follow these steps:
1. Click the Home tab.
2. Click the Find & Select icon in the Editing group. A pull-down menu appears.
3. Click Find.
The Find and Replace dialog box appears. If you click the Replace tab, you can define the text or number to find and new text or numbers to replace it.
4. Click in the Find What text box and type the text or number you want to find.
If you click the Options button, the Find and Replace dialog box expands to provide additional options for searching, such as searching in the displayed sheet or the entire workbook.
5. Click one of the following:
• Find Next: Finds and selects the first cell, starting from the currently selected cell that contains the text you typed in Step 4
• Find All: Finds and lists all cells that contain the text you typed in Step 4.
6. Click Close to make the Find and Replace dialog box go away.
Searching for formulas
Formulas appear just like numbers; to help you find which cells contain formulas, Excel gives you two choices:
Display formulas in your cells (instead of numbers)
Highlight the cells that contain formulas
To display formulas in a spreadsheet, press Ctrl+` (an accent grave character, which appears on the same key as the ~ sign and often appears to the left of the number 1 key near the top of a keyboard). To highlight all cells that contain formulas, follow these steps:
1. Click the Home tab.
2. Click the Find & Select icon in the Editing group. A pull-down menu appears.
3. Click Formulas. Excel highlights all the cells that contain formulas.
legal notice
Our website is not responsible for the information contained by this article. Web-articles is a free articles resource.
Suggestion: If you need fresh, daily updated content for your website, feel free to use our service. Click here for more information.
Useful tools and features
If you like this article (tutorial), please link to it from your web page using the information above.
related articles
Microsoft Office 2007 consists of five core programs: Word, Excel, PowerPoint, Access, and Outlook. Each of these core programs specializes in manipulating different data. Word manipulates words, sentences, and paragraphs; Excel manipulates numbers; PowerPoint manipulates text and pictures to create a slide show; Access manipulates data, such as inventories; and Outlook manipulates personal information, such as e-mail addresses and phone numbers. Although each Office 2007 program specializes in storing and mani...
2. Giving commands to Office 2007
To give a command to Office 2007, you need to follow these basic steps: 1. Select an item (text, picture, table, and so on) that you want to modify. 2. Click a tab that contains the command you want. 3. Click the command you want to use. Command icons work in one of three ways: Clickable icons: Clicking an icon immediately chooses a command to alter your data. The Bold and Italic icons are examples of icons that you click only once to choose them. ...
3. Sharing Data with Other Office 2007 Programs
Cutting, copying, and pasting data may be handy within the same file, but Office 2007 also gives you the ability to cut, copy, and paste data between different programs, such as copying a chart from Excel and pasting it into a PowerPoint presentation. Using the Office Clipboard When you cut or copy any data, Windows stores it in a special part of memory called the Clipboard. This Windows Clipboard can only hold one item at a time, so Office 2007 comes with its own Clipboard called t...
4. Typing Text in Word office 2007
The whole purpose of Microsoft Word is to let you type text and make it look pretty so you can print or send it for other people to read. So the first step in using Microsoft Word is learning how to enter text in a Word file, called a document. In every document, Word displays a blinking cursor that points to where your text will appear if you type anything. To move the cursor, you can use the keyboard or the mouse. Moving the Cursor with the Mouse ...
5. Creating text in Word Office 2007
Text can consist of a single sentence, multiple sentences, or several paragraphs. Text always appears indented underneath a heading (or subheading). To create text, follow these steps: 1. Move the cursor to the end of a heading or subheading. This is the heading (or subheading) that your text will be attached to if you move the heading (or subheading). 2. Press Enter. Word creates a blank heading. 3. Click the Demote to Body Text button....
6. Proofreading Your Document Office 2007
Besides checking for spelling or grammatical mistakes, Word can also proofread your document to highlight other possible problems, such as misplaced commas or correctly spelled words that may be used incorrectly. To make Word proofread your document, follow these steps: 1. Click the Proofing icon at the bottom of the document window. Word highlights a possible error and displays a pop-up menu offering options. 2. Choose one of the following: • ...
7. Changing Colors and Justifying Text Alignment in Office 2007
Color can emphasize text. There are two ways to use color: Change the color of the text (Font color). Highlight the text with a different color (Text Highlight color). Changing the color of text When you change the color of text, you’re physically displaying a different color for each letter. Normally, Word displays text in black, but you can change the color to anything you want, such as bright red or dark green. If you choose a light color for your text, it may be hard to re...
8. Creating a new document from a template using Word Office 2007
The easiest time to use a template is before you’ve typed any text. To create a new document from a template, follow these steps: 1. Click the Office Button and then choose New. A New Document window appears. 2. Click one of the following in the left pane of the New Document window: • Installed Templates: Displays templates installed on your computer • Any category under the Microsoft Office Online heading, such as ...
9. Microsoft office 2007 Creating a table by highlighting rows and columns
Organizing Text in Tables Tables organize text into rows and columns, which can make it easy to type, edit, and format text while spacing it correctly in your document. Tables organize text in cells, where a cell is the intersection of a row and a column. Word provides four ways to create a table: Click the Insert tab, click the Table icon, and then highlight the number of rows and columns for your table (up to a maximum of eight rows and ten columns). Use the Inse...
10. Resizing columns and rows. Table styles in Microsoft office 2007
Picking a table style By coloring rows or columns and adding borders, you can customize the appearance of your tables. However, for a faster method, you can just use a predesigned table style instead, which can automatically format your text, color rows, and add borders to your tables. To choose a table style, follow these steps: 1. Move the cursor inside the table you want to modify. 2. Click the Design contextual tools tab. 3. (...