Microsoft Excel Short Keys
If you want more like this please like,share,comment.
_____________________________________________
Here are some Microsoft Excel Shortcut Keys for them who want to do their work fastly, who wants to finish their project quickly.
CTRL + A :- Select All
CTRL + C :- Copy
CTRL + X :- Cut
CTRL + V :- Paste
CTRL + F :- Find
CTRL + B :- Bold
CTRL + I :- Italic
CTRL + U :- Underline
CTRL + P :- Display the Print dialog box.
CTRL + N :- To create new workbook.
CTRL + + R :- Uses the Fill Right command to copy the content and format of the leftmost cell of a select range into the cells to the right.
CTRL + N :- To create new workbook.
CTRL + S :- Save the active file with current file name, location and file format.
CTRL + T :- Display the Create Table diolag box.
CTRL + W :- Closes the selected workbook window.
CTRL + Y :- Repeats the last command or action, if possible.
CTRL + Z :- Uses the Undo command to reverse the last command or to delete the last entry that you typed.
CTRL + 6 :- Alternates between hiding objects displaying objects and displaying placeholders.
CTRL + 8 :- Display or hide outline symbols.
CTRL + 9 :- Hide the selected rows.
CTRL + 0 :- Hide the selected columns.
CTRL + SHIFT :- Remove the outline border from the second cells.
CTRL + SHIFT + & :- Applies the outline border to selected cells.
CTRL + SHIFT + ~ :- Applies the General number format.
CTRL + SHIFT + $ :- Applies the Currency format with two decimal places[negative numbers in parentheses].
CTRL + SHIFT + % :- Applies the Percentage format with no decimal place.
CTRL + SHIFT + F :- Active Font drop list.
CTRL + SHIFT + P :- Active Font point size drop down list.
CTRL + SHIFT + * :- Select the current region around the active cell[the data area enclosed by blank rows and blank columns]. In a Pivot Table, it selects the entire Pivot Table report.
CTRL + SHIFT + : :-Enters the current time.
CTRL + SHIFT + “ :- Copies the value from the cell into the cell or the Formula bar.
CTRL + SHIFT + Tab :- To active previous workbook.
CTRL + SHIFT + F1 :- To open the new worksheet.
CTRL + SHIFT + F6 :- For previous window.
CTRL + SHIFT + F11 :- To open VBE.
CTRL + F5 :- XL, Restore window size.
CTRL + F6 :- Next workbook window.
CTRL + F9 :- To minimize workbook.
0 Comments