{"id":1702,"date":"2018-11-27T15:09:51","date_gmt":"2018-11-27T09:39:51","guid":{"rendered":"https:\/\/www.joshtalks.com\/joshkosh\/?p=1702"},"modified":"2020-11-12T05:48:09","modified_gmt":"2020-11-12T00:18:09","slug":"ghar-baithe-asaani-se-ms-excel-ke-shortcuts-sikhe","status":"publish","type":"post","link":"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/computer-skills\/ghar-baithe-asaani-se-ms-excel-ke-shortcuts-sikhe\/","title":{"rendered":"Ghar Baithe Online MS Excel Shortcuts Kaise Seekhe In Hindi"},"content":{"rendered":"Pichle article mein apna <strong><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/career\/ghar-baithe-online-kaise-seekhein-ms-excel-in-hindi\/\" target=\"_blank\" rel=\"noopener noreferrer\">ghar baithe basic MS Excel<\/a><\/strong> ke baare me sikha. Is article mein aap MS Excel mein use kiye jaane wale &#8216;shortcuts&#8217; ke baare mein jaanege.\n\n<span style=\"font-weight: 400;\"><strong>MS Excel Shortcuts<\/strong> ka pata hona bahut hi zauri hota hai kyuki ye time aur mehnat bachane mein help karte hai. Shortcuts ko use karke aap asani se excel par kaam kar paynge. Shortcuts use karne se kaam karne mein time kam lagta hai. Shortcut use karne ke liye keyboard ki keys ka use kiya jaata hai. Ye shortcuts Excel ke alava aur bhi softwares jaise MS Word mein bhi use kiye jaate hai.\u00a0<\/span>\n\n<span style=\"font-weight: 400;\">Neeche main shortcuts and useable key combinations in MS Excel ki list di hui hai.<\/span>\n\n<em>Aur agar<\/em>\u00a0<em>inke alawa aapke mann mein koi aur sawal ya <b>MS Excel shortcuts<\/b>\u00a0se judi koi jankari chahte hain toh humare group se judein aur apna sawal puchein. Hum apki poori sahayata karenge. Humse judne ke liye\u00a0<strong>niche click karein<\/strong>\u00a0\u2013<\/em>\n<!-- Load Facebook SDK for JavaScript -->\n<div id=\"fb-root\"><\/div>\n<script><br \/>\n        (function(d, s, id) {<br \/>\n            var js, fjs = d.getElementsByTagName(s)[0];<br \/>\n            if (d.getElementById(id)) return;<br \/>\n            js = d.createElement(s);<br \/>\n            js.id = id;<br \/>\n            js.src = 'https:\/\/connect.facebook.net\/en_US\/sdk.js#xfbml=1&version=v2.11&appId=329612517637200&autoLogAppEvents=1';<br \/>\n            fjs.parentNode.insertBefore(js, fjs);<br \/>\n        }(document, 'script', 'facebook-jssdk'));<br \/>\n    <\/script>\n\n<!--Your Group Plugin for the Web code-->\n<div class=\"fb-group\" data-href=\"https:\/\/www.facebook.com\/groups\/joshkoshhindi\/\" data-width=\"350\" data-show-social-context=\"true\" data-show-metadata=\"false\"><\/div>\n<b>NOTE: Shortcuts me agar aapko ek saath do ya zyada keys ko press karna hain uske liye keys ke beech mein plus sign (+) likha gaya hai.<\/b>\n\n<iframe class=\"giphy-embed\" src=\"https:\/\/giphy.com\/embed\/X9dSqwYqQp9DO\" width=\"400\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe>\n\n<a href=\"https:\/\/giphy.com\/gifs\/educational-excel-shortcuts-X9dSqwYqQp9DO\">via GIPHY<\/a>\n<ul>\n \t<li><strong>Ctrl+A &#8211;<\/strong> Select all contents of a worksheet.<\/li>\n \t<li><strong>Ctrl+B &#8211;<\/strong> Bold all cells in the highlighted section.<\/li>\n \t<li><strong>Ctrl+C &#8211;<\/strong> Copy all cells in the highlighted section.<\/li>\n \t<li><strong>Ctrl+D &#8211;<\/strong> Fill down. Fills the cell beneath with the contents of the selected cell. To fill more than one cell, select\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 the source cell and press Ctrl+Shift+Down to select multiple cells. Then press Ctrl+D to fill them with the contents of the original cell.<\/li>\n \t<li><strong>Ctrl+F &#8211;<\/strong> Search current sheet<\/li>\n \t<li><strong>Ctrl+G &#8211;<\/strong> Go to a certain area<\/li>\n \t<li><strong>Ctrl+H &#8211;<\/strong> Find and Replace<\/li>\n \t<li><strong>Ctrl+I &#8211;<\/strong> Put italics on all cells in the highlighted section<\/li>\n \t<li><strong>Ctrl+K &#8211;<\/strong> Inserts a hyperlink<\/li>\n \t<li><strong>Ctrl+N &#8211;<\/strong> Creates a new workbook<\/li>\n \t<li><strong>Ctrl+O &#8211;<\/strong> Opens a new workbook<\/li>\n \t<li><strong>Ctrl+P &#8211;<\/strong> Print the current sheet<\/li>\n \t<li><strong>Ctrl+R &#8211;<\/strong> Fill right. Fills the cell to the right with the contents of the selected cell. To fill more than one cell, select\u00a0 \u00a0 \u00a0 the source cell and press Ctrl+Shift+Right to select multiple cells. Then press Ctrl+R to fill them with the contents of the original cell.<\/li>\n \t<li><strong>Ctrl+S<\/strong> &#8211; Saves the current worksheet<\/li>\n \t<li><strong>Ctrl+U &#8211;<\/strong> Underlines all cells in the highlighted section<\/li>\n \t<li><strong>Ctrl+V &#8211;<\/strong> Pastes everything copied onto the clipboard<\/li>\n \t<li><strong>Ctrl+W &#8211;<\/strong> Closes the current workbook<\/li>\n \t<li><strong>Ctrl+X &#8211;<\/strong> Cuts all the cells in the highlighted section<\/li>\n \t<li><strong>Ctrl+Y &#8211;<\/strong> Repeats the last entry<\/li>\n \t<li><strong>Ctrl+Z &#8211;<\/strong> Undo the last section<\/li>\n<\/ul>\n<ul>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+1 &#8211; <\/b><span style=\"font-weight: 400;\">Changes the format of the selected cells.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+2 &#8211;<\/b><span style=\"font-weight: 400;\"> Bolds all cells in the highlighted section.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+3<\/b> <b>&#8211; <\/b><span style=\"font-weight: 400;\">Puts italics all cells in the highlighted section.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+4<\/b> <b>&#8211; <\/b><span style=\"font-weight: 400;\">Underlines all cells in highlighted section.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+5<\/b> <b>&#8211; <\/b><span style=\"font-weight: 400;\">Puts a strikethrough all cells in the highlighted section.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+6<\/b> <b>&#8211; <\/b><span style=\"font-weight: 400;\">Shows or hides objects.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+7<\/b> <b>&#8211; <\/b><span style=\"font-weight: 400;\">Shows or hides the toolbar.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+8<\/b> <b>&#8211; <\/b><span style=\"font-weight: 400;\">Toggles the outline symbols.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+9<\/b> <b>&#8211; <\/b><span style=\"font-weight: 400;\">Hides rows.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+0<\/b> <b>&#8211; <\/b><span style=\"font-weight: 400;\">Hides columns.<\/span><\/li>\n<\/ul>\n<ul>\n \t<li><b>Ctrl+Shift+: &#8211;<\/b><span style=\"font-weight: 400;\"> Enters the current time.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+; &#8211;<\/b><span style=\"font-weight: 400;\"> Enters the current date.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+` &#8211;<\/b><span style=\"font-weight: 400;\"> Changes between displaying cell values or formulas in the worksheet.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+&#8217; &#8211; <\/b><span style=\"font-weight: 400;\">Copies a formula from the cell above.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Shift+&#8221; &#8211;<\/b><span style=\"font-weight: 400;\"> Copies value from cell above.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+- &#8211; <\/b><span style=\"font-weight: 400;\">Deletes the selected column or row.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Shift+= &#8211;<\/b><span style=\"font-weight: 400;\"> Inserts a new column or row.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Shift+~ &#8211; <\/b><span style=\"font-weight: 400;\">Switches between showing Excel formulas or their values in cells.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Shift+@ &#8211; <\/b><span style=\"font-weight: 400;\">Applies time formatting.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Shift+! &#8211;<\/b><span style=\"font-weight: 400;\"> Applies comma formatting.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Shift+$ &#8211;<\/b><span style=\"font-weight: 400;\"> Applies currency formatting.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Shift+# &#8211;<\/b><span style=\"font-weight: 400;\"> Applies date formatting.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Shift+% &#8211;<\/b><span style=\"font-weight: 400;\"> Applies percentage formatting.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Shift+^ &#8211;<\/b><span style=\"font-weight: 400;\"> Applies exponential formatting.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Shift+* &#8211;<\/b><span style=\"font-weight: 400;\"> Selects the current region around the active cell.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Shift+&amp; &#8211;<\/b><span style=\"font-weight: 400;\"> Places border around selected cells.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Shift+_ &#8211;<\/b><span style=\"font-weight: 400;\"> Removes a border.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl++ &#8211; <\/b><span style=\"font-weight: 400;\">Insert.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+- &#8211;<\/b><span style=\"font-weight: 400;\"> Delete.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Shift+( &#8211;<\/b><span style=\"font-weight: 400;\"> Unhide rows.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Shift+) &#8211;<\/b><span style=\"font-weight: 400;\"> Unhide columns.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+\/ &#8211;<\/b><span style=\"font-weight: 400;\"> Selects the array containing the active cell.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+\\ &#8211;<\/b><span style=\"font-weight: 400;\"> Selects the cells that have a static value or don\u2019t match the formula in the active cell.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+[ &#8211;<\/b><span style=\"font-weight: 400;\"> Selects all cells referenced by formulas in the highlighted section.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+] &#8211;<\/b><span style=\"font-weight: 400;\"> Selects cells that contain formulas that reference the active cell.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Shift+{ &#8211; <\/b><span style=\"font-weight: 400;\">Selects all cells directly or indirectly referenced by formulas in the highlighted section.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Shift+} &#8211; <\/b><span style=\"font-weight: 400;\">Selects cells which contain formulas that directly or indirectly reference the active cell.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Shift+| (pipe) &#8211;<\/b><span style=\"font-weight: 400;\"> Selects the cells within a column that don\u2019t match the formula or static value in the active\u00a0 \u00a0 \u00a0 cell.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Enter &#8211;<\/b><span style=\"font-weight: 400;\"> Fills the selected cells with the current entry.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Spacebar &#8211; <\/b><span style=\"font-weight: 400;\">Selects the entire column.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Shift+Spacebar &#8211;<\/b><span style=\"font-weight: 400;\"> Selects the entire worksheet.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Home &#8211; <\/b><span style=\"font-weight: 400;\">Move to cell A1.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+End &#8211;<\/b><span style=\"font-weight: 400;\"> Move to last cell on worksheet.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Tab &#8211; <\/b><span style=\"font-weight: 400;\">Move between Two or more open Excel files.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Shift+Tab &#8211;<\/b><span style=\"font-weight: 400;\"> Activates the previous workbook.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Shift+A &#8211; <\/b><span style=\"font-weight: 400;\">Inserts argument names into a formula.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Shift+F &#8211;<\/b><span style=\"font-weight: 400;\"> Opens the drop-down menu for fonts.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Shift+O &#8211;<\/b><span style=\"font-weight: 400;\"> Selects all of the cells that contain comments.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Shift+P &#8211;<\/b><span style=\"font-weight: 400;\"> Opens the drop-down menu for point size.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Shift+Insert &#8211; <\/b><span style=\"font-weight: 400;\">Pastes what is stored on the clipboard.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Shift+Page Up &#8211;<\/b><span style=\"font-weight: 400;\"> In a single column, highlights all cells above that are selected.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Shift+Page Down &#8211;<\/b><span style=\"font-weight: 400;\"> In a single column, highlights all cells above that are selected.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Shift+Home &#8211;<\/b><span style=\"font-weight: 400;\"> Highlights all text to the left of the cursor.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Shift+End &#8211;<\/b><span style=\"font-weight: 400;\"> Highlights all text to the right of the cursor.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Shift+Up Arrow &#8211; <\/b><span style=\"font-weight: 400;\">Extends the highlighted area up one cell.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Shift+Down Arrow &#8211;<\/b><span style=\"font-weight: 400;\"> Extends the highlighted area down one cell.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Shift+Left Arrow &#8211;<\/b><span style=\"font-weight: 400;\"> Extends the highlighted area left one character.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Shift +Right Arrow &#8211;<\/b><span style=\"font-weight: 400;\"> Extends the highlighted area right one character.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Alt+Tab &#8211; <\/b><span style=\"font-weight: 400;\">Cycles through applications.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Alt+Spacebar &#8211; <\/b><span style=\"font-weight: 400;\">Opens the system menu.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Alt+Backspace &#8211; <\/b><span style=\"font-weight: 400;\">Undo.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Alt+Enter &#8211; <\/b><span style=\"font-weight: 400;\">While typing text in a cell, pressing Alt+Enter will move to the next line, allowing for multiple lines\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 of text in one cell.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Alt+= &#8211;<\/b><span style=\"font-weight: 400;\"> Creates a formula to sum all of the above cells.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Alt+&#8217; &#8211;<\/b><span style=\"font-weight: 400;\"> Allows formatting on a dialog box.<\/span><\/li>\n<\/ul>\n<ul>\n \t<li style=\"font-weight: 400;\"><b>F1 &#8211;<\/b><span style=\"font-weight: 400;\"> Opens the help menu.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>F2 &#8211; <\/b><span style=\"font-weight: 400;\">Edits the selected cell.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>F3 &#8211;<\/b><span style=\"font-weight: 400;\"> After a name has been created, F3 will paste names.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>F4 &#8211; <\/b><span style=\"font-weight: 400;\">Repeats last action. For example, if you changed the color of text in another cell, pressing F4 will change the text in cell to the same color.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>F5 &#8211; <\/b><span style=\"font-weight: 400;\">Goes to a specific cell. For example, C6.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>F6 &#8211;<\/b><span style=\"font-weight: 400;\"> Move to the next pane.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>F7 &#8211; <\/b><span style=\"font-weight: 400;\">Spell check selected text or document.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>F8 &#8211; <\/b><span style=\"font-weight: 400;\">Enters Extend Mode.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>F9 &#8211;<\/b><span style=\"font-weight: 400;\"> Recalculates every workbook.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>F10 &#8211;<\/b><span style=\"font-weight: 400;\"> Activates the menu bar.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>F11 &#8211;<\/b><span style=\"font-weight: 400;\"> Creates a chart from selected data.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>F12 &#8211; <\/b><span style=\"font-weight: 400;\">Save As option.<\/span><\/li>\n<\/ul>\n<ul>\n \t<li style=\"font-weight: 400;\"><b>Shift+F1 &#8211; <\/b><span style=\"font-weight: 400;\">Opens the &#8220;What&#8217;s This?&#8221; window.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Shift+F2 &#8211; <\/b><span style=\"font-weight: 400;\">Allows the user to edit a cell comment.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Shift+F3 &#8211; <\/b><span style=\"font-weight: 400;\">Opens the Excel formula window.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Shift+F5 &#8211;<\/b><span style=\"font-weight: 400;\"> Brings up a search box.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Shift+F6 &#8211; <\/b><span style=\"font-weight: 400;\">Move to previous pane.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Shift+F8 &#8211; <\/b><span style=\"font-weight: 400;\">Add to selection.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Shift+F9 &#8211;<\/b><span style=\"font-weight: 400;\"> Performs calculate function on active sheet.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+F3 &#8211;<\/b><span style=\"font-weight: 400;\"> Open Excel Name Manager.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+F4 &#8211; <\/b><span style=\"font-weight: 400;\">Closes current Window.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+F5 &#8211; <\/b><span style=\"font-weight: 400;\">Restores window size.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+F6 &#8211; <\/b><span style=\"font-weight: 400;\">Next workbook.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Shift+F &#8211;<\/b><span style=\"font-weight: 400;\"> Previous workbook.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+F7 &#8211; <\/b><span style=\"font-weight: 400;\">Moves the window.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+F8 &#8211; <\/b><span style=\"font-weight: 400;\">Resizes the window.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+F9 &#8211;<\/b><span style=\"font-weight: 400;\"> Minimize current window.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+F10 &#8211;<\/b><span style=\"font-weight: 400;\"> Maximize currently selected window.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+F11 &#8211; <\/b><span style=\"font-weight: 400;\">Inserts a macro sheet.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+F12 &#8211;<\/b><span style=\"font-weight: 400;\"> Opens a file.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Shift+F3 &#8211;<\/b><span style=\"font-weight: 400;\"> Creates names by using those of either row or column labels.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Shift+F6 &#8211;<\/b><span style=\"font-weight: 400;\"> Moves to the previous worksheet window.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Ctrl+Shift+F12 &#8211; <\/b><span style=\"font-weight: 400;\">Prints the current worksheet.<\/span><\/li>\n<\/ul>\n<ul>\n \t<li style=\"font-weight: 400;\"><b>Alt+F1 &#8211; <\/b><span style=\"font-weight: 400;\">Inserts a chart.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Alt+F2 &#8211; <\/b><span style=\"font-weight: 400;\">Save As option.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Alt+F4 &#8211;<\/b><span style=\"font-weight: 400;\"> Exits Excel.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Alt+F8 &#8211; <\/b><span style=\"font-weight: 400;\">Opens the macro dialog box.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Alt+F11 &#8211; <\/b><span style=\"font-weight: 400;\">Opens the Visual Basic editor.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Alt+Shift+F1 &#8211; <\/b><span style=\"font-weight: 400;\">Creates a new worksheet.<\/span><\/li>\n \t<li style=\"font-weight: 400;\"><b>Alt+Shift+F2 &#8211;<\/b><span style=\"font-weight: 400;\"> Saves the current worksheet.<\/span><\/li>\n<\/ul>\nHum aasha karte hai ki Ms excel shortcut keys ke baare mein jaanke aapki MS Excel ki knowledge badh gayi hogi. Inn shortcuts ko yaad karne ke liye inki practice karna na bhule. Aap jitni excel ki practice karenge aap utne acche se sikh payenge.\n\n<a href=\"https:\/\/www.joshtalks.com\/joshkosh\/career\/ghar-baithe-online-kaise-seekhein-ms-excel-in-hindi\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>MS Excel ke basic tutorial ke liye yaha click kare<\/strong><\/a>\n\nAgar aap MS excel shortcuts ke alawa aur bhi koi shortcuts jaante hai toh comments section mein hume zarur bataye.\n\n<em>Agar abhi bhi aap <strong>MS Excel shortcuts<\/strong> se juda koi sawal ya koi jankari janna chahte hain toh humare Facebook group par ayiye aur apna sawal pucchiye, hum apki poori madad karenge. Group se judne ke liye\u00a0<strong>niche click karein &#8211;<\/strong><\/em>\n<!-- Load Facebook SDK for JavaScript -->\n<div id=\"fb-root\"><\/div>\n<script><br \/>\n        (function(d, s, id) {<br \/>\n            var js, fjs = d.getElementsByTagName(s)[0];<br \/>\n            if (d.getElementById(id)) return;<br \/>\n            js = d.createElement(s);<br \/>\n            js.id = id;<br \/>\n            js.src = 'https:\/\/connect.facebook.net\/en_US\/sdk.js#xfbml=1&version=v2.11&appId=329612517637200&autoLogAppEvents=1';<br \/>\n            fjs.parentNode.insertBefore(js, fjs);<br \/>\n        }(document, 'script', 'facebook-jssdk'));<br \/>\n    <\/script>\n\n<!--Your Group Plugin for the Web code-->\n<div class=\"fb-group\" data-href=\"https:\/\/www.facebook.com\/groups\/joshkoshhindi\/\" data-width=\"350\" data-show-social-context=\"true\" data-show-metadata=\"false\">\n<h2><strong>Join Josh Skills Basic Computer Skills Course<\/strong><\/h2>\n \n<figure class=\"wp-block-image is-resized\"><img src=\"https:\/\/josh-skills.s3.ap-south-1.amazonaws.com\/files_from_node\/1596533210761Basic%20Computer%20Skills.jpg\" alt=\"\" width=\"517\" height=\"279\" \/><\/figure>\n Aaj kal computer ka zamana hai. Har voh kaam jisme pehle bahut time,effort aur money waste hota tha abh asani se computer pe kiya ja sakta hai. Computer ka istamaal aaj kal har taraf kiya jata hai. Basic computer skills ana aaj ke waqt mai bahat hi zaruri hai. Basic computer skills sikhna isliye zaruri hai take aap apne worklife ko easy aur efficient bana sako. Aur is computer technology ka wisely istamaal kar sako.\n\n \n<div class=\"wp-block-buttons\">\n<div class=\"wp-block-button is-style-outline\"><a class=\"wp-block-button__link\" href=\"https:\/\/joshskills.app.link\/9bX0aGyjkbb\" target=\"_blank\" rel=\"noreferrer noopener\">Download Josh Skills App<\/a><\/div>\n<\/div>\n Is course mai aap Computer ke Basics pe gaur denge jaise:\n\n \n<ul>\n \t<li>Basics of a Computer system and it\u2019s operation.<\/li>\n \t<li>Internet Technology<\/li>\n \t<li>Email and Communication<\/li>\n \t<li>Use of Microsoft word, Microsoft Powerpoint and Microsoft Excel<\/li>\n \t<li>Introduction to Advanced Computer skills and tools<\/li>\n \t<li>Jobs that require computer skills<\/li>\n<\/ul>\n Toh aaj hi shuru kare apni learning journey Josh Skill ke courses ke sath.\n\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Pichle article mein apna ghar baithe basic MS Excel ke baare me sikha. Is article mein aap MS Excel mein use kiye jaane wale &#8216;shortcuts&#8217; ke baare mein jaanege. MS Excel Shortcuts ka pata hona bahut hi zauri hota hai kyuki ye time aur mehnat bachane mein help karte hai. Shortcuts ko use karke aap [&hellip;]<\/p>\n","protected":false},"author":16,"featured_media":11837,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"tdm_status":"","tdm_grid_status":""},"categories":[11004],"tags":[54],"yst_prominent_words":[5225,5215,5212,5220,5219,5224,5213,5211,5221,5227,5226,5216,5228,5214,5222,5217,4951,5218,5223,258],"_links":{"self":[{"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/posts\/1702"}],"collection":[{"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/comments?post=1702"}],"version-history":[{"count":16,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/posts\/1702\/revisions"}],"predecessor-version":[{"id":40336,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/posts\/1702\/revisions\/40336"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/media\/11837"}],"wp:attachment":[{"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/media?parent=1702"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/categories?post=1702"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/tags?post=1702"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/yst_prominent_words?post=1702"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}