In: Categories » » Microsoft office » Editing a Spreadsheet
The two ways to edit a spreadsheet are: Edit the data itself, such as the labels, numbers, and formulas that make up a spreadsheet.
Edit the physical layout of the spreadsheet, such as adding or deleting rows and columns, or widening or shrinking the width or heights of rows and columns.
Editing data in a cell
To edit data in a single cell, follow these steps:
1. Double-click the cell that contains the data you want to edit. Excel displays a cursor in your selected cell.
2. Edit your data by using the Backspace or Delete key, or by typing new data.
If you click a cell, Excel displays the contents of that cell in the Formula bar. You can click and edit data directly in the Formula bar, which can be more convenient for editing large amounts of data.
Changing the size of rows and columns with the mouse
Using the mouse can be a quick way to modify the sizes of rows and columns. To change the height of a row or the width of a column, follow these steps:
1. Move the mouse pointer over the bottom line of a row heading, such as the 2 or 18 heading. (Or move the mouse pointer over the right line of the column heading, such as A or D.)
The mouse pointer turns into a two-way pointing arrow.
2. Hold down the left mouse button and drag (move) the mouse. Excel resizes your row or column.
3. Release the left mouse button when you’re happy with the size of your row or column.
Typing the size of rows and columns
If you need to resize a row or column to a precise value, it’s easier to type a specific value into the Row Height or Column Width dialog box instead. To type a value into a Row Height or Column Width dialog box, follow these steps:
1. Click the Home tab.
2. Click the row or column heading that you want to resize. Excel highlights your entire row or column.
3. Click the Format icon that appears in the Cells group. A pull-down menu appears.
4. Click Height (if you selected a row) or Width (if you selected a column).
5. Type a value and then click OK.
Excel resizes your row or column. Excel measures column width in characters. (A cell defined as 1 character width can display a single letter or number.) Excel measures row height by points where 1 point equals 1⁄72 inch.
Adding and deleting rows and columns
After you type in labels, numbers, and formulas, you may suddenly realize that you need to add or delete extra rows or columns. To add a row or column, follow these steps:
1. Click the Home tab.
2. Click the row or column heading where you want to add another row or column.
3. Click the Insert icon in the Cells group.
Inserting a row adds a new row above the selected row. Inserting a column adds a new column to the left of the selected column. To delete a row or column, follow these steps:
1. Click the Home tab.
2. Click the row or column heading that you want to delete.
3. Click the Delete icon in the Cells group. Deleting a row or column deletes any data stored in that row or column. Adding sheets For greater flexibility, Excel lets you create individual spreadsheets that you can save in a single workbook (file). When you load Excel, it automatically provides you with three sheets, but you can add more if you need them.
To add a new sheet, choose one of the following:
Click the Insert Worksheet icon. Click the Home tab, click the downward-pointing arrow next to the Insert icon in the Cells group, and then choose Insert Sheet.
Renaming sheets
By default, Excel gives each sheet a generic name such as Sheet1. To give your sheets a more descriptive name, follow these steps:
1. Choose one of the following:
• Double-click the sheet tab that you want to rename. Excel highlights the entire sheet name.
• Click the sheet tab you want to rename, click the Home tab, click the Format icon in the Cells group, and choose Rename Sheet.
• Right-click the sheet tab you want to rename; when a pop-up menu appears, choose Rename.
2. Type a new name for your sheet and press Enter when you’re done.
Rearranging sheets
You can rearrange the order that your sheets appear in your workbook. To rearrange a sheet, follow these steps:
1. Move the mouse pointer over the sheet tab that you want to move.
2. Hold down the left mouse button and drag (move) the mouse. The downward-pointing black arrow points where Excel will place your sheet.
3. Release the left mouse button to place your sheet in a new order.
Deleting a sheet
Using multiple sheets may be handy, but you may want to delete a sheet if you don’t need it. If you delete a sheet, you also delete all the data stored on that sheet. To delete a sheet, follow these steps:
1. Choose one of the following:
• Right-click the tab of the sheet you want to delete. When a pop-up menu appears, click Delete.
• Click the Home tab, click the downward-pointing arrow that appears to the right of the Delete icon in the Cells group, and choose Delete Sheet.
If your sheet is empty, Excel deletes the sheet right away. If your sheet contains data, a dialog box appears to warn you that you’ll lose any data stored on that sheet.
2. Click Delete.
Excel deletes your sheet along with any data on it.
Clearing Data
After you create a spreadsheet, you may need to delete data, formulas, or just the formatting that defines the appearance of your data. To clear out one or more cells of data, formatting, or both data and formatting, follow these steps:
1. Click the Home tab.
2. Select the cell or cells that contain the data you want to clear.
3. Click the downward-pointing arrow to the right of the Clear icon in the Editing group.
4. Choose one of the following:
• Clear All: Deletes the data and any formatting applied to that cell or cells
• Clear Formats: Leaves the data in the cell but strips away any formatting
• Clear Contents: Leaves the formatting in the cell but deletes the data
• Clear Comments: Leaves data and formatting but deletes any comments added to the cell
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
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 ...
2. 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....
3. 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: • ...
4. 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...
5. 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 ...
6. 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...
7. 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. (...
8. Creating WordArt using Office 2007
Making Text Look Artistic To spice up the appearance of individual paragraphs, Word lets you add drop caps, text boxes, or WordArt. Drop caps make the first letter of a paragraph appear huge. WordArt displays text as graphical images. Text boxes let you display chunks of text in separate boxes that you can arrange anywhere in your document. Creating drop caps To create a drop cap, follow these steps: 1. Click the Insert tab. ...
9. Printing in Microsoft Office 2007
Previewing a Document before Printing Before you print your document, you may want to preview how it will look so you don’t waste paper printing something you can’t use anyway. After you see that your pages will look perfect, then you can finally print out your document for everyone to read. Defining page size and orientation If you need to print your documents on different sizes of paper, you may need to define the page size and paper orientation. By doing this, Word ...