KEYBOARD SHORTCUTS - 1

Key board shortcuts using Ctrl Key and the Alphabets.


Ctrl+A     To select the data area.(First position the  cursor inside data area)
Ctrl+B     To change entry into Bold Font
Ctrl+C     Copy selection
Ctrl+D     Fill copied data/format, in the cells below.(First select the cell with data and the empty cells below)
Ctrl+F     Find entered value
Ctrl+G     Go to menu dialog box
Ctrl+H     Paste value
Ctrl+I     Change font to Italic
Ctrl+K     Add hyperlink
Ctrl+L     Display create table dialog box                 
Ctrl+N     Open new file(workbook).
Ctrl+O     Open existing file dialog box
Ctrl+P     Print menu
Ctrl+R     Fill copied data,in the cells to the right.(First select the cell with data and the empty cells on the right.)
Ctrl+S     Save file
Ctrl+T     Open tool option
Ctrl+U     Underline selection
Ctrl+V     Paste Value
Ctrl+W     Close file
Ctrl+X     Cut selection
Ctrl+Y     Redo last command
Ctrl+W     Close file
Ctrl+Z     Undo last command


A sample set of different combination of the above commands, used in Excel, is given below: 

a) To change font to Bold/Italic/Underlined:

Select data area using Ctrl+A, then Ctrl+B or Ctrl+I or Ctrl +U.

b) To add border area to data:
Select data area using Ctrl+A, then Border with mouse click.

c) To add back ground colour:
Select data area using Ctrl+A, then Colour Bucket, choose desired colour using mouse cLick. 

d) To copy and paste data:

Select required data, press Ctrl+C to copy, move to another cell press Ctrl+V to paste.

e) To cut and paste data:

Select required data, press Ctrl+X to cut, move to another cell press Ctrl+V to paste.

f) To open/close file:
Press Ctrl+N to open a new work book, Ctrl+O to open a existing workbook and Ctrl+W to close the workbook.

g) To do and undo commands:

Select data in a cell. Press Del to delete data, press Ctrl+Z to undo and later, Ctrl+Y to redo.

h) To find and replace data:
Enter Bangalore in an Excel file in different cells. go to the top left corner by pressing Ctrl+Home key.
Press Ctrl+F to open find dialog box and enter Bangalore. Press Ctrl+H to enter the new place as Bengaluru. Select find and replace all.

i) Let us say you have different files which you use on a daily basis which are stored in different folder or drives.We can have an excel file in which we can store the file name in column 1 and the corresponding hyperlink in column 2.
Add the file names in column 1. Against each file name go to column 2  and press Ctrl+K which will open the hyperlink dialog box. Go to location where the particular file is located and click on it. Its hyperlink will appear in column 2. Repeat same procedure for all files. A sample file is  shown below.

j) To open print menu :
Press Ctrl+P.

k) To open Tool option :
Press Ctrl+T