useful keyboard shortcuts in Excel 2010

More useful keyboard shortcuts in Excel 2010 Key combination	Action
Worksheet navigation
PgUp / PgDn	Move one screen up / down
Alt-PgUp / Alt-PgDn	Move one screen to the left / right
Ctrl-PgUp / Ctrl-PgDn	Move one worksheet tab to the left / right
Tab	Move to the next cell to the right
Shift-Tab	Move to the cell to the left
Home	Move to the beginning of a row
Ctrl-Home	Move to the beginning of a worksheet
Ctrl-End	Move to the last cell that has content in it
Ctrl-Left arrow	Move to the word to the left while in a cell
Ctrl-Right arrow	Move to the word to the right while in a cell
Ctrl-G or F5	Display the Go To dialog box
F6	Switch between the worksheet, the Ribbon, the task pane and Zoom controls
Ctrl-F6	If more than one worksheet is open, switch to the next one
Working with data
Shift-Spacebar	Select a row
Ctrl-Spacebar	Select a column
Ctrl-A or Ctrl-Shift-Spacebar	Select an entire worksheet
Shift-Arrow key	Extend selection by a single cell
Shift-PgDn / Shift-PgUp	Extend selection down one screen / up one screen
Shift-Home	Extend selection to the beginning of a row
Ctrl-Shift-Home	Extend selection to the beginning of the worksheet
Ctrl-C	Copy cell's contents to the clipboard
Ctrl-X	Copy and delete cell's contents
Ctrl-V	Paste from the clipboard into a cell
Ctrl-Alt-V	Display the Paste Special dialog box
Enter	Finish entering data in a cell and move to the next cell down
Shift-Enter	Finish entering data in a cell and move to the next cell up
Esc	Cancel your entry in a cell
Ctrl-;	Insert the current date
Ctrl-Shift-;	Insert the current time
Ctrl-K	Insert a hyperlink

Inserting Page Numbers into ms-word

How to Insert page numbers in ms-word?
How to Format Page numbers in ms-word?
How to start page numbers particular page?
If you want to know about all these Information Just Read this article...

PC Trouble Shooting

Fix Windows Registry and improve other system areas

It's inevitable: after using your computer for a long period of time, it becomes slower and unresponsive, until it eventually freezes up.
Luckily there's a tool to improve this situation and restore the system's speed and performance, and it's called PC Tools Registry Mechanic. Despite its name, this program does much more than just cleaning, defragmenting and fixing the Windows Registry. It also tunes up services, optimizes the system, monitors current performance and manages other core elements.
PC Tools Registry Mechanic features a nicely designed, colorful interface where you can access all the program's tools, conveniently divided into three main categories: Optimize, Monitor and Windows tools – as well as Help Center and Options. All tools are pretty self-explanatory, but in case you're not sure about how to use any of them, you can access the program's detailed documentation.
On the downside, I was a bit disappointed when I realize you can't fix all of your Registry issues in the trial version, and also when I saw that most Windows tools in PC Tools Registry Mechanic were actually built-in system tools.
PC Tools Registry Mechanic is a complete system optimization tool that not only cleans Windows Registry, but also enables you to optimize other elements on your system.

How to Make a Folded Booklet in Microsoft Office 2003

Create Folded Booklet in Ms-Office 2003



In this Video You can Learn to Create Booklet or Folded Book Let
It is Very Easy to Create you Booklet at Your Home Very Easily.

How to Mail Merge in Microsoft Word Step by Step Process with Pictures

Microsoft Word 2003

Mail Merge Wizard: An Overview

The Mail Merge Wizard takes you step-by-step through the process of creating merged documents. It is always available and easily accessible in the task pane. At each step, options will help you to tailor the merge to your needs. This document describes each step in general and the options available. At any point while using the wizard, you can go back to a previous step to adjust your choices.
NOTE: This document uses the example creating a Mail Merge letter.

Anu Telugu Typing Software Free Download and Video Tutorial to Type Telugu Fonts in Ms-word and Pagemaker

Telugu Typing AnuScript Manager Tutorial in Telugu



You can Type Telugu in Ms-word and Pagemaker by using This Anuscirpt manager. This anu script has roma, apple, DOE, modular and all.

Making A Certificate With Word 2003  

By watching this video you can create Certificate by using ms word 2003

Microsoft Equation Editor

Microsoft Equation Editor is one of the Best useful software for typing math Question papers, books, and Chemistry formulas you can use Microsoft Equation Editor to type math formulas very easily.
Its very Easy you can Learn How to Type Math Formulas by using this software in Ms-word 2003 Just Play this video. By watching this video you can understand very easily.

Equation Editor in MS Word 2003

Watch this Video Tutorial for Inserting Math's and Chemistry equations into ms word document.
in order to insert equations into ms word document you have install Microsoft equation 3.0 or Microsoft Equation 4.0 in your system. or use any third party plugins like Math type. etc.,

Just Watch this Video to learn How to Insert Math Formulas into your ms word document.

Microsoft Word 2003 Styles and Formatting 

 

how-to Insert Page number, Date, Symbol, headers and Footers, Spell check, How-to use Right click on selection

how-to Insert Page number, Date, Symbol, headers and Footers, Spell check, How-to use Right click on selection

MS Word Tutorial - How To Insert Picture In Resume

How To Insert Picture in Resume

Create a Resume in Word 2003

Create a Resume in Word 2003

Insert Clip art, Picture. Add line, paragraph border and Page border

Insert Clip art, Picture. Add line, paragraph border and Page border

DEFINE STGPOOL (Define a storage pool)

DEFINE STGPOOL (Define a storage pool)

 Use this command to define a primary storage pool, copy storage pool,

or an active-data pool. A primary storage pool provides a destination

for backup files, archive files, or files migrated from client nodes. A

copy storage pool provides a destination for backup copies of files that

are in primary storage pools. An active-data pool provides a destination

for active versions of backup data that are in primary storage pools.

All volumes in a storage pool belong to the same device class. Random

access storage pools use the DISK device type. After you define a random

access storage pool, you must define volumes for the pool to create

storage space.

Sequential access storage pools use device classes that you define for

tape devices, optical devices, files on disk (FILE device type), and

storage on another server (SERVER device type). To create storage space

in a sequential access storage pool, you must allow scratch volumes for

the pool when you define or update it, or define volumes for the pool

after you define the pool. You can also do both.

The DEFINE STGPOOL command takes four forms:

*  Defining a primary storage pool assigned to random access devices

*  Defining a primary storage pool assigned to sequential access devices

*  Defining a copy storage pool (always assigned to sequential access

   devices)

*  Defining an active-data pool (always assigned to sequential access

   devices)

 The syntax and parameters for each form are defined separately.

CANCEL EXPIRATION (Cancel an expiration process)

CANCEL EXPIRATION (Cancel an expiration process)

Use this command to cancel a process that is running as a result of an

inventory expiration operation.

 

Privilege class

To issue this command, you must have system privilege.

 

Syntax

>>-CANcel EXPIration-------------------------------------------><

 

Examples

Task

Cancel the process that was generated by an inventory expiration

operation.

Command  cancel expiration

Restoring a database to a point-in-time -- volume history file unavailable

Restoring a database to a point-in-time -- volume history file unavailable

If the volume history file is unavailable, you can use one or more

DSMSERV RESTORE DB commands to restore the database to a specific point

in time. A device configuration file with the applicable device

information must also be available, or you must manually create one.

For example, to load a full backup and one or more incremental backups,

issue a DSMSERV RESTORE DB command for the full backup and an additional

DSMSERV RESTORE DB command for each incremental backup. When you use

multiple DSMSERV RESTORE DB commands, specify COMMIT=NO for each command

except the last one. For the last command, specify COMMIT=YES. The

database remains in an inconsistent and unusable state until you issue a

DSMSERV RESTORE DB command with a COMMIT=YES.

To manually create a device configuration file with the applicable

device information (library, drive, and device class definitions) see

the Administrator's Guide).

Full and incremental database backups or snapshot database backups can

be used to restore a database to a point in time.

To restore the database using snapshot backup volumes, you must:

1. Specify all the volume names for the same snapshot backup series

2. List the volumes in the sequence in which the backup was written

3. Specify COMMIT=YES

Note:

      1. If you issue a DSMSERV RESTORE DB command with COMMIT=NO, and

         you decide not to load another incremental backup, reissue the

         last DSMSERV RESTORE DB command with COMMIT=YES.

      2. If you issue a DSMSERV RESTORE DB command with COMMIT=YES, and

         you decide to load an additional incremental backup, reissue

         all the DSMSERV RESTORE DB commands in order with COMMIT=NO on

         each. Then, enter any additional DSMSERV RESTORE DB commands,

         with COMMIT=YES on the last one.

Syntax

>>-DSMSERV RESTORE DB--DEVclass--=--device_class_name----------->

                     .-,-----------.     

                     V             |     

>--VOLumenames--=--+--volume_name-+-+------------------------>

                   '-FILE:--file_name-'  

   .-COMMIT--=--No------.  

>--+-------------------+-------------------------------------><

   '-COMMIT--=--+No--+'  

                '-Yes-'    

Parameters

DEVclass (Required)

   Specifies the name of the sequential access device class to use. The

   device class must be defined in a device configuration file. If a

   device configuration file is not available, you can manually create

   one (see the Administrator's Guide).

   Note:

         1. You cannot use a device class with a device type of NAS.

         2. A restore database operation fails if the source for the

            restore is a FILE library. A FILE library is created if the

            device class specifies SHARED=YES.

VOLumenames (Required)

   Specifies the backup volumes to use to restore the database. Possible

   values are:

   volume_name

      Specifies the names of the volumes. To specify multiple volumes,

      separate the names with commas and without intervening spaces.

      List the volumes in the order in which they were written.

   FILE:file_name

      Specifies the name of a file that contains a list of the volumes.

      Enter the volumes in the order in which they were written with

      each name on a separate line.

COMMIT

   Specifies whether this is the last restore command needed to restore

   the database. This parameter is optional. The default value is NO.

   Possible values are:

   No

      Specifies that you will issue one or more additional DSMSERV

      RESTORE DB commands.

   Yes

      Specifies that this is the last restore command to restore the

      database.

Examples

Task 1

Restore the database to the time of its most recent incremental backup.

The volume history file is not available. Tape volumes FULL1, FULL2,

INCR1, and INCR2 contain the database backup series.

Commands

dsmserv restore db devclass=tape volumenames=full1,full2 commit=no

dsmserv restore db devclass=tape volumenames=incr1 commit=no

dsmserv restore db devclass=tape volumenames=incr2 commit=yes

Task 2

Restore a database to the time of its most recent snapshot backup. The

volume history file is not available. Tape volumes TAPE01 and TAPE02 are

snapshot volume names in a volume sequence that spans two tapes.

Command

dsmserv restore db devclass=8MM volumenames=tape01,tape01 commit=yes

BACKUP DB (Back up the database)

BACKUP DB (Back up the database)

Use this command to back up a Tivoli Storage Manager database to

sequential access volumes.

To determine how much additional storage space a backup will require,

use the QUERY DB command. That command displays the database pages, in

megabytes, that have changed since the last backup.

Privilege class

To issue this command, you must have system privilege or unrestricted

storage privilege.

Syntax

>>-BAckup DB--DEVclass--=--device_class_name-------------------->

   .-Type--=--Incremental-----.  

>--+--------------------------+--------------------------------->

   '-Type--=--+-Incremental-+-'  

              +-Full--------+    

              '-DBSnapshot--'    

>--+-------------------------------------+---------------------->

   |                   .-,-----------.   |  

   |                   V             |   |  

   '-VOLumenames--=--+---volume_name-+-+-'  

                     '-FILE: file_name-'    

   .-Scratch--=--Yes-----.  .-Wait--=--No------.  

>--+---------------------+--+------------------+---------------><

   '-Scratch--=--+-Yes-+-'  '-Wait--=--+-No--+-'  

                 '-No--'               '-Yes-'    

Parameters

DEVclass (Required)

   Specifies the name of the sequential access device class to use for

   the backup.

   Note:

         1. You cannot use a device class with a device type of NAS or

            CENTERA.

         2. A restore database operation will fail if the source for the

            restore is a FILE library. A FILE library is created if the

            FILE device class specifies SHARED=YES.

   

   If all drives for this device class are busy when the backup runs,

   Tivoli Storage Manager cancels lower priority operations, such as

   reclamation, to make a drive available for the backup.

Type

   Specifies the type of backup to run. This parameter is optional. The

   default is INCREMENTAL. Possible values are:

   Incremental

      Specifies that you want to run an incremental backup of the Tivoli

      Storage Manager database. The maximum number of incremental

      backups you can run between full backups is 32.

   Full

      Specifies that you want to run a full backup of the Tivoli Storage

      Manager database.

   DBSnapshot

      Specifies that you want to run a full snapshot database backup.

      The entire contents of a database are copied and a new snapshot

      database backup is created without interrupting the existing full

      and incremental backup series for the database.

VOLumenames

   

   Specifies the volumes used to back up the database. This parameter is

   optional. However, if you specify SCRATCH=NO, you must specify a list

   of volumes.

   

   volume_name

      Specifies the volumes used to back up the database. Specify

      multiple volumes by separating the names with commas and no

      intervening spaces.

   FILE:filename

      Specifies the name of a file that contains a list of volumes used

      to back up the database. Each volume name must be on a separate

      line. Blank lines and comment lines, which begin with an asterisk,

      are ignored.

      For example, to use volumes DB0001, DB0002, and DB0003, create a

      file named TAPEVOL.DATA that contains these lines:

      DB0001

      DB0002

      DB0003

      

      You can then specify the volumes for the command as follows:

      VOLUMENAMES=FILE:TAPEVOL.DATA

Scratch

   Specifies whether scratch volumes can be used for the backup. This

   parameter is optional. The default is YES. Possible values are:

   Yes

      Specifies that scratch volumes can be used.

      If you specify SCRATCH=YES and the VOLUMENAMES parameter, Tivoli

      Storage Manager will only use scratch volumes if space is

      unavailable on the specified volumes.

      

      If you do not include a list of volumes by using the VOLUMENAMES

      parameter, you must either specify SCRATCH=YES or use the default.

   No

      Specifies that scratch volumes cannot be used.

      If you specify volumes by using the VOLUMENAMES parameter and

      SCRATCH=NO, the backup will fail if there is not enough space

      available to store the backup data on the specified volumes.

Wait

   Specifies whether to wait for the server to complete processing this

   command in the foreground. The default is NO. Possible values are:

   No

      Specifies that the server processes this command in the

      background. You can continue with other tasks while the command is

      being processed. Messages created from the background process are

      displayed either in the activity log or the server console,

      depending on where messages are logged.

      To cancel a background process, use the CANCEL PROCESS command. If

      a BACKUP DB background process is canceled, some of the database

      may have already been backed up before the cancellation.

   Yes

      Specifies that the server processes this command in the

      foreground. Wait for the command to complete before continuing

      with other tasks. The server then displays the output messages to

      the administrative client when the command completes.

      Note: You cannot specify Wait=Yes from the server console.

 

Examples

Task

Run an incremental backup of the database using a scratch volume. Assume

a device class of FILE for the backup.

Command  backup db devclass=file type=incremental

Word 2003 Viewing Normal Print Layout, Format Font, Format Paragraph, Bullets - Numbering, Tabs (indentation), Print Preview, Print, Page Setup

Word 2003 Viewing Normal Print Layout, Format Font, Format Paragraph, Bullets - Numbering, Tabs (indentation), Print Preview, Print, Page Setup

MS-Word 2003 Cut, Copy and Paste, and Working with Fonts

MS-Word 2003 Cut, Copy, Paste and Working with Formatting bar

Selecting Text in Ms-Word

If you want to Select Text in Ms-Word

1. Keep the cursor Starting point of the Selection.
2. Press and Hold the Shift Key and Click End of the Selection Point.

 Or

If you Press F8 Key 2 Times One Word will be Selected

If you Press F8 Key 3 Times One Sentence will be Selected

If you Press F8 key 4 Times One Paragraph will be Selected

If you Press F8 Key 5 Times Select whole Document.

Or

You can Select Text By Dragging the Mouse Pointer in the Left Margin, It selects line by line.

Or

You can Select Text by Pressing Ctrl + A to Select Whole Document

Or

Press and Hold the Shift Key and press the Right / Left / Up / Down You can Notice that highlighting the Text.

Or

Press and Hold Ctrl +Shift + Any Arrow Keys

Press and Hold the Ctrl +Shift +Right Arrow you can Select One word  by word .

Or

If you double click on any word one word will be selected

Ms-Word Notes and Keyboard Shortcuts Download

Ms-Word Notes and Presentation


 


Ms-Word Keyboard Short Cut Keys





Do You Want to Download Above  MS-Word Keyboard Short Keys Click on Following Download Link

Download

Ms-Word Keyboard Short Cut Keys

MS-Word Keyboard Short Cut Keys

COMMANDS	SHORT CUT
All Caps	Ctrl + Shift + A
All minimize	Windows + M, D
All Select	Ctrl + A
Annotation	Alt + Ctrl + M
Application maximize	Alt + F10
Application Restore	Alt + F5
Apply heading1	Alt + Ctrl + 1
Apply heading2	Alt + Ctrl + 2
Apply heading3	Alt + Ctrl + 3
Apply list Bullet	Ctrl + Shift + L
Auto Format	Alt + Ctrl + K
Auto Text	F3
Auto Text	Alt + Ctrl + V
Bold	Ctrl + Shift + B
Bold (same press remove)	Ctrl + B
Bookmark	Ctrl + Shift + F5
Browse Next	Ctrl + Page Down
Browse Previous	Ctrl + Page Up
Cancel	Escape
Cap/small/initial letters	Shift + F3
Center Para	Ctrl + E
Change Case	Shift + F3
Char Left	Left
Char Left Extend	Shift + Left
Char Right	Right
Char Right Extend	Shift + Right
Clear	Del
Close or Exit	Alt + F4
Close pane	Alt + shift + C
Close the file	Alt + Space + C
Column Break	Ctrl + Shift + Return
Column Select	Ctrl + Shift + F8
Complete close windows	Alt + F4
Copy	Ctrl + C
Copy Format	Ctrl + Shift + C
Copy Text	Shift + F2
Create AutoText	Alt + F3
Cut	Shift + Del
Cut	Ctrl + X
Delete Back Word	Ctrl + Backspace
Delete Word	Ctrl + Del
Dictionary	Alt + Shift + F7
Do Field Click	Alt + Shift + F9
Document Close	Ctrl + F4
Document Maximize	Ctrl + F10
Document Move	Ctrl + F7
Document Restore	Ctrl + F5
Document Size	Ctrl + F8
Document Split	Alt + Ctrl + S
Double Underline	Ctrl + Shift + D
Down first letter	Ctrl + End
End of Column	Alt + Shift + Page Down
End of Document	Ctrl + End
End of Line	End
End of Line Extend	Shift + End
End of Row	Alt + End
End of Row	Alt + Shift + End
End of Window	Alt + Ctrl + Page Down
End of Window Extend	Alt + Ctrl + Shift + Page Down
Endnote Now	Alt + Ctrl + D
Enlarge the size	Ctrl + F2
Explore	Windows + E
Extend Selection	F8
Field Chars	Ctrl + F9
Field Codes	Alt + F9
Find	Ctrl + F
Find folder (my)	F12
Folder rename	F2
Font	Ctrl + D
Font	Ctrl + Shift + F
Font note Now	Alt + Ctrl + F
Font Size Select	Ctrl + Shift + P
Go Back	Alt + Ctrl + Z
Go index	Alt + Shift + Tab
Go To	Ctrl + G
Go to the start last doc	Ctrl + M
Grow Font	Ctrl + Shift
Grow Font One Point	Ctrl + ]
Hanging Indent	Ctrl + T
Header Footer Link	Alt + Shift + R
Help	F1
Hidden	Ctrl + Shift + H
Hyperlink	Ctrl + K
Indent	Ctrl + M
Italic	Ctrl + I
Italic	Ctrl + Shift + I
Justify Para	Ctrl + J
Last file save the folder	Alt + F + A
Leave 1 space	Space Bar
Leave 5 space	Tab
Left Para	Ctrl + L
Line Down	Down
Line Down Extend	Shift + Down
Line end	End
Line first	Home
Line Up	UP
Line Up Extend	Shift + Up
Log off	Alt + Ctrl + Del
Macro	Alt + F8
Mail Merge Check	Alt + Shift + K
Mail Merge Edit Data Source	Alt + Shift + E
Mail Merge to Document	Alt + Shift + N
Mail Merge to Printer	Alt + Shift + M
Mark Citation	Alt + Shift + I
Mark Index Entry	Alt + Shift + X
Mark Table of Contents Entry	Alt + Shift + O
Maximize	Windows + D
Menu Mode	F10
Minimize	Windows + D
Minimize or maximize index	Alt + Space
Minimize the file	Alt + Space + N
Move Text	F2
New (open file menu)	Alt + F
New document	Ctrl + N
Only one select	Ctrl + Shift
Open that	Alt + F, Q
Open the file	Ctrl + O
Open the file	Alt + tab
Open the folder	Alt + _ (Under line)
Open the meaning	Right Windows next key
Open the tool menu	Alt + T
Open menu	Alt + E
Over writing	Insert
Page down	Page Down
Page up	Page Up
Paste	Ctrl + V
Print	Ctrl + p
Redo	Ctrl + y
Recovery data	Ctrl + Z
Rename	Select-F2
Repeat Find	Shift + F4
Repeat Find	Alt + Ctrl + y
Replace	Ctrl + H
Reset Char	Ctrl + Space
Reset Char	Ctrl + Shift + Z
Reset Para	Ctrl + Q
Revision Marks Toggle	Ctrl + Shift + E
Right Para	Ctrl + R
Save	Ctrl + S
Save	Shift + F12
Save	Alt + Shift + F2
Save As	F12
Scroll lock, num lock, cap lock	Lights on
Search	Alt + A
Select All	Ctrl + A
Select All	Ctrl + Num5
Show All	Ctrl + Shift + 8
Show All Headings	Alt + Shift + A
Show Heading1	Alt + Shift + 1
Show Heading2	Alt + Shift + 2
Show Heading3	Alt + Shift + 3
Show Heading4	Alt + Shift + 4
Show Heading5	Alt + Shift + 5
Show Heading6	Alt + Shift + 6
Show Heading7	Alt + Shift + 7
Show Heading8	Alt + Shift + 8
Show Heading9	Alt + Shift + 9
Shrink Font One Point	Ctrl + [
Shrink Selection	Shift + F8
Small Caps	Ctrl + Shift + K
Space Para1	Ctrl + 1
Space Para1.5	Ctrl + 5
Space Para2	Ctrl + 2
Spelling and check the grammar	F7
Spike	Ctrl + Shift + F3
Spike	Ctrl + F3
Start of Windows	Alt + Ctrl + Page Up
Start Window Extend	Alt + Ctrl + Shift + Page Up
Style	Ctrl + Shift + S
Subscript	Ctrl + =
Superscript	Ctrl + Shift + =
Symbol Font	Ctrl + Shift + Q
That file close	Alt + F + C
Thesaurus	Shift + F7
Time Field	Alt + Shift + T
To decrease font	Ctrl + Shift + <
To escape exiting operations	Esc
To find	Ctrl + F
To find and replace	Ctrl + H
To increase font	Ctrl + Shift + >
Tool	Shift + F1
Top first letter	Ctrl + Home
Un Hang	Ctrl + Shift + T
Un Indent	Ctrl + Shift + M
Underline(same press remove)	ctrl + U
Window word, calc	Start-Run-Calc
Windows explorer	Windows + E
Word count	Alt + T + W