About Me

Welcome to the blog of Positive Mind
About Me | Learn Inredible
Motivational Tip & Tricks Tech Articles Printable Games VECTOR PRINTABLE Coreldraw Tutorial visiting card vector Wedding Cards Vector

LEARN ADVANCE MICROSOFT EXCEL SHORTCUT KEYS IN EASY WAY

LEARN ADVANCE MICROSOFT EXCEL SHORTCUT KEYS IN EASY WAY

excel

Can you make a data summary for your estimate profit for further 20 years in a book. Might be can do but not accurate. Microsoft excel makes your work easy in just few seconds. Type the financial data of your company of the current year and make a graph of online market and there you go the journey estimate of your financial yeras. Microsoft excel helps in many way which we even cant see but it makes your total, bills, graphs, pie diagram huge softwares depend on microsoft excel it is the complete software which makes your sum easy and it gives you data which could just cant beat by any other softwares.

let learnincredible show you shortcuts keys which can make you super active in your business

1) ALT BASE SHORTCUTS

KEYS PROCESS
ALT + ' IT IS USED TO ACCESS THE STYLE DIALOG BOX;
ALT + = IT ALLOWS YOU TO USE THE FORMULA TO ADD THE DATA OF ALL THE ABOVE CELLS;
ALT + ENTER IT ALLOWS THE USERS TO WRITE IN MULTIPLE LINES IN ONE CELL; FOR EXAMPLE, IF YOU ARE TYPING IN A CELL, IT ENABLES YOU TO MOVE ON THE NEXT LINE IN ONE CELL BY PRESSING ALT+ENTER;
ALT + F11 IT PROVIDES USERS THE OPTION TO OPEN THE VISUAL BASIC EDITOR;
ALT + F8 IT IS USED TO DISPLAY THE MACRO DIALOG BOX;
ALT + SHIFT + F1 IT ENABLES YOU TO CREATE A NEW WORKSHEET IN MICROSOFT EXCEL;

 

2) SHIFT BASE SHORTCUT KEYS

KEYS PROCESS
SHIFT + (DOWN ARROW ↑) IT ENABLES YOU TO EXTEND THE SELECTED AREA DOWN BY ONE CELL;
SHIFT + (UP ARROW ↑) IT ENABLES YOU TO EXTEND THE SELECTED AREA UP BY ONE CELL;
SHIFT + F3 ITS USE IS TO OPEN THE EXCEL FORMULA'S WINDOW;'
SHIFT + F5 IT PROVIDES USERS THE OPTION TO DISPLAY THE FIND AND REPLACE DIALOG BOX;
SHIFT + HOME IT ENABLES YOU TO SELECT ALL CELLS TO THE LEFT OF THE CURRENT ACTIVE CELL;
SHIFT + PAGE UP IT ALLOWS YOU TO SELECT ALL THE CELLS LOCATED ABOVE THE SELECTED CELL;
SHIFT + SPACE IT ENABLES YOU TO SELECT THE ENTIRE ACTIVE ROWS;

 

3) F KEYS BASE SHORTCUT KEYS

KEYS PROCESS
F1 IT IS USED TO OPEN THE HELP SCREEN WINDOW;
F10 THE FUNCTION KEY F10 IS USED TO ACTIVATE THE MENU BAR; FOR EXAMPLE, IF YOU WANT TO OPEN THE FILE MENU, YOU NEED TO PRESS F10, THEN F;
F11 ITS USE IS TO CREATE A CHART IN EXCEL;
F12 IT ENABLES YOU TO USE THE SAVE AS OPTION, WHICH ALLOWS YOU TO SAVE A FILE WITH A DIFFERENT NAME; IT CAN ALSO BE DONE BY USING ALT+F2;
F2 IT ALLOWS YOU TO EDIT THE SELECTED CELL IN THE EXCEL SHEET;
F4 IT PROVIDES USERS THE OPTION TO REPEAT THE LAST ACTION; FOR EXAMPLE, IF YOU CHANGE THE RED COLOR OF THE TEXT IN A CELL, BY PRESSING F4, YOU CAN APPLY THE SAME TEXT COLOR IN ANOTHER CELL;
F7 IT IS USED TO CHECK THE SPELLING OF THE SELECTED TEXT;

 

4) CTRL BASE SHORTCUT KEYS

KEYS PROCESS
CTRL + - (MINUS) IT WILL OPEN A DELETE DIALOG BOX WHERE YOU CAN DELETE A SELECTED ROW OR COLUMN;
CTRL + (RIGHT ARROW →) IT ALLOWS THE USERS TO MOVE THE CURSOR TO THE NEXT CELL, WHICH CONTAINS THE TEXT;
CTRL + 0 IT IS USED TO HIDE THE SELECTED COLUMNS;
CTRL + 1 IT IS USED TO OPEN THE FORMAT CELLS DIALOG BOX WHERE YOU CAN CHANGE THE TEXT FORMAT LIKE TEXT COLOR, FONT SIZE, FONT STYLE, TEXT ALIGNMENT, ETC; IT CAN ALSO BE DONE BY PRESSING CTRL+SHIFT+F OR CTRL+SHIFT+P;
CTRL + 5 ITS USE IS TO PUT THE STRIKETHROUGH TO ALL SELECTED CELLS; 
CTRL + 9 ITS USE IS TO HIDE THE SELECTED ROWS IN THE WORKSHEET;
CTRL + A ITS USE IS TO SELECT OR HIGHLIGHT ALL CONTENTS OF A WORKSHEET;
CTRL + B IT ALLOWS YOU TO BOLD ALL SELECTED ITEMS OF AN EXCEL SHEET; IT CAN ALSO BE DONE BY PRESSING CTRL+2;
CTRL + C IT IS USED TO COPY THE SELECTED CONTENT OF A WORKSHEET;
CTRL + D IT ENABLES YOU TO FILL DOWN THE CELLS WITH THE CONTENT OF THE SELECTED CELL; 
CTRL + END IT IS USED TO MOVE THE CURSOR TO THE LAST CELL WITH TEXT ON THE WORKSHEET;
CTRL + F IT OFFERS THE OPTION TO OPEN FIND AND REPLACE DIALOG BOX QUICKLY; YOU CAN ALSO USE SHIFT + F5 FOR IT;
CTRL + F10 IT USES TO MAXIMIZE THE CURRENTLY SELECTED WINDOW;
CTRL + F11 IT IS USED TO INSERT A MACRO SHEET IN MICROSOFT EXCEL;
CTRL + F3 IT IS USED TO OPEN THE NAME MANAGER IN MICROSOFT EXCEL;
CTRL + F5 ITS USE IS TO RESTORE THE WINDOW SIZE;
CTRL + F6 IT ENABLES THE USERS TO MOVE FROM ONE DOCUMENT TO ANOTHER DOCUMENT IN MICROSOFT EXCEL; IT CAN ALSO BE DONE BY PRESSING CTRL+TAB;
CTRL + F9 IT ENABLES USERS THE OPTION TO MINIMIZE THE CURRENT WINDOW;
CTRL + G IT IS USED TO OPEN THE GO-TO OPTION DIALOG BOX WHERE YOU CAN GO TO THE SPECIFIC CELL; IT CAN ALSO BE DONE BY USING F5;
CTRL + H IT ALLOWS YOU TO FIND AND REPLACE THE WORD OR SENTENCES IN A FILE; FOR EXAMPLE, IF BY MISTAKE YOU HAVE WRITTEN A COMPUTER INSTEAD OF THE COMPUTER AT MANY PLACES IN YOUR SHEET, YOU CAN REPLACE IT WITH THE COMPUTER IN ONE GO;
CTRL + HOME IT ALLOWS THE USERS TO MOVE THE CURSOR TO THE BEGINNING (CELL A1) OF THE WORKSHEET;
CTRL + I IT IS USED TO PUT ITALICS ON ALL CELLS IN THE SELECTED SECTION; IT CAN ALSO BE DONE BY PRESSING CTRL+3;
CTRL + K IT PROVIDES THE OPTION TO INSERT A HYPERLINK IN A FILE;
CTRL + L IT ENABLES YOU TO ACCESS THE CREATE TABLE DIALOG BOX;
CTRL + N ITS USE IS TO OPEN THE NEW DOCUMENT OR A WORKBOOK;
CTRL + O IT OFFERS USERS THE OPTION TO OPEN THE DIALOG BOX WHERE YOU CAN CHOOSE A FILE THAT YOU WANT TO OPEN; YOU CAN ALSO USE CTRL+F12 TO OPEN A FILE;
CTRL + P IT ALLOWS YOU TO PRINT A CURRENT SHEET OR A DOCUMENT QUICKLY;
CTRL + PAGE UP & PAGE DOWN IT ALLOWS YOU TO MOVE FROM ONE WORKSHEET TO ANOTHER WORKSHEET IN THE SAME EXCEL FILE;
CTRL + Q IT IS USED TO DISPLAY THE QUICK ANALYSIS OPTIONS FOR THE SELECTED CELLS WITH DATA; 
CTRL + R IT ALLOWS YOU TO FILL THE CELLS TO THE RIGHT WITH THE CONTENT OF THE SELECTED CELL; 
CTRL + S ITS USE IS TO SAVE THE DOCUMENT; IT CAN ALSO BE DONE BY USING ALT+SHIFT+F2;
CTRL + SHIFT + ! IT IS USED TO APPLY COMMA FORMAT IN NUMBERS;
CTRL + SHIFT + $ ITS USE IS TO APPLY CURRENCY FORMAT TO NUMBERS; AS SHOWN IN THE BELOW SCREENSHOT:
CTRL + SHIFT + & IT OFFERS USERS THE OPTION TO MAKE A BORDER AROUND THE SELECTED CELLS;
CTRL + SHIFT + ( ITS USE IS TO SHOW (UNHIDE) THE HIDDEN ROWS;
CTRL + SHIFT + ^ IT IS USED TO MAKE AN EXPONENTIAL FORM OF ANY NUMBER; FOR EXAMPLE, YOU HAVE WRITTEN A NUMBER 12345 IN THE WORKSHEET, AND IF YOU PRESS CTRL+SHIFT+^, THE NUMBER WILL BE CHANGED 1;23E+05 IN EXPONENTIAL FORM;
CTRL + SHIFT + = IT WILL OPEN THE INSERT DIALOG BOX WHERE YOU CAN INSERT THE NEW ROW OR A COLUMN;
CTRL + SHIFT +% IT PROVIDES USERS THE OPTION TO APPLY PERCENTAGE SIGN TO NUMBERS; 
CTRL + SHIFT+ _ IT OFFERS USERS THE OPTION TO REMOVE A BORDER AROUND THE SELECTED CELLS IN A WORKSHEET;
CTRL + SPACE IT ENABLES YOU TO SELECT THE ENTIRE ACTIVE COLUMNS;
CTRL + T IT OFFERS USERS THE OPTION TO DISPLAY THE CREATE TABLE DIALOG BOX;
CTRL + U IT IS USED TO UNDERLINE ALL SELECTED CELLS; YOU CAN ALSO USE THE SHORTCUT KEY CTRL+4 TO UNDERLINE THE CELLS IN THE EXCEL SHEET;
CTRL + V IT PROVIDES USERS THE OPTION TO PASTE THE COPIED DATA ONTO THE EXCEL SHEET; YOU ARE REQUIRED TO COPY THE DATA ONCE, AND THEN YOU CAN PASTE IT ANY NUMBER OF TIMES;
CTRL + W IT IS USED TO CLOSE THE CURRENTLY OPEN DOCUMENT OR A FILE QUICKLY; IT CAN ALSO BE DONE BY PRESSING CTRL+F4 SHORTCUT KEYS;
CTRL + X IT ALLOWS USERS THE OPTION TO CUT THE ENTIRE DATA OF THE SELECTED CELLS IN AN EXCEL SHEET;
CTRL + Y IT PROVIDES USERS THE OPTION TO REDO ANY UNDO CONTENTS;
CTRL + Z IT IS USED TO UNDO (GET BACK) THE DELETED ITEM; FOR EXAMPLE, IF YOU HAVE DELETED THE DATA BY MISTAKE, YOU CAN PRESS CTRL+Z TO RETRIEVE THE DELETED DATA; IT CAN ALSO BE DONE BY PRESSING ALT+BACKSPACE;
CTRL+; IT IS USED TO ENTER THE CURRENT DATE;
CTRL+SHIFT + ; IT IS USED TO INSERT THE CURRENT TIME;
CTRL+SHIFT+" IT ALLOWS YOU TO COPY THE CONTENT OF A CELL AND TO PASTE IT INTO A CELL, WHICH IS JUST BELOW IT; IT CAN ALSO BE DONE BY USING CTRL+" KEY; FOR EXAMPLE, IF YOU HAVE WRITTEN "EXCEL" IN CELL B1 AND ITS BELOW CELL IS B2, BY PRESSING CTRL+SHIFT+" OR CTRL+' THE WORD "EXCEL" WILL BE COPIED IN CELL B2;
CTRL+SHIFT+SPACEBAR IT IS USED TO SELECT THE ENTIRE WORKSHEET;

 


Advertise

Your AD Here

Subscribe

Enter your e-mail below and get notified on the latest blog posts.

Popular Posts


Follow Me


SUBSCRIBE

Join my mailing list to receive updates on the latest blog posts and other things.