Tuesday, February 1, 2011

Microsoft Excel 2003-Excel around how to find

Open Excel

There are several ways, depending on whether you open an existing workbook or new workbook to open the Excel workbook.

Open Excel from the start menu

Click Start on all programs > Excel (Office) on the desktop shortcut Microsoft Excel] to click.

Open an existing Excel workbook

My documents-books double / my computer window.

Excel screen

You could see the Excel task pane that appears to the right of the Excel screen depending on the settings of your computer.

Also change the default settings into a new workbook that included 2 toolbars at the top of the blank worksheet 3 and screen display; On the standard and Formatting toolbars.


Includes all Microsoft Office products that contains the command to tell the program to worksheet toolbar and menu to what to do.

Microsoft Office standard menu:
File edit view tool help

Add Excel menu
Format Table pane

From the menu's access to commands
Click the desired command (to view all commands must click), click the menu name


Is another way to access commands on toolbars. (Icon) button on the toolbar represents another command. Clicking these buttons, the command is executed.

Shortcut key

To run the command by using the keyboard and mouse rather than shortcut keys, menus and toolbars. Use these keyboard shortcuts only problem can work much faster Excel keyboard shortcuts have saved!

Useful shortcut keys

In Excel Mobile

CTRL + end-go to end of the work area
Press and hold down the CTRL key to cell A1 back home
On the screen before going on the page
Page down - down following screen
ALT + page up-before you go left of the screen
ALT + page down-then the right of the screen
CTRL + down arrow-at the bottom of the range / spreadsheets
CTRL + arrow-at the top of the range / spreadsheets
CTRL + arrow right-to go to right-most range / spreadsheets
CTRL + arrow left-in the range to go with left / spreadsheets
CTRL + Page Up-go previous spreadsheet
Page down-go: spreadsheet

Selecting data

CTRL-select multiple individual cells.
Click + Shift +-click a selected range of cells
Click + Shift + arrow-selected range of cells
CTRL + SHIFT + end-the rest of the selection work area
CTRL key + *-select the current region.
CTRL + a select spreadsheet

Work in the formula bar

ALT + Enter-in a new row

Other useful keyboard shortcuts

CTRL + o – open book
CTRL + s-save
CTRL + p-print workbook
CTRL + x cut selection
CTRL + c-copy selection
CTRL + v-paste selection
CTRL + z-undo the last action

Save the workbook.

It is important to save your work regularly technical obstacles are lost through working with computer files or data. Also the file again the computer as well as the acquisition of easily is important to save if the stumbling block for an appropriate location.

(Just as well as at the end) you can save at any point in the book. Therefore it is recommended to save the file is always created.

To save the workbook.
Go to file > (e.g. to select a folder for storing spreadsheet. Enter the name of the workbook. Click the Save...

Difference between the 'save', 'Save As'?
Save-save on the file i.e., the current update the source workbook. The workbook is saved only this dialog box is open for the first time.

As. save the's be able to change the location of the file to create a copy of the file name or the original workbook. Choose the Save command whenever save as] dialog box opens.

Saved on your computer if you use any sort of document, click the Save button, click every few minutes to a technical fault in the latest version of the document has to be like.

To close a workbook

You can open one or more Windows users to applications at one time. In your application to one or more documents open at any given time, users close workbook for can, in some ways.

When you close Microsoft application has three basic options.
In other words, close the Excel application to close the Excel's, and remains in the current workbook open Excel will close all open workbooks

At the bottom of the file] is the exit command in the menu. To select it, and closes all open workbooks and Excel. Towards the beginning of the file, close menu command. When you select this in the current workbook is closed.

Don't need exit one if you want to close all the open workbook, Excel opens the keep. Press the SHIFT key, open the file menu. All notifications are close approaches.

Article written by:

Penny Buckwell
Owner, EasyPC training
Brisbane, Australia

Of the non Microsoft and computer software training providers.

No comments: