Skip to main content

Microsoft Excel Shortcut Keys

By Unknown
The followings are Microsoft Excel shortcuts. 


Mouse shortcuts:

Shortcut
Description
Double-click (on a cell)
Edit the cell contents.
Double-click (on a row/column divider)
Adjust height/width to auto-fit
High-light headers of multiple rows/columns then Double-click on a row/column divider
Adjust height/width to auto-fit of all high-lighted rows/columns
Triple-click
Select the entire contents in the cell
Click on row/column divider then drag
Adjust height/width of the row/colunn
High-light headers of multiple rows/columns then Click on row/column divider then drag
Adjust height/width of the rows/colunns
Ctrl + Mouse wheel
Zooms in and out of document.
Hold Shift + Click the cells
Select multiple cells


Keyboard shortcuts:


Shortcut
Description
F2
Edit the selected cell.
F5
Goto a specific cell. For example, C6.
F7
Spell check selected text and/or document.
F11
Create chart.
Ctrl + A
Select all.
Ctrl + B
Bold.
Ctrl + C
Copy.
Ctrl + F
Find (same as Shift + F5).
Ctrl + G
Go To.
Ctrl + H
Replace.
Ctrl + I
Italic.
Ctrl + K
Insert link.
Ctrl + N
New Workbook.
Ctrl + O
Open Workbook.
Ctrl + P
Print dialog.
Ctrl + S
Save.
Ctrl + U
Underline.
Ctrl + V
Paste.
Ctrl + Z
Undo.
Ctrl + Y
Redo.
Ctrl + X
Cut.
Ctrl + 5
Strikethrough text.
Ctrl + F3
Define Name.
Ctrl + F4
Exit Excel.
Ctrl + F6
Switch between open workbooks.
Ctrl + F9
Minimize current window.
Ctrl + F10
Maximize current window.
Shift + F1
Activate Help on Item.
Shift + F2
Insert Comments
Shift + F3
Insert Function.
Ctrl + Shift + ;
Enter the current time.
Ctrl + ;
Enter the current date.
Ctrl + Page down
Move to next worksheet.
Ctrl + Page up
Move to previous worksheet.
Ctrl + Shift + #
Number Format: Date
Ctrl + Shift + @
Number Format: Time.
Ctrl + Shift + !
Number Format: Commas.
Ctrl + Shift + $
Number Format: Currency
Ctrl + Shift + %
Number Format: Percentage
Ctrl + Shift + ^
Number Format: Scientific.
Ctrl + Space
Select entire column.
Shift + Space
Select entire row.
Ctrl + (Arrow key)
Move to next section.


Labels:

Popular posts from this blog

End of Engineering and Begining of Web Raga

By Unknown
Finally my exams are over and here is the end of College Days. I don't know whether I will go for further studies or not, but surely I will try to do things out of the box.       We have started our work at e-Lightening Technologies and clients are just flowing to get their web presence. Definitely condition has been completely changed, two years back we used to convince each and every person coming to us why they should have a website for their business. But today people have agreed with this fact that if they want to be ahead of their competitors, they must have their online presence.  As far as this website is concerned, I have many plans. Soon we are going to hire 3 more Tech Bloggers to write for us. We are also going to have a seperate office for this website. We are now open for Guest Blogging. If you want to write for this website, please contact us using the contact form available on contact us page . From 14th June 2012, we will be p...
Read More

Recovering Deleted Files, Pictures & Videos

By Unknown
  So many times we accidently delete some important files, pictures or videos. Sometimes we loose files because of unexpected system failure  ( ultimately causing system format). We can get our deleted files back using Recovery Softwares/Utilities.  Even though a file was deleted there is a good chance that contents of the file are still around.  When a file is deleted the contents of the file are not removed. Only a pointer to the file in the file system table is deleted.   It is very important to immediately stop writing to the storage device that previously contained your files/pictures so that the old file contents are not overwritten.  For example, don’t take any more pictures with your digital camera because new pictures will overwrite the deleted files. HOW TO RECOVER DELETED FILES???? Step1: You will need to use a utility to recover your lost files. I like to use a free ut...
Read More

Google's this Doodle is just Awwwsome!!!!

By Unknown
In celebration of Robert Moog’s 78th birthday, Google has created an epic Google Doodle to honor founder of Moog Music , pioneer of electronic music , best known as the inventor of the Moog synthesizer .The Doodle presents an interactive Moog synthesizer . Users can adjust dials on the synthesizer, turn switches on and off and play sounds on the keyboard. They can also record and playback their creations. Don't miss playing this with your keyboard!!!! Google is also showing a regular link of Google+ to share whatever music you have created.
Read More