Monday 4 April 2016

Microsoft Excel Shortcut Keys – Keyboard and mouse shortcuts

Microsoft Excel Shortcut Keys - Keyboard and mouse shortcuts


Microsoft Excel Shortcut Keys - Keyboard and mouse shortcuts
Microsoft Excel Shortcut Keys – Keyboard and mouse shortcuts : Microsoft Excel is very important & powerful application of Microsoft office. Excel is a important software by the Microsoft after word and it has given more other software like Microsoft powerpoint Microsoft access.Out of this we use Microsoft Excel very much for Analysis, making report and manage records and list. Microsoft Excel has so many features so that users can use it very easily and friendly. So that to understand Microsoft Excel is very important and everyone can work on Microsoft Excel but mean thing is if you want to work very fast and easy then you have to understand some of the short codes of Excel that can make your work very fast and easy but most of the people do not know about this short codes of word. So that here we have given call list of very useful and need short codes in below article.

Microsoft Excel Shortcut Keys



Microsoft Excel Mouse shortcuts

ShortcutDescription
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 dividerAdjust height/width to auto-fit of all high-lighted rows/columns
Triple-clickSelect the entire contents in the cell
Click on row/column divider then dragAdjust height/width of the row/colunn
High-light headers of multiple rows/columns then Click on row/column divider then dragAdjust height/width of the rows/colunns
Ctrl + Mouse wheelZooms in and out of document.
Hold Shift + Click the cellsSelect multiple cells

Microsoft Excel Keyboard shortcuts

ShortcutDescription
F2Edit the selected cell.
F5Goto a specific cell. For example, C6.
F7Spell check selected text and/or document.
F11Create chart.
Ctrl + ASelect all.
Ctrl + BBold.
Ctrl + CCopy.
Ctrl + FFind (same as Shift + F5).
Ctrl + GGo To.
Ctrl + HReplace.
Ctrl + IItalic.
Ctrl + KInsert link.
Ctrl + NNew Workbook.
Ctrl + OOpen Workbook.
Ctrl + PPrint dialog.
Ctrl + SSave.
Ctrl + UUnderline.
Ctrl + VPaste.
Ctrl + ZUndo.
Ctrl + YRedo.
Ctrl + XCut.
Ctrl + 5Strikethrough text.
Ctrl + F3Define Name.
Ctrl + F4Exit Excel.
Ctrl + F6Switch between open workbooks.
Ctrl + F9Minimize current window.
Ctrl + F10Maximize current window.
Shift + F1Activate Help on Item.
Shift + F2Insert Comments
Shift + F3Insert Function.
Ctrl + Shift + ;Enter the current time.
Ctrl + ;Enter the current date.
Ctrl + Page downMove to next worksheet.
Ctrl + Page upMove 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 + SpaceSelect entire column.
Shift + SpaceSelect entire row.
Ctrl + (Arrow key)Move to next section.

0 comments:

Post a Comment

 

Follow us