Please style sheet are not equal in internet explorer browser Firefox, Chrome, Safari, Apple and Opera browser please visit this website.

Thank for Visit My Site and Please sent me Shayari, Status and Quotes post request.

Microsoft Excel 2007 - Moving Around in a Worksheet, Make a Start with Excel, Modifying a Worksheet

Moving Around in a Worksheet
 
Excel Rows,Columns,Cells
 
When you begin a new workbook, the "active cell" is located at the top-left corner of the worksheet (in Cell A1). To create your worksheet or make changes to it, you must move around in it. Getting around in a worksheet quickly is the mark of an experienced Excel user. You want to learn the quickest way to get from place to place so you can use your time more efficiently.
 
Keyboard Shortcuts for Moving Around in a Worksheet
 
You can move around in the worksheet by pressing the arrow keys and other direction keys on the keyboard. When you use the keyboard to move around in the worksheet, you move the location of the active cell. You then begin adding or editing the contents of the active cell.
 
. Left arrow: One cell to the left

. Right arrow: One cell to the right

. Up arrow: Up one row

. Down arrow: Down one row

. Home: The cell in column A of the current row

. Page Up: Up one screen Page Down Down one screen

. Ctrl+Home: Cell A1

. Ctrl+End: The cell at the intersection of the right-most column and the bottom-most used row (the lower-right corner of your work area)

. Ctrl+arrow key: Jump to the end of a series of blank or nonblank cells in a given direction
 
Use the Scroll Bar
 
You can also use the mouse to click or drag the scroll bars to view different parts of a worksheet. If your mouse has a wheel button, you can also use it to scroll through the document. Rotate away from you to scroll up; rotate toward you to scroll down.
 
The difference between using the keyboard and the scroll bars is that when you use the keyboard, you are moving the active cell. On the other hand, using the mouse to scroll up or down in the worksheet merely changes the view. You must click the mouse in the worksheet to move the active cell.
 
Moving to a Specific Cell
 
To jump directly to a specific cell, click the Name box on the left side of the formula bar, and type the cell address (that is, its column letter and row number, such as A1 or B6) and press Enter. As soon as you press Enter, the Excel screen displays that cell (and the ones near it) and makes it the active cell.
 
Moving to Other Worksheets
 
Workbooks typically contain three worksheets (although you can easily add or delete sheets which I'll cover in another article). To use or view a different worksheet, click the tab on the bottom of the worksheet. The tabs are labeled Sheet1, Sheet2, and Sheet3 until you rename them.
 
 
 
Make a Start with Excel
 
Starting a Work Book
 
To start Excel 2007 from the Start Menu
 
. Click on the Start button, point to All Programs then Microsoft Office and click on Microsoft Office Excel 2007.
 
img
 
. The first screen that you will see a new blank worksheet that contains grid of cells. This grid is the most important part of the Excel window. It's where you'll perform all your work, such as entering data, writing formulas, and reviewing the results.
 
img
 
Microsoft Excel 2007 Workbook and Worksheet
 
. A worksheet is the grid of cells where you can type the data. The grid divides your worksheet into rows and columns.

. Columns are identified with letters (A, B, C . ), while rows are identified with numbers (1, 2, 3 . ).

. A cell is identified by column and row. For example, B8 is the address of a cell in column B (the second column), and row 8 (the eighth row).

. A worksheet in Excel 2007 consists of 16,384 columns and over 1 million rows. The worksheets in turn are grouped together into a workbook.

. By default each workbook in Excel 2007 contains 3 blank worksheets, which are identified by tabs displaying along the bottom of your screen. By default the first worksheet is called Sheet1, the next is Sheet2 and so on as shown here.
 
img
 
 
 
 
Create a Workbook
 
To create a new Workbook:
 
. Click the Microsoft Office Button
. Click New
. Choose Blank Document
 
img
 
If you want to create a new document from a template, explore the templates and choose one that fits your needs.
 
img
 
 
 
 
Save a Workbook
 
When you save a workbook, you have two choices: Save or Save As.
 
To save a document:
. Click the Microsoft Office Button
. Click Save
 
img
 
You may need to use the Save As feature when you need to save a workbook under a different name or to save it for earlier versions of Excel. Remember that older versions of Excel will not be able to open an Excel 2007 worksheet unless you save it as an Excel 97-2003 Format. To use the Save As feature:
 
. Click the Microsoft Office Button
. Click Save As
. Type in the name for the Workbook
. In the Save as Type box, choose Excel 97-2003 Workbook
 
img
 
 
 
Open a Workbook
 
To open an existing workbook:
 
• Click the Microsoft Office Button
• Click Open
• Browse to the workbook
• Click the title of the workbook
• Click Open
 
img
 
 
 
How to Enter Text and Numbers in a Cell
 
To make a start with Excel 2007, we'll create this really simple spreadsheet:
 
img
 
All we're going to be doing here is entering some text and some numbers. We're not adding anything up yet.
 
Before you tackle this first exercise, though, you may want to take note of the Undo feature of Excel 2007, just in case you make a mistake. The Undo option is the left curved arrow, right at the top of your screen. This one:
 
img
 
Click the left curved arrow to Undo something, and click the right curved arrow to redo it.
 
So click inside of cell A1 on your spreadsheet, and do the following:
 
. Type the word "Numbers" (with no quotation marks)
. Hit the Enter key on your keyboard
. The active cell will move down one, to cell A2
. Type the number 3, and again hit the Enter key on your keyboard
. The active cell will move down one, to cell A3
. Now put the number 6 into cell A3, and the number 9 in cell A4
. After you have typed the number 9, and hit the Enter key, you should see that cell A5 is now the active cell
 
The text we entered in cell A1 is known as a Heading. It's there just to tell you what the numbers mean. Except our heading doesn't tell us a great deal. Let's change it to something else.
 
 
 
How to Edit Text in a Cell
 
To change the text in cell A1, you can just click inside of the cell and start typing. Anything you had there previously would be erased. But if you just want to edit the text (if you've made a spelling mistake, for example), then this is no good. If you want to keep most of the text, and just make minor changes, then you need to do something else.
 
In the image below, you can see what's known as the Formula Bar. The Formula Bar is like a long textbox that you can click inside and start typing.
 
img
 
To edit a Cell in Excel 2007, first click inside the cell you want to edit (A1 for us). Then click inside the formula bar. Notice where your cursor is now:
 
img
 
The image above shows that the cell A1 is active, but the cursor is inside of the formula bar.
 
With the cursor in the Formula Bar, try changing the text "Numbers" to "Add these Numbers". Press the Enter key when you've made the changes. Your spreadsheet should look like ours below:
 
img
 
Notice that the active cell is now A2, and that the Formula Bar has a 3 in it.
 
However, there's a problem. There's not enough room in cell A1 for our new text. Part of it seems to be in the B column.
 
The solution is to widen the whole of Column A. Try this:
 
. Move your mouse up to the start of the A Column
. The pointer will change shape and now be a black arrow
 
img
 
. When you see the new shape, hold down your left mouse button
. Keep the left mouse button held down, and drag your cross to the right
. Once you have all the text in the A column, let go of the left mouse button.
 
You can make the height of the Rows bigger or smaller by using exactly the same technique.
 
 
 
Centre Text and Numbers
 
You saw that by clicking inside of a cell it makes it active, so that you can make changes. We want to centre all our numbers and the text. Here's the spreadsheet we have:
 
img
 
So we need cells A1, A2, A3 and A4 to be active. In Excel 2007, you can do this by highlighting the cells.
 
. Place your mouse over cell A1
. Your pointer should now be in the shape of a white cross
. When your pointer changes to the white cross, hold your left mouse button down and drag to cell A4
. Let go of the left mouse button when cells A1, A2, A3 and A4 are highlighted
. The image below shows what you are aiming for
 
img
 
The cells highlighted in the image above have a different color to the normal white color of a cell. When you highlight cells, you can do things to all the cells as a group.
 
To centre the text and numbers in our highlighted cells, try this:
 
. From the Excel 2007 Ribbon at the top of the screen, locate the Alignment panel:
 
img
 
You can see the various alignment options laid out. These ones:
 
img
 
Hold your mouse over each alignment icon and you'll see an explanation of what they do. Click each icon and see what they do to your highlighted cells.
 
You can also click the arrow in the bottom right of the Alignment panel to bring up the Format Cells box (the one circled below).
 
img
 
When you click the arrow, you'll see this dialogue box:
 
img
 
Notice the Text Alignment section at the top of the Alignment tab. It has two drop down menus, one for Horizontal alignment and one for Vertical alignment.
 
. Click the arrow on the Horizontal drop down menu, the one with Left (Indent) on it
. You'll see the following:
 
img
 
As you can see, you have plenty of options to choose from in Excel 2007. But click on Center. Do the same for the Vertical drop down menu. Then click OK at the bottom of the Format Cells dialogue box.
 
The text and numbers in cells A1, A2, A3 and A4 should now be centered, and your spreadsheet will look like the one below:
 
img
 
 
 
 
Modifying a Worksheet
 
Insert New Cells, Rows, and Columns
 
To insert cells, rows, and columns in Excel:
 
. Place the cursor in the row below where you want the new row, or in the column to the left of where you want the new column

. Click the Insert button on the Cells group of the Home tab

. Click the appropriate choice: Cell, Row, or Column
 
img
 
 
 
Delete Cells, Rows and Columns
 
To delete cells, rows, and columns:
 
. Place the cursor in the cell, row, or column that you want to delete

. Click the Delete button on the Cells group of the Home tab

. Click the appropriate choice: Cell, Row, or Column
 
img
 
 
 
Find and Replace
 
To find data or find and replace data:
 
. Click the Find & Select button on the Editing group of the Home tab

. Choose Find or Replace

. Complete the Find What text box

. Click on Options for more search options
 
img
 
Go To Command
 
The Go To command takes you to a specific cell either by cell reference (the Column Letter and the Row Number) or cell name.
 
. Click the Find & Select button on the Editing group of the Home tab
. Click Go To
 
img
 
Spell Check
 
To check the spelling:
 
. On the Review tab click the Spelling button
 
img
 
 
 

SHARE THIS PAGE

0 Comments:

Post a Comment

Circle Me On Google Plus

Subject

Follow Us