Throw your mouse Why am I saying this? You will know this after watching the blog Friends, on computer keyboard, keys are 104 And if you don't know their practical use Then your life is useless Yes friends, I am not rhyming I am telling the reality If you are a computer teacher, computer student or computer operator Whoever you are If you don't have detailed information about computer keyboard Then you can't become a master in computer Or If you are learning computer for the first time if you don't have detailed information about computer keyboard then you can't become a master in computer or if you are learning computer for the first time and you are confused after seeing computer keyboard that so many keys are pressed together then this blog is for you yes friends, in this blog I am going to give you detailed information about computer keyboard I will give information about 104 keys on computer means what are the keys and what are the keys group Also how to use these keys in different software Means how to use these shortcut keys in Microsoft Word Which shortcut keys will be used in Microsoft Excel Which shortcut keys will be used in Microsoft PowerPoint I will tell you in detail Means you can see the function keys on the keyboard So how to use F1 to F12 in any software what are the combinations with the function keys like control F1, control F1, control F3, shift F3 I am going to tell you all these combinations along with that I am going to tell you home, insert, page up, page down practical use of these shortcut keys use of pause break, use of scroll lock, use of caps lock I am going to tell all these shortcut keys in detail What are the combinations of Alt key on keyboard, I am going to tell you that too And from Ctrl+A to Ctrl+Z shortcut keys I am going to tell you Means Ctrl+A, Ctrl+B, Ctrl+C, Ctrl+D, after pressing like this What happens, how it is used practically I am going to show you practically, I am show you how to use it practically. I will not tell you theoretically. I will show you how to use Microsoft Word, Excel, PowerPoint and other software which we use regularly. If you already use keyboard and you already know the shortcut keys of keyboard then also I will tell you with guarantee that I will tell you some shortcuts on keyboard which you might not know for that you have to watch this blog till the end in this blog I am sharing a pdf in the blog where you will find the detailed explanation of all these shortcuts you can see on the screen that what are the uses of these shortcuts.
welcome to Cybers Bytes blog Let's start the wait So friends, as I told you in the intro part that we are going to learn all the keys on the keyboard in detail and also learn their practical use. So first of all, I will tell you the name of all the keys on the keyboard. Means there are keys of different sections here, so let me explain them first. First of all, the keyboard that you see here and the keys coming in in it, from F1 to F12, it is called function keys. Remember, F1 to F12 keys are called function keys. Remember the name, we are going to see the practical use of F1, F2, F3 or the combination with them, we are going to see that too. And how to use them in different software, we will also the combination with control and how to use it in different software but these are called function keys and on the left you can see a key which is called ESC so what is the use of this? I will tell you first remember their name after that we move towards the next keys and below that you can see the keys in which you can see the sign like exclamatory, at the rate, hash, dollar, percentage and all these keys are called as alpha numeric keys remember you can see the number here 1,2,3,4,5 and you can see some symbols or signs like exclamatory, at the rate these are called as alpha numeric keys remember the name of the keys after that you can see the keys below on the left side you can see the tab caps lock, shift, control this is a key of windows then you can see the alt twice you can see the control twice you can see the shift twice so these keys are called special keys which we use as a combination what is their use I will tell you special keys you have to remember the name of this section right then ABCD keys means alphabetic keys, ABCD keys, means alphabetic keys ABCD as you can see is alphabetic keys and it is not in ABCD format because it is a QUERITY format of keyboard Q W E R T Y and how this QUERITY format came, I have already made a blog on Cybers Bytes blog so you can check on the blog how the QUERITY format keyboard came why this ABCD is kept on the keyboard in this format why is it not in the order of a, b, c, d what is the reason for this, you will know in that blog for now these are the alphabetic keys you have to remember this much after that you can see arrows on the right side like up arrow, down arrow, left arrow and right arrow these are called arrow keys these are called arrow keys or navigation keys we will see how to use them practically then you can see on top of that insert, home, page up, page down, delete, end these keys with print screen, scroll lock, pods, break these are called extra keys they are used in different ways, practically we are going to learn how to use them with combinations so we will see that practically too and along with that on the right side you can see a panel in which you can see 0 to 9 numbers along with that you can see the sign of multiplication etc. so these are numeric keys which helps you to type numbers on the keyboard so these are called numeric keys so I gave you information about keys what are the keys in standard keyboard there are 104 keys if you are using multimedia keyboard then you have to use multimedia function like stop blog, increase sound of blog increase or decrease audio do blog next or backward, for this there are different keys available on the multimedia keyboard, which I am showing you as an example of multimedia keyboard on the screen. So we will learn about the standard keyboard which is used in the offices. We buy the multimedia keyboard only when we want to use the multimedia more, to forward the blog or backward it. Right, for now we have learned what are the keys, for forwarding or backwarding the blog Right? Now we know what are the keys like where are the function keys what are the alphabetic keys what are the alphanumeric keys what are the numeric keys what are the extra keys what are the navigation keys I have told you about all these keys Now we will start their practical use We will start from the top row that is we will start from the escape button first So here I have come on the desktop Now I have to tell you how to with the escape button so here I am on the desktop now I have to tell you how to use the escape button so first of all I will tell you how to use the escape key in powerpoint so here in powerpoint this slide is open I want to close it so I will escape from the keyboard to close the powerpoint slideshow you press the escape button on the keyboard and the powerpoint slideshow will be closed right, other than that generally you press the escape button on the keyboard, the slideshow of the powerpoint will be closed. Apart from that, the use of escape is generally suppose you clicked on start here but you don't want this window, then press the escape button on the keyboard and the escape button is also used to close the un-aunted dialog box. Like you are working in Microsoft Word but the un-aunted dialog box is opening or you have opened it and you don't need it. Like you have opened the extra dialog box of this font additional font options right so you open it from here here is a small option for additional fonts I am focusing on this here the font dialogue box is open but you don't have any work in it so you press the escape button on the keyboard so to close the dialogue boxes to avoid un-on-on click like here by mistake you clicked on close so as soon as you click it is asking you to save this document so I don't have to do anything in this I don't need this dialog box so I will press escape button so this is how the use of escape key is suppose I come back to powerpoint and press F5 so I have to cancel this and close this slide show so I will press escape or if I want to close any dialog box then also I will press escape or if I press to close any dialog box then also I will do escape or if I press Ctrl Shift Esc on keyboard then task manager opens with which you can know the performance of your computer like how much CPU and memory is being used, all these things are shown here all these things are shown here with Ctrl Shift Esc key means escape combination is there with Ctrl Shift and you must have known how to use escape key right, escape if you want to escape then use escape key simple, now we move towards next key we will start with function keys we will start with F1 if you have pressed F1. If you directly press F1 on your computer, it will jump to Microsoft AGI or Internet Explorer. It will ask you to search for help in this. If you are in any software like Microsoft Word is your start and you press F1 here, then a help task pane opens on the right side and you can take help in this that you want to know about page setup in Microsoft Word, then you can search here, you can type, then to open the help menu, you can press F1 on used to open help menu but in Microsoft word if you press Ctrl F1 I am doing in combination with F1 Ctrl F1 so here this ribbon is minimized Ctrl F1 Ctrl F1 ribbon minimized open right in this way you can use Ctrl F1 in Microsoft word excel powerpoint to open and close the ribbon or you can use it to minimize and close the ribbon or minimize it control F1 the ribbon is being minimized I am using it practically note down the shortcut I have already given the PDF so let's move to the next shortcut now is the next shortcut F2 I will show you how to use F2 on desktop I will minimize it here is a folder named Cybers Bytes. I will select this folder and press F2 button on the keyboard. After pressing F2 button, the option to change the name of this folder has come. I want to name it learn more. I have named it learn more which is the name of our channel. You must know it. I have clicked it learn more which is the name of our channel and I have clicked on the side, so what happens with F2? You can change the name of the file from F2, you can change the name of the folder Remember rename, F2 is used for rename There is some different use of F2 in Excel, so I have started Excel here If you have already typed any name here, whatever name you have typed Suppose I typed my name, then I have to edit it. If I want to add another name, then I have to type the name directly so the first name is displayed. I have to add that name in it. I have to add the name of Satish first or my dad's name in between. I will press the button F2 and after pressing F2, the cursor is displayed. F2 means Edit Active Sale. Remember that there is content in this sale and if you press F2 then you want to edit it edit active sale so here you want to add something in the ending, you can add you want to add in the middle, take the cursor in the middle and add you can add like this and press enter button F2 edit active sale here you must have understood the use of F2 F2 is used for renaming to change the file name or folder name F2 is used for rename, file name or to change folder name F2 is used for edit active cell and F2 is used for some other use like you have written some content in word I have written a paragraph, I have taken a formula to take a paragraph because it will take a lot of time to type a paragraph in word there is a readymade formula is equal to r a n d open bracket close bracket enter it, here easy here a paragraph comes for practice now I want to print it so I want to see the print preview so I will press the control F2 button, the control F2 comes to print preview, here I will know how this page will be printed, print preview, before printing, you will be able to see your page full screen control F2 here on the right side you can see the whole page here so that's it now you know the meaning of control F2 and how to use it now we will move to next shortcut which is function key F3 now I will show you the function key F3 in Microsoft Word F3 is not directly used but it is with Shift. I am selecting this paragraph and I am zooming it. I am pressing Shift F3. You will notice some changes. Shift F3. What is happening? All the selected alphabets. I am talking about selected text. So, this capital is there in selected text. Can you see? If I again do shift F3 all of them are small again I do shift F3 see carefully some changes are happening first alphabet is capitalized sentence V here W can you see and if we notice below here Y of U right this is how capitalized first alphabet of sentence capitalized then shift F3 all capitalized shift F3 all small shift F3 sentence case capital shift F3, all small shift F3, sentence case. Capital case means upper case means whole alphabet capital will be done and lower case. We can do such change case here through keyboard. So, if you have written the whole paragraph here and you know that you have to write everything in capital. Don't worry, select the paragraph, press shift F3. That's it. So, you must have learned the use of F3 here but how to use it in excel means if I press shift F3 in excel then what will happen let's see here you have typed a number and you have to do the total here but you have to put any formula here so to take the formula you have to go to the insert function here I focus from here you take this insert function is not visible here click, then the insert function dialog box comes here and the formulas come here. You can use any formula according to that. So I have canceled that dialog box. To cancel it, I used escape. I told you escape in the beginning. So now I press shift F3. See, it is coming. It is happening with shortcut key, which means I don't need to click here now. Right? So shift F3 gives you some different functions available in, Shift F3 gives you different functions in Excel. It gives you the function key screen. So, let's move on to the next shortcut key. That is F4. I will show you how to use F4 shortcut key. We will use it in Alt F4, Ctrl F4 and Shift F4. What a combination of all three. If I am doing it in excel or in word I will press ctrl F4 then it will ask that document will be closed and you have to save it I don't have to save it it is closing I am pressing ctrl F4 remember see the name of this file is book1 now this book1 is closed we call excel file workbook of this file is Book1. Now the workbook of Book1 is closed. We call the Excel file as workbook. So the workbook is closed. Here you can see that the Excel software is on. I will press Ctrl N and the new workbook has come. Book2. New workbook has come from Ctrl N. No issues. I press Ctrl F4 again. This workbook is closing. Excel does not close. Remember that from Ctrl F4, the the workbook. Remember that Excel is not closed. Press Ctrl F4 to close the workbook. If you want to close the whole Excel then press Alt F4. If you want to exit from Alt F4 then press Ctrl F4 to close the workbook. If I have some content and cursor is here then then I press shift F4, then cursor goes to the beginning. Cursor was here, press shift F4, cursor will go directly to the position in the beginning. Here we will go to A1 with shift F4. So this way we can use alt, control and shift with F4. So we have seen F4, now let's move to next shortcut which is F5 first of all you should know the use of F5 in powerpoint F5 is used for slideshow, means I have to present this slide F5, then it gets exit from escape button F5 slideshow, use in powerpoint ok, what is the use in powerpoint what is the use in windows, I will minimize everything if I do F5 refresh, many people know that we do right click refresh you can refresh with F5 button now in new windows the refresh work is less earlier what used to happen is that sometimes you make a folder on desktop so it was not visible, after refreshing it used to load so refresh key is given there. So you can use this shortcut here. If you press this F5 in Word or in Excel, then you get a go to option. Which page do you want to go to? Enter page number. Enter page number, you can go to that page after pressing the F5 button. If you press F5 in Excel, then which cell do you have to go to? I have to go to A5. So I have put A5 cell reference and I press ok, then I am going to A5. See, as soon as you press F5 button, the dialog box of Gootoo comes. And Gootoo is very advanced in excel. So basically, here are special options also in Gootoo. And for this, I have already made a good blog of Gootoo special on the excel tutorial channel. Which if you want to become an expert, if you want to blog of go to special on excel tutorial channel which if you want to become an expert and want to learn then I have given the link of excel tutorial channel in the description and I have also given the link of go to special blog in the description for you guys so how to use F5, you can understand it here ok, there is one more use of F5, like if you press control F5 in excel then this window gets smaller right, it gets smaller with F5 button, remember that restore down, Ctrl F5 in excel then this window will be smaller remember that this window will be smaller by pressing F5 remember that this window will be smaller by pressing Ctrl F5 but by pressing Ctrl F5 again it will not be maximized I will tell you about shortcut for maximizing but Ctrl F5 is here, here window is smaller but you can't use this shortcut in word in word you have to press Alt F5 Alt F5, see this if you use alt F5 then this becomes small so alt F5, control F5, then F5 how to use it, you must have understood I am telling everything in detail, that's why I am telling you the combination of everything step by step let it take time, if you want to learn then you have to give time and if you are watching the blog till now, you want to become smart this is its sign of that for now let's move towards F6 now people use F6 very rarely people don't know the use of F6 but you were told that by pressing F6, let's come to excel suppose you are told in excel that here are many sheets, let me show you an example and you are told that you have to go from sheet 5 to sheet 1 from keyboard how to go? from keyboard from sheet 5 to sheet 1 with keyboard how to go? you have to go from sheet 5 to sheet 1 with keyboard this is a challenge for you and in interview you are asked to select sheet 1 with keyboard don't touch the mouse so you will press F6 button as you will press F6 you will pay attention here see cursor is highlighted here press X again cursor is here press F6 where is cursor? cursor is on ready then press F6 see where cursor is coming press X again and cursor will go to ready press F6 again and again press F6 again press F6 again and again press sheet see it is highlighting a little if you press left arrow on keyboard see I am pressing left arrow on keyboard I am not touching the mouse at all press left arrow and enter I am on sheet 3 then I will press F6 again then I will press left arrow I am on sheet 1, enter so I moved it from F6 you can use this this shortcut on desktop. You are told that there are options on the right side like time etc. You can access it with keyboard. So you press F6. First you have come to windows logo. Press F6 then you have come further. Here you have come to task view. Press F6. Here you have to click on the recent open applications. Frequently open applications. Not recent, the see the applications which are frequently open not recent, the applications which we have kept for frequently open you have pressed F6 here, if you want to switch it, you can press right arrow and left arrow which application you want to go to so here I press F6, now cursor is here if you notice here, I am showing you by zooming see this, and here I I press right arrow and left arrow then how you can see the highlight I am showing you by zooming so that you can see I am selecting these options by left and right arrow and I can enter the settings by entering here so F6 is a very useful shortcut and many people don't know about it and you must have known and you must have thought that this is a great shortcut so please like this blog for now let's move on to app 7 shortcut now we will use app 7 shortcut in microsoft word and that is for spelling and grammar we will use it first like I have written a name in microsoft, like I have written here Shriwali, these days it is famous, I write the name Shriwali, I don't know, I wrote Shriwali like this, but here it is telling me the spelling wrong, I have written Shriwali correctly, but still the computer is telling me that it is wrong. If I wrote it like this, then it is telling the word wrong to Vali, not to Shree. But here I only need the spelling mistake and redvv__ tells the spelling mistake in the word. redvv__ has made a spelling mistake. Okay, you wrote a word computer, here it did not give an underline. You wrote another word, computer. Now it is telling the underline here. Means if you wrote the wrong word, then it will not tell you the underline so I want to remove the underline I think Srivalli is correct but the computer is telling the wrong word because it is not in the computer dictionary the computer doesn't know the name of Srivalli the computer doesn't know anything, we have to tell it. So, what we will do is, we will press F7. As soon as we press F7, a task pane named spelling and grammar opens in the right side of the screen. Now, here it is telling that I have some words related to the word Shrivalik written here. Shrivalik, Shrivels, it is telling that we have this word, do you need any word from this? We don't need any word from this. If we want, we will click on change, but we don't need any word from this. So what we will do is we will do ignore once here. Ignore once means that this spelling is correct for us, it will not be for the computer, so ignore once. And ignore all means that you have written Sriwali 100 times, so ignore all. Add means that I have to write Sriwali daily in this computer, so add it in your dictionary. Next time I will write Sriwali, so I don't have to show you this spelling and grammar mistake. We are telling the computer to add to dictionary. Add means it will be added in this computer's dictionary. Next time you write Sriwali, then you will not see this underline this underline is not printed but it is ok for you computer will tell you that you have made a mistake you will know in preview, even for this word you have to write underline if it is not there then ignore it or you can add it in computer for next time if you will start Microsoft word, if you write Shriwali in this computer, it will not tell you wrong but if you ignore it, it is temporarily hiding the underline for this document now it has left this word, it has not checked because it is correct second word but the computer which is written below is wrong and for that suggestion it is telling that you have to write computer, copter or compare select which one you want to write and click on change for now we will do that, we will click on change, change is showing here change all means you have written 100 times in computer or as many times as you have written so I am selecting computer and changing it and here spelling and grammar check is complete it is completed and here you can grammar check is complete. And here you can see it is proper. So we know the use of F7. What happens? In F7 we can check spelling and grammar. If we want to know the meaning of this word, then we will press Shift F7. Another combination of F7 is made with Shift. Shift F7 comes from another task pane word, Thesaurus. It is synonymous. It has a similar word. Shift F7 is used in another task pane word called Thesaurus or Synominance It has similar word So here processor, CPU, processor related word is used It is telling similar words Thesaurus, Shift F7, remember this combination Now let's move to next shortcut which is F8 It is used more in excel We come to excel And here I have typed some content It can to Excel. I have typed some content here. It can be any content. I have typed a number here. And I will repeat it. I will tell you how to repeat it later. There are shortcut keys for this. For now, I have kept the cursor here. And if I want to select from here, then I have to press Shift and Right arrow. Shift and Down arrow. I have only one key. If I press and down arrow I have to press right arrow with only one key left arrow, bottom arrow, up arrow should be selected so wherever I keep the cursor to lock the selection I will press F8 button on keyboard like I will press F8 once so below you can see by doing extend selection it will be extended F8 is active. Go to the right side. Press right arrow. Press control, shift, nothing. Press right arrow, press down arrow. It is selecting automatically. Press up arrow. A cursor is locked on that selection. See, the 45 we had written. The 45 we had selected in D6 cell. That selection is locked on that position. Remember. Press F8 again. Now, the name of the extended selection has been removed. If you have selected the D6 cell, then that selection is locked in that position. Remember, press the effect again. Now see the name of the Extent Selection has been removed here. And now if you press the down arrow, your cursor will move like this. So press the effect to lock the cursor in the position you are in. As soon as you press the effect, it will give you the instruction below on the status bar that what status it is. You have turned on the Extent Selection. Now press the down arrow and it is selected, you don't need to press any combination press F8 again and the selection will be removed so this is the use of F8, the second F8 is in Word and Excel it is for bringing the window of macros this macro is for programming in Excel and if you know macro in Excel now this macro is for programming in excel and for fast work and if you know macro in excel and if you know macro in word then you are not doing any work because if you learn macro in excel then you do work very fast if you are not using macro in excel then you are doing work and I have already made a blog on my learn more channel Satish sir says to stop doing work and many people have seen this blog Do not do a lot of work, you must see this, go to the Learn More channel and I will give you a link in the description We are working in Excel but we are doing a lot of work, meaning we are not using the macro The macro works automatically, how it will be known in that blog Alt F8 is for bringing macros window let's move on to F9, this is our next shortcut F9 plays a very important role in Excel I want to show you a small example I have explained many times in my Excel blogs here I have put a formula in Excel and in this formula, this selection of sales which numbers are in front of it, I have to see that, so I will press F9 on the keyboard by selecting it. As I press F9, all the numbers above will be visible that there are so many numbers. Okay, I will do one thing, I will type the number separately here because it is showing the same number everywhere because it was written 45. Now I will put some formula here, any formula you put, the range you will select in it, whatever range you will select, you want to see its calculation, which number is in it, then you can press F9 here. Press F9 and to remove this F9, press Ctrl Z to come in the range again. Remember, press F9, Ctrl Z. In this way, to remove it, to come back to the formula. So, from F9 you get to know what is the result of the selection you have done, what comes by F9 and you can calculate each formula separately through F9. This also plays the role of manual calculation. As I am going to the formulas tab and in the calculation options, I have kept the manual mode in the calculation option. Now I have put a formula here. Is equal to sum. I have put the manual mode. And I have entered. Here the answer is 913. If I change the value here, then the update is not done below. So if I press F9 on the keyboard, then it will be updated. Right. You can update the calculation on the manual mode by pressing F9 you can use manual mode calculation by pressing F9 by pressing F9 all the updated formulas are updated here you will know what is the use of manual mode in Excel if you have learned Excel. There are many uses of manual mode. When you have thousands of formulas and when they are calculated at once, then there is a chance that the Excel sheet will be hanged. So people activate manual mode. For now I have activated automatic mode again. So you understand the F9 button here. And F9 has a combination with control to minimize Excel. If I press control F9, then Excel gets minimized. Control F9. See Excel is minimized below. I open it again. It gets minimized by control F9. Excel gets minimized see Excel is minimized below I open it again and it gets minimized it will not be maximized for maximizing and minimizing there are different shortcut keys but I am telling you the combinations of Ctrl F9 ok, now let's move towards the next shortcut which is F10 what is the use of F10 in the function I will use it with Ctrl and Shift first I will tell you the use of Shift F10 if I want to use it with control and shift first I will tell you how to use shift F10 if you want to right click in excel then I right click on it with mouse but I want to right click without mouse so if you want to right click without mouse then press shift F10 oh great shift F10 is coming right shift F10 you can press on desktop also I will minimize it and I press shift f10 on desktop also, I will minimize it and I press shift f10 here, shift f10 right click on desktop also, you select folder and right click on it, shift f10 right so shift f10 right click, we can use it for right click keys other than that what happens with control f10, if you keep this excel screen open and you want to restore it, control f10 we have made it small,trl f10 you have to press ctrl f10 and maximize it we had seen the use of this with f5 that's why I told you that it is also used with f5 to restore windows with ctrl f5 in excel and with alt f5 in word but there the window was not getting bigger here both are there c F10 control F10 control F10 will be smaller and control F10 will be maximized restore maximize to maximize restore you can use control F10 right and its combination will be like this if you press alt F10 then selection pane opens so that whatever object is there like here I have gone to insert chart or or pictures, whatever it is, I draw some shapes here. So you can select the shape from here or you can hide it. To open this selection pane, you have to press the Alt F10 button. Remember this shortcut is also used in Word, Excel, PowerPoint, Alt F10. You can call it the selection pane dialog box or task pane. It opens on this side. See, I am showing you the selection pane. and here you can see the option of Alt F10 and here you can see the option of Alt F10 and here you can see the option of Alt F10 and here you can see the option of Alt F10 and here you can see the option of Alt F10 and here you can see the option of Alt F10 and here you can see the option of Alt F10 and here you can see the option of Alt F10 and here you can see the option of Alt F10 and here you can see the option of Alt F10 and here you can see the option of Alt F10 and here you can see the option of Alt F10 and here you can see the option of Alt F10 and as you can see my website here I press F11 see what is happening as soon as I press F11 full screen is happening all the menus are disappearing press F11 again and exit from full screen so you must have known this use of F11 so now let's move towards F12 now let's see the use of F12 in the browser first our browser is open, I press F12 so you get elements here in F12, HTML code inspects, which are the HTML codes, how are they, all these things you get to know from F12 here, if you are learning programming, then you should know that you can see the backend of this website from F12, that is, you can see the coding, right, you can see some coding of HTML CSS ok, you can't see the whole backend but you can see the coding of HTML CSS with the help of F12 using F12 in browser let's know about Excel and Word I have already saved this file in Excel let's take an example, I have opened a file here I have opened a text formula file what I want to do with the text formula file, now what I want to do is that if I press Ctrl S, nothing will happen, I want to save it duplicate, then I will press F12 button on the keyboard. this dialog box comes in word excel powerpoint so you can duplicate the file multiple times suppose I downloaded the file from internet it is in download folder I want to save it in another place I press F12 and save the file and if I open control F12 in word excel powerpoint then open dialog box comes you can open it with control O or F12 we have learned the use of F12 we have learned how to use F12 we have learned how to use F1 to F12 function key we have learned how to use it practically now we are moving ahead on this panel which you can see on the keyboard home, page up, page down panel first we will see how to use home key in excel I have kept cursor cursor and pressed the home key so my row is coming to the beginning of the cursor see, I press the home button here so the cursor will go directly to the beginning of the row if I press the control home button then my cursor will go directly to A1 cell control home, see this control home cursor is going to A1 where my content is starting if you press home, then here, if you come to home word, suppose in word I will show you in word also because you should use it everywhere here the cursor is kept in the end of this line, in the ending of this sentence here in the ending of this line, if you press home, you will go to the starting of that line and if you press control home, then you will directly come to the beginning of the word page so control home is, pay attention to the cursor, here the cursor is already here so you must have understood what control home is now let's know about the end, if you press control end then you will come directly to the ending of this paragraph and cursor is on this line at the beginning and keyboard is on the end so cursor will be on the ending pay attention here this blinking line is cursor and cursor will be on the ending so control home, control end these shortcut keys you can use here you can use this with control shift if I press here control shift and home sorry I will keep cursor here control shift and home so see this Press Ctrl Shift Home and press Ctrl Shift Home You can see the whole thing is selected from here If I press Ctrl Shift End from the cursor starting, it will select the whole thing from here to where it is getting content From Ctrl Shift End So you must have understood how to use Ctrl Shift Home, Ctrl Shift Home, Ctrl End, Ctrl Shift End Now let's move ahead Here I would like to shift and how to use it you must have understood now let's move forward here I will tell you how to use an insert shortcut, many people do not know about it, insert shortcut, you can do one here, as you have taken your content type here, you have to write the content, you can use the insert, as I have written here ABCD whatever and now I have placed the cursor here in the starting now I want to remove ABCD and instead of that I want to overlap the content whatever I type, 4 alphabet, ABCD should be removed automatically cursor is in the starting I am zooming it to show you now what I will do here I will press the insert button on the keyboard like I will press insert, I will press the INSERT button on the keyboard first as you can see, when I press the INSERT button, something is highlighted now whatever I write, it will delete the alphabet on the right side so I wrote L here, can you see it? wrote E, so it deleted B it is replacing LEAR can you see it? so in this way, it will replace the old word because of the INSERT key so what happens in the INSERT key key, if you want to overlap a word then you press the insert key and it will automatically show you what it is doing so try it, if you press the insert key and go to type then it will overwrite the word if you have copied some content here and you want to paste it here, then you can press shift insert and that content will also be pasted. For paste, you can use the shortcut shift insert. Right, so you must have known the use of insert. Now here we saw the home end, we saw the insert, now we will also use page up, page down and down will be used to scroll down and up page up and down will be used to scroll down and up page up and down will be used to scroll down and up page up and down will be used to scroll down and up page up and down will be used to scroll down and up page up and down will be used to scroll down and up page up and down will be used to scroll down and up page up and down will be used to scroll down and up page up and down will be used to scroll down and up page up and down will be used to scroll down and up page up and down will be used to scroll down and up page up and down will be used to scroll down and up page up and down will be used to scroll down and up page up and down will be used to scroll down and up and down to scroll up and down. You can use it quickly. Remember page up page down You can scroll down and down to scroll up and down. You don't need a mouse to scroll up and down. Now you have to remove the content here. So select and press the delete button on the keyboard. Everyone knows how to use delete, but you don't have to use it everywhere. Means you have an important file on desktop and you are pressing delete button then this file is going to be deleted from here so to delete all the files, content, folders, you can use the delete key so we have understood the 6 keys in this panel now we will know some big keys here now the keys that we can visible on the next panel are Print screen, scroll lock and pause break. Let's know the use of this. Print screen is a very interesting use. Like I am working in Word here and what I have to do is suppose I have to bring a screenshot of the desktop here. So what I will do is minimize it. This screen is visible on the desktop. I want the full screen screenshot. So to do its screenshot, I will press it this screen is visible on desktop I want full screen screenshot so to screenshot this I will press print screen on keyboard and then I will come to word and in word I will press paste I will delete this I will press control V button control V where I had printed the print screen that screen is printed with mouse highlighter I will close the mouse highlighter and delete this means I want the screen of this excel so I will come here and press print screen and paste it in word wow, the whole screen is pasted here and there is another combination of print screen if you don't want to take it in word but you want to save this screen like you are visiting something on the website, now you will open it in word and paste it, I want to save it so I will press window and print screen, as I will press window and print screen, screen will blink a little and you will go to your windows explorer, press window E to go to windows explorer so file explorer is here and here you will get a pictures option windows 10 or 11 whatever you have, go to pictures and you will get a folder by doing screenshot in which you will get many screenshots, I have many screenshots here so here you can see this screenshot too, which we just did, so the screenshot is saved directly as an image, in the screenshot folder inside the documents, inside the pictures, for that you have to press the window print screen shortcut, press it, the work is done, now let's move on, now here we are going to know the next shortcut, that is scroll lock, I will use it in excel, then you will know, when the use of scroll lock will happen, then now how to use it in excel then you will know when you will use scroll lock now see here I am pressing down arrow it is scrolling, now press up arrow it is scrolling, I am going down and going up if I press scroll lock here right as you press scroll lock on your keyboard if there is already light on scroll lock on many keyboard, not on some keyboard then light turns on and it means scroll lock is activated now I will press down arrow and you can see the scroll lock means the up arrow and down arrow are not pressed the cell selection will not change you can see the scroll lock is activated and you can see the up arrow and down arrow are not pressed you can see the result and no need to give more explanation close it and press down arrow and up arrow result is in front of you no need to give more detailed explanation if you see it practical then what is the need of explanation pause break is our next shortcut which is not used by many people it was used in old computer for pause now also it is used in some places so I will show you I am starting DOS here let me show you how to use DOS Press Start and R key Hold down the window and press R key Press CMD and press Enter button You will see the dos window here is some running like I have put the IP address of a website facebook.com and I am ping it I want to check if the reply is coming or not and this will continue but if I press the pause button on the keyboard then it will pause right, it will pause like this, it will stop, if I press the pause button then it will pause and if I press the control pause button again then it will start again like this you can use the control pause button, pause is paused like this, then you will see the pause here pause means to stop something like if you are shooting a blog then you want to pause so it is basically for that but in programming this shortcut key is used this is not a multimedia key by which your song is playing so it can be paused so remember this is not a multimedia key but this is mostly used to stop any running program in programming or when your windows is booting and you press pause then windows will pause at that time and you will see screen at one place this blog will go on but if you like this blog then do like, share and comment those who are learning computer for the first time and don't know anything about keyboard do share this blog with them so that they also get to know what is the use of these keys practically because they get confused after seeing the keyboard for the first time so they won't get confused so share this blog with them and if you like my teaching channel and whatever I am teaching you are understanding then you can go to the description and check my website where there are many courses available with IOS certificate, with instant access, with with lifetime access I have given the link in the description, do check my website for now for now let's move on to the next topic here we have finished print screen, scroll lock and pause break now here on the right side you can see big keys like backspace or enter let's know about these, we will finish the big keys because backspace is known to everyone but now I have decided to tell you all the shortcut keys so I will tell you all in word if you select this and if you press backspace on keyboard then it will be back if you want to back one word then also press backspace in typing backspace has a very important role in typing you have to use backspace has a very important role if you are in any folder suppose you are in this folder here in edge drive rkcils if I press backspace then you will go to the back folder remember you can press backspace here also and you can press alt right arrow left arrow alt left arrow right arrow back, go back, right right right so remember alt left arrow right arrow if you want to go to any folder suppose you went to D and you opened any folder this folder of mine so from this folder you have to go back you can press alt back arrow or backspace but if you want to go forward then right arrow press RIGHT ARROW, RIGHT ARROW so ALT, LEFT, RIGHT ARROW can be used with ALT you know how to use BACK SPACE now let's know about ENTER ENTER is used to change the paragraph in Microsoft Word I want to move down from here, everyone knows ENTER second is that any dialog box that comes in front of you whatever options are set here, if you enter, then it will be saved, see here, it is highlighted in blue, you press enter directly, then this option is activated, the file will be saved directly from enter, ok, and the second is that you have put a cursor in the word here, if you enter control, then the page break will happen, remember control enter Page Break. You should also know the combination of Ctrl Enter and Enter. That's why I have told you. Okay, I hope you have understood this. Now I will tell you how to use the space bar. You will say, space bar is for kids, sir. Why are you telling? It is to give space. But it also has a shortcut. If we want to select a column in Excel, I have put the cursor in it and I have pressed control space, column is selected and I want to select row, I have pressed shift space shift space row selection, control space column selection, space is used, right so we have learnt about these big shortcut keys, what is the use of back keys and where is it used, we have learned about these big shortcut keys what is the use of these and where is it used, we will see now we will learn about arrow keys arrow keys are our pending and we will understand it first arrow keys, arrow keys can be used up and down if you say up and down, right and left arrow keys are there, we know but if any application is open, then this application is open here then see like this, windows left will go to left windows right right will come to right, Windows left left, Windows right right. So in Windows left right you can use it, right and word shift right shift left is used for this selection see in word also shift right shift up arrow shift down arrow shift right left you can use it for this selection you can use it for direction and selection and how to use these arrow keys definitely you must have understood arrow to use arrow keys arrow keys, navigation keys are also called for navigating the page it is used up and down, left and right, ok after navigation keys, we move on to next keys which you can see our keys are here by tapping I will tell you about the use of tab here because it is used a lot in Word when you are writing a professional letter then you have to set a tab you have set it on 1, 3, 4 now you have set the tab you have set the tab you have to click on the left alignment tab you can see the L tab what happens with this tab as you press the tab button on the keyboard your 1 page will jump you can write anything here as you press the tab, it will jump to 3 as you press tab again, it will jump to 4 enter and press tab so with this tab you can write content in alignment in many places while writing a professional letter you need to press tab and you can use this tab button on keyboard you can use tab button to switch if you press alt, then you can go to another program or another explorer file from one program, whatever open program you can see here and you can go to this too, tap, tap, go from this to this, go from this to this or tap windows, in this way you get the option to take the whole desktop, new desktop, you can do it from desktop option so you can use alt tab, windows tab and tab as well after tab you can see caps lock is given below so if i press caps lock then light will be on and off on keyboard and all these are standard format on keyboard if i keep it on then it will be capital type if i keep it off, it will be capital type if I keep it off, it will be small type I don't have to give much information about caps lock I have enough information to write capital small and kids know it kids means the computer users ok so now let's move forward that is the shift key shift was on both the sides because when you have to type capital letter you have to do fast selection so you can use shift from both sides if I want to shift A, I will press shift on right side and A on left side if I want to type P on keyboard, I will press shift on left hand and right hand with P so capital letter comes from shift and caps lock will be on so that letter will come in capital and caps lock will be off so that letter will come in capital and caps lock will be on so that letter will come in small so my caps lock will be on the keyboard now whatever I will do with shift will come in small so this is vice versa caps lock will come in small and, it will come in small. So this is vice versa. Remember, if caps lock is on, it will come in small and if caps lock is off, it will come in capital. So you want to write shift in one alphabet capital like computer's C capital, so shift C here I have closed caps lock first shift C and then computer In this way, you can use shift for one alphabet and I have told you a lot of combinations of shift we have seen different combinations for selection etc. Control is used in full combination if you want to control your computer then you have to have command on control key Control A, Control B, Control C, Control D and I am going to tell you in all the shortcut keys, Control A to Z Don't worry, so we will see all the combinations with control, next shortcut key is windows, if you press windows M then it gets minimized if you press windows M then you can minimize any software but to maximize it you have to use mouse but if you press windows D and again press windows D then it gets minimized so there are many combinations of windows and I have already made a blog on it which I am giving you in the description a blog of windows combination, what are the combinations of windows that you should know, there is a separate blog of shortcut key you must watch that, there is a link in the description for you I have made all the things and I am giving you all of them in this blog now I want to move forward and if you press the windows button then you will see the windows key after windows there is a lot of alt key combination alt tab 4 means exit and i have shown you the combination of alt tab before so we have seen the combination of alt tab so on both sides of the keyboard they were giving the keyboard so that you can use them quickly because they are used more in combination and regular now we will move towards numeric keypad and then we will move towards alphabetic keypad because we are going to learn A to Z keys in alphabet now in numeric keys first of all we will know that you have been given a num lock which you don't want to type a number so turn off the num lock and if you turn off the number lock and if you turn off the num lock then your cursor in excel if you go to type any number then your cursor will be down see it is typing 2, if I turn off the num lock means I don't want to use the number pad so I turned off the num lock now if I press 2 it will be down, if I press 8 it will be up if I press 6 it will go to right, if I press 4 it will go down, if I press 8 it will go up, if I press 6 it will go right, if I press 4 it will go left so arrows will be activated on the key of number, if you see carefully arrows are given on 2, 4, 8 and 6 and you can use number key as navigation if I use number lock, suppose I have 20 divided by 5 in excel for dividing and multiplication I can use asterisk minus and plus are also given there to do minus and plus you can use all these for mathematical calculation you can also use numeric keypad for mathematical calculation so you got to know this and I want to tell you an interesting combination of numlog which you should know if you open file explorer windows e and i select any drive and i want to see all the sub folders in it all of them so i will press numlog and after that I will press multiplication sign with number lock so all the folders are opening automatically so I will close it, it will take a lot of time because I have many folders in it so you can use all the folders to open them together this is an interesting shortcut, it is important so you can use this as an interesting shortcut you can use it like this but I will tell you about Numrock or Numeric keypad because it is used for calculation now we will learn about Alpha Numeric keys and then we will learn about Alphabetic keys Alpha Numeric keys are shown on your keyboard first of all, in Alpha Numeric keys you can see a Tilt sign which you can use to bring the general format in excel means suppose there is a number here and I will turn on the numeric keypad I will use it in excel, mostly it will be used in excel combination the number I have typed here, I have taken it in the number format see here, in the number format, this is the number and above is the number I want to here is in the number format I want to convert it to general again so I will press control shift and tilt button I will focus on general see how the number is coming if I want to convert it to number again then I don't need to go here there is a shortcut for that we will use control shift and exclamatory we are using alpha numeric keys control shift and exclamatory sign here comes the number format remember if you want to type this exclamatory sign directly then you will write shift and exclamatory on the keyboard like this shift and press exclamatory sign because if you press directly then 1,2,3,4 will come there it is alphanumeric so numbers will also come there shift at the rate, see this shift hash, see this shift dollar will come like this so here what I did is I converted it to number format with control shift and exclamatory but I want to see it in time format so control shift at the rate it came in time format, see here it is showing in time format, then control shift at the rate, it came in time format, see time format, you can see it in time, you don't have to tell, time format came there and in date format, control shift hash is required, which is our alphanumeric keys, which is one after the other, press it with control shift, ok, control shift dollar if I press, then it will come in dollar, control shift percentage if I press, then it will come in dollar if I press control shift % then it will come in percentage format in excel these shortcut keys are used a lot because if you want to change the number format quickly then you can press control shift exclamatory at the rate hash dollar percentage now I am pressing next shortcut key control shift exponentiation I am pressing this shortcut key means the sign which is showing control shift 6 that is sign of exponentiation and it is difficult to say but you can try it after pressing 6 or after pressing the sign of exponentiation here it converts to scientific format this is the scientific format here you can see it so to convert this format you can use it with control shift ok after that here is end sign you can press shift and end ctrl shift and end is not used here but end is used here in many places if you want to write a content here you can use it to write the value of the text and number like I want to write rupees here so I will write in inverted comma in excel and then end and I will join the value like this so you can see the result of this you can join any content sale by this way and with the help of key and in the same way amp AND key is used in many places I have told about this key, I didn't get any shortcut keys for this I have checked it on google and I have never used it if you know that there is any combination of this key with control and shift in any software then you must tell me after that comes next control shift asterisk I have not made any shortcut key for this right after that comes next control shift asterisk it also has no shortcut keys asterisk shortcut keys I told you earlier if you press number and asterisk then its num lock means not number but num lock and asterisk I told you this so if you press num lock and asterisk then display sub folders which we have known about it but asterisk and control shift has no combination remember friends after that comes control and open bracket by which we will hide rows open bracket as you can see if I press it with control then row will be hide see 28 number row is hide remember this is simple suppose I put cursor anywhere this is 31 so I put control in open bracket I press it here, then it hides the road, if I want to hide the road, then I will press the control shift open bracket, control open bracket hide roads, control shift open bracket show roads, you can use this shortcut here, open bracket is used with control shift and control, remember, if you do it with control, then hide and then control shift and then it will show if I press control close bracket then column will hide but if I want to show again then I have to press control z button to show here control shift close bracket is not there control open bracket will hide column control shift close will not show here with the control close bracket and then I will undo the shift close and then I will hide the column with the control close bracket and then I will undo the shift close bracket and then I will undo the shift close bracket and then I will undo the shift close bracket suppose I want to delete all these rows so I select it and press ctrl minus if you want to delete a column then select it and press ctrl minus I want to add a column here, press ctrl plus you can press plus on keyboard or ctrl shift plus, press ctrl shift with these keys ctrl minus you will press directly and press Ctrl Shift Plus because if you press Ctrl and directly plus button if I used Ctrl Plus from number pad then it will be direct but if you want to use this one which I have told you in Alpha Numeric Keys then you have to use Ctrl Shift and Plus in Alpha Numeric Keys to add new column and if I am not pressing ctrl shift plus but pressing alt is equal to but I will press alt is equal to because I have not used shift when I use shift then upper keys are used so I am pressing alt is equal to because both plus and is equal to are also coming in this key so I pressed alt is equal to here comes the sum of auto sum alt is equal to for taking automatic sum here alt is equal to directly that sum formula comes press enter button it will work so we know how to use plus minus definitely we have seen this alpha numeric keys but with this below you get some brackets also we need to know about them also like here but you will also get some brackets below we need to know about them also like here we are getting square bracket so if I select this in word suppose I take paragraph here again and by selecting this paragraph I want to reduce its font size so I can use shortcut control open square bracket font size will be reduced, decrease font and increase it key control open square bracket font size will be less decrease font and increase to control close square bracket increase increase increase increase increase increase control open square bracket square bracket because curly braces will take some shift button press when you have to press then shift button press curly braces will come but I am pressing with control only then here is a control open square bracket see open square bracket close square bracket open will be smaller, decrease font and close will be bigger so open and close both are square bracket then next to the shortcut is a backslash shortcut and pipe shortcut backslash is direct type without shift backslash is mostly used to access any folder in network like here I have kept folder in network so in run command I will give backslash twice and then the folder or the name of the network computer it will access the folder of that computer so this is used at that time in many places it is used to give folder access and folder path. of backslash. Right, there is no shortcut for this. But I have told you its usage where it can be done. Next, if you want to know the use of control colon or semi colon then come to excel and here if you type control colon then date comes. Remember. Control colon. Date will come. If you do control colon here then date will come control colon date will come if you type control shift colon then time will come current time, now I am recording I am typing control shift colon current timing is coming which is system time you can see the time in the bottom and today's date of recording will come control shift and this button I will press colon again control shift and colon and control semicolon remember control shift and colon is called insert current time control semicolon is called insert date remember if you press the same keys with control then it will become insert date and current date we have used this shortcut for insert date and current date for current date and timing we have used this shortcut then on the right side you will see another one which gives you inverted commas in excel you can use inverted commas in different formulas or if you type single inverted in excel means you don't press shift you type directly then you can convert any number in text format to convert any number in text format to convert any number to text format first single inverted comma you can use single inverted comma here so we know single inverted double inverted we can press with shift no shortcut is being made here but you can use it in excel in different formulas and you know in word you can use it in excel in different formulas and in word you know inverted comma you can use it to write something in inverted comma after that next is control shift greater than and less than which you can see on the keyboard now I will use it in word shift greater than that's why I said greater than less than sign comes I will use it with control shift so this greater than will be like this and less than will be like this control shift greater than will be like this and less than will be like this control shift greater than will increase and control shift less than will decrease and you can use this in excel in different formulas greater than value to show less than value to show it is used more in excel you can call it as a mathematical sign or symbol after that comes forward slash normally we call it as slash and question mark there is no shortcut key for this but you can use it to take question mark and forward slash symbol so we have seen almost all the keys on the keyboard just A to Z keys we don't need to tell you we type A B C D M but I will tell you in combination in this blog I will tell you from control A to control Z shortcut keys so that you get knowledge that when we can use it you know that we use A to Z, A, B, C, D for typing daily but control A is used in word for select all not only in word but also in Excel, PowerPoint, anywhere. Even on Windows Explorer, here on desktop, press the Ctrl A button. You can delete all the files by selecting them. You can do whatever you want with those files. Ctrl A, select all. Right. Ctrl B, the text selected will be bold here we come I select this text and press control B button it will be bold right bold means it is little bit rough you can see so you don't have to do all this bold suppose you have to highlight any word you have to show people this word you have to bring their attention so you can do this bold if you have read books then you must have seen some words are bold so you will know that you have to select that and bold it if you have read books then you must have seen some words are bold you will know that select that and bold it if you want to write repeat then press control c it will be copied but it will not repeat it will come only when you press control v v velocity v control v control v paste control c remember control c copy I will press control c on keyboard and it C is for copy I will press CTRL C on keyboard and it will copy when I press CTRL V it will paste the copied text will go to clipboard I have already made a blog on clipboard it is available on Learn More channel I will give the link in description I select it and copy it after copying it comes in clipboard so ctrl c is copy and ctrl b is paste what will happen with ctrl d? it will duplicate but wait a minute, if you press ctrl d directly in word then it will take font dialog box it will take the font dialog box it will not duplicate it, because it has not found anything, you will have to take something if you have taken any shape, picture, photo, whatever you have taken if you press Ctrl D by selecting it then it will duplicate it, what's the matter, Ctrl D duplicate in Word, Excel, PowerPoint, we use this to duplicate things even in PowerPoint, my PowerPoint is open only so I select this last slide and press CTRL D so here you will see duplicate of that slide so to duplicate slide in PowerPoint or images or charts whoever you want to duplicate, CTRL D in Excel, CTRL D is used very well here is content, Suppose take an example. Here is a content written. And I have to repeat this content. Control D. You can repeat the formula also. Suppose you have a formula typed here. Suppose you have done this cell. Whatever you have done, you have done the formula. And from here to this the formula given above should come down. Control D. See this. see this formula comes from control D so control D you know what happens in excel it is called fill down same formula will be filled down ok that's it we have seen control D duplicate control E flash fill is used in excel if you haven't done it then use it in excel it is very interesting and I have made a blog of 11 of its magic from different flash fields, I want to show you one magic that in excel you have written a text suppose I will write the name and I have written the name as Satish Dhowde but I have written it in small I will write 2-3 names, I will quickly now what you have to do is, you need to write these names in capital. All of them. You have written in small. So you don't have to apply formula for this. You write Satish Dhode and press the Ctrl E button. What a thing! What a thing! What a thing! You need this in proper case. You have to write S capital and D small case you need to write S and D so write it properly ctrl e button as you write it will be in same format if you want to separate satish then write satish and press ctrl e what is happening you need to separate dhawla so here I write dhawla and press ctrl e there are many things like this, control E, this is a flash field in excel and in word it is control E and center alignment means here I have written a chapter and I want to take it in center, so I will select it, select it first control E, center alignment, right, control E we have learnt, now Now we know about Ctrl F I have to find something here I have to find a big paragraph I have to find someone's name I will press Ctrl F It is asking what do you want to find I want to find where is smart word Here you can see smart word and I want to see where is word see where is the word? Where is the word? See, it is highlighted everywhere. So you can find the word smartly here. If you want to find the word, then you can press control F to find it. And if you want to replace the word, then you can press control H. As it has been written many times here, I write any name and suppose Anil is good boy, I write a sentence like this and I have to change Anil everywhere in this, right, Anil is good boy, I have written, change Anil and write zero, anything is written, then I will press control H button, control H replace, remember, I am telling the replace with find immediately because after app G comes in between G I will tell later first ctrl app find then replace I am telling immediately because it will replace by finding the word here both are used more find and replace together that's why I am telling replace immediately so now what I have to do is here which is written unil or good here which is written good I have done it bad right and replaced all here i have written good as bad and replace all here instead of good replace bad all done we made four replacement all the words are bad means all the words are bad and instead of boy if you want to write girl then in find out you will write boy and in replace with you will write girl and click on replace all button and see the magic bro anil is bad girl i am not saying this computer is saying this and in replace with you will see girl and click on replace all button and you will see magic by anil is bad girl I am not saying this, computer is saying this if anil is someone's name then sorry bro ok so here this trick is used by amir khan in 3D8 if you have seen that movie carefully so pause at that time where you are seeing amir khan so where amir khan, he uses find and replace option you know what he replaces, but control H used by Aamir Khan, I am telling you control H you can also use, you use it in many places, like you want to change the old agreement you want to change the year in it, whatever year is there, if 2021 then you want to do it in 2021 then you can do it in 2022 so you can definitely do it with ctrl-h this is a shortcut key which saves a lot of time you don't have to find that word it will find and replace it so ctrl-f find ctrl-h replace now let's know about ctrl-g ctrl-g go to and f5 also has go to if you press f5 then go to comes ctrl-g also, go to and F5 also has goto, if you press F5, then goto comes, control G also has goto, we can jump on any page with goto, enter the page number here, if you have the page number, then it will come directly, goto control G goto, in excel also goto, in word also goto, in PowerPoint also goto, goto goto goto, go wherever you want to go, ok, after that comes control I, you want to make it italic control I the word is tilted a little italic right control I control I control I control I italic in the word control J justify alignment if you see this paragraph then it is aligned in left not in right so I select this paragraph completely control J see you see see again control J control J right side left side left side left side is already aligned right side is also aligned control J justify alignment press and see suppose we come to excel here I want to link to a file or website so I will go to the file I clicked I have the important file I have written the name of the file here, press the control button and select the file from here You can show the file you want to show, like I took any HTML file here Now I will click on it, hyper is done here see this is open here right so this will definitely explain to you control k control k means hyperlink give in word also you can do in excel also after that in word if you have taken any text in center you see here you have to take it in left control l control e center control l left now left R, that is Right If you want to take in Right, then Ctrl R, Ctrl L, Left, Ctrl E, Center Remember for alignment, Ctrl L, Ctrl E, Ctrl R, Ctrl J are used for alignment And I have told all these 4 together Let's know about Ctrl M If I want to take this paragraph a little further, if I want to increase the indent then I can select the paragraph and press ctrl m If I want to keep some image or print something on the left side then I can press ctrl m and increase the indent If I press ctrl shift m then indent will decrease and if I press ctrl m then indent will increase You can see the indent in the scale indent is increasing here, this is indent and if you press ctrl shift m it goes back right, now see what is indent or all these things in microsoft word like how to set up scale, page layout, printing, letter how to write letter professionally, letters and mailing if you want to know all these things then I have already designed a course professionally of microsoft word or if you want to know all these things then I have already designed a course on Microsoft word or if you want to learn Excel in detail then there is a professional course on it my course is ready for all these things with ISO certificate you will get all the courses on my platform I have given the link of the platform in the description, you can check it if you are interested in ISO certificate, if you think that you are able to understand what Sati sir is teaching so you like my teaching style and you are able to understand what I am teaching you are getting interest in learning something new online so immediately convert your interest and engage yourself in these courses go and enroll, there are very few courses available here you can learn online at home and we are providing whatsapp support if you have any doubt related to buying these courses you can call us, you can learn online courses at home and we are providing whatsapp support if you have any doubt related to buying this course then you can call us you can whatsapp us so for now lets move ahead I have told you to become an expert so do what you should here we will move towards next shortcut which is control N new document its very simple control N new document right, I have to close this this file is closed by control W I will tell you further also Ctrl N new document right, I have to close this Ctrl W will close this Ctrl N new document Ctrl O open file the first file you made open from recent files or you can open from browse Ctrl O open Ctrl F12 open Ctrl O open Ctrl P print this file comes from print preview mode and it comes from control f2 i have told you this too, control f2 and control p, print remember all the shortcuts control shift q, this is a shortcut key with which you can convert this paragraph to symbol means there is no shortcut key of control q, i don't know, i mean to say but there is control shift Q that is I know so here I want to tell you press control shift Q it converts into symbol now there is no use of it but there is shortcut key of control shift Q you can find out why there is no shortcut key of control Q and if you find it in description, no in comment ok so in comment write that shortcut key in the comment, if you find it, then the controller is PQR, the controller is the right element, I had told you earlier, control s save, save the file, control s right, save this file, save it, whatever name you want to give, if you have made a file, then you need to save it. So as soon as you press Ctrl S, the save dialog box comes and as soon as you click the save button, you can save this file. Basically, you will also be asked the name in a dialog box. Now this is my directly online connected, so here I am telling this kind of dialog. But after pressing Ctrl S in your computer, a dialog box will come in this way. Actually, it is being saved directly on my Microsoft account. But as soon as you press Ctrl S and you get this dialog box it comes in different versions when you are logged in so we have saved Ctrl S and then we get Ctrl T Ctrl T is very less used in Word if I press Ctrl T here so it is not indented but it changes the tab positions a little but in Excel if you have a table and you want to convert it to a table then you can use control T control T is being converted to a table and it has many uses from table data is automatically calculated automatic formula is applied query is also made from table which I have explained in detail in my excel course so control T Insert Table in Excel you get readymade formatted table by selecting range after that only few shortcuts are remaining and if you are watching the blog till now then you will be definitely smart and you have become very smart in keyboard because you have watched such a big blog you have to believe that you have watched such a big blog online because people waste 3 hours to watch a movie there are such people but you are not one of them, you are studying for so long you are utilizing yourself, definitely you will become something in life, you will become successful this is my saying, for now let's move ahead, control u underline, underline comes control u underline will be removed again, if you want to give underline then give it if you don't want to hit the line I mean by hitting the line underline underline talk about hitting the line don't take the wrong meaning There are many meanings in Hindi, okay, so hit the line here, I mean to say line draw and underline I told control V, after U comes V and V means paste, if you want to paste the copy of control C, then paste control V ok control V paste, after that comes control W close so I press control W here, this document close, do you want to save it, I don't want to save it I didn't keep anything important in it, this bad girl thing is not important, I want to close it so control W close will be asked for, if you want to save then you can save here after that I took paragraph again and here this content I have to cut from here cut control X, cut it but did not delete, control below also control X is cut from one place and paste from other place take this example like this that if you have a magazine and you like a photo of it If you cut it from a piece of paper, it will not remain in the magazine It will come to you, cut and paste But if you take a xerox, it will be copy paste Right, this is the difference between cut paste and copy paste You cut it from a piece of paper, cut paste You made a xerox, copy paste So here cut paste and copy paste is definitely understood after cutting it is necessary to paste after copying it is also necessary to paste then only you will know the result and now we will move towards final 2 shortcuts which is everyone's favorite because in life your mistakes are not measured but in computer your mistakes are measured so reduce your mistakes in life or don't do it think before doing whatever you want to do so in life or don't do it, think before doing it so there is no undo in life, undo means one step back if you accidentally deleted this data in your computer and you thought this data was very important press the control Z button, it will come because here in word, excel, powerpoint everywhere control Z means undo right, one step backward, undo see, suppose I bolded here, underlined here I did all this format, now I have to undo ctrl z, z, z, z, all things are undoing all things are undoing, ctrl z undoes see, all the things I did, all the things will undo here and after undo, Pandu comes I am sorry, Pandu doesn't come, it comes to control Y control Y means whatever you undo, you can undo it again by pressing control Y so control Z and control Y are all favorite keys and they work in computer because they get chance to measure their mistakes so undo whatever mistake you made don't make mistake in life so this is the message i want to give you in the ending of this blog. Till then take care of yourself. Keep learning, keep learning. Bye Bye.
Keyboard Keys and Their Use
Function Keys
- Escape Key: Cancel / Close any Dialog Box / Exit Slide Show in PowerPoint
- F1: Open help Menu Window / Software
- F2: Rename File / Edit Cell Excel, CTRL + F2 - Print Preview
- F3: Shift + F3 = Change Case in Microsoft Word / Insert Function in Excel
- F4: Alt + F4 – Exit | CTRL + F4 – Close | Shift F4 – Go to Beginning
- F5: Refresh | Go To in Excel & Word | Slide in PPT | CTRL + F5 – Restore Window in Excel | Alt + F5 – Restore Window in Word
- F6: Use to Tab between Open software Options
- F7: Spelling & Grammar Check | Shift F7 – Thesaurus
- F8: Excel – Lock Cell Selection | Alt + F8 – Macro Dialog box
- F9: Calculate in Excel | Ctrl + F9 – Minimize Excel
- F10: Shift + F10 – Right click | Ctrl + F10 – Restore / Maximize, Inside word and Excel F10 work like ALT key
- F11: Fullscreen
- F12: F12 - Save as | in Browser – show Code | CTRL + F12 - Open
Navigation Keys
- Home: Go to the Home | CTRL + Home - Beginning of Page
- End: Go To End - CTRL + End- End of Page
- Insert: Insert Text in Override format | Shift + Insert - Paste
- Page Up: Scroll Up | Use to scrolling Page up
- Page Down: Use to Scroll Down Page wise
- Delete: Delete Content/ File / Folder
Other Keys
- Backspace: Erase Content | View the previous folder (Alt + Left Arrow) | Change Paragraph | Accept Dialog box | CTRL + Enter – Page break
- Spacebar: Shift + Space – Select Row | Ctrl + Space – Select Column
- Print Screen: Get Screenshot | Wind + Print Screen - Save screenshot
- Scroll Lock: Lock Reference while Scrolling
- Pause | Break: Pause – Running Task | Win + Pause – Show System Properties
- Num Lock: Turn off/on – Number key use
Directional Keys
- Up Arrow: Move Up | Shift Combination – to Select Above cells in excel
- Down Arrow: Move Down | Shift Combination – to Select Bottom cells in excel
- Right Arrow: Move Right | Shift Combination – to Select Right cells in excel, Ctrl + Right Arrow – Set application Window to the Right
- Left Arrow: Move Left| Shift Combination – to Select Left cells in excel, Ctrl + Left Arrow – Set application Window to the Left
Numeric Keys
- / : Divide Sign
- *: Multiplication Sign
- +: Plus Sign
- -: Minus Sign
Symbol Keys
- Ctrl + Shift + ~: Convert into General format (Excel)
- !: Ctrl + Shift + ! – Convert to Number format (Excel)
- @: Ctrl + Shift + @ – Convert to Time format (Excel)
- #: Ctrl + Shift + # – Convert to Date format (Excel)
- $: Ctrl + Shift + $ – Convert to Currency format (Excel)
- %: Ctrl + Shift + % – Convert to Percentage format (Excel)
- ^: Ctrl + Shift + ^ – Convert to Scientific format (Excel)
- &: Used to type Ampersand or And Symbol
- *: Used to type Asterisk Symbol
- (: Ctrl + ( - Hide Rows (Excel)
- |: Ctrl + Shift + ( - Unhide Rows (Excel)
- ): Ctrl + ) – Hide Columns (Excel)
- Ctrl + (-): Delete Rows/Column (Excel)
- Ctrl + Shift + (+): Add Rows/Column (Excel) | Alt + (=) - Auto sum Formula (Excel)
- Ctrl + [: Decrease Font Size (Excel)
- Ctrl + ]: Increase Font Size (Excel)
- |: Used to type Pipe and Backslash Symbol
- Ctrl + Shift + (:) - Insert Current Time (Excel) | Ctrl + (;) - Insert Current Time (Excel)
- : Used to type inverted Comma and Colon
- Ctrl + Shift + <: Decrease Font Size
- Ctrl + Shift + >: Increase Font Size
- ?: Used to type the Question mark and Slash Symbol
Shortcut Keys
- Ctrl + A: Select All Content
- Ctrl + B: Bold Selected Text
- Ctrl + C: Copy Selected Content
- Ctrl + D: Duplicate Content
- Ctrl + E: Flash Fill in Excel | Align Center in Word
- Ctrl + F: Find Text
- Ctrl + G: Go to
- Ctrl + H: Replace Text
- Ctrl + I: Italic
- Ctrl + J: Justify Alignment
- Ctrl + K: Hyperlink
- Ctrl + L: Left Alignment
- Ctrl + M: Increase Indent | Ctrl + Shift + M – Decrease Indent
- Ctrl + N: Insert New Document
- Ctrl + O: Open Document
- Ctrl + P: Print Document
- Ctrl + Q: Ctrl + Shift + Q – Convert Symbol Font in Word
- Ctrl + R: Right Alignment
- Ctrl + S: Save Document
- Ctrl + T: Insert Table in Excel
- Ctrl + U: Apply Underline
- Ctrl + V: Paste Copied Text
- Ctrl + W: Close
- Ctrl + X: Cut
- Ctrl + Y: Redo - One step forward
- Ctrl + Z: Undo – One step backward