{"id":92,"date":"2022-12-27T01:56:37","date_gmt":"2022-12-27T01:56:37","guid":{"rendered":"https:\/\/people.utm.my\/s-mariam\/?page_id=92"},"modified":"2022-12-27T01:56:37","modified_gmt":"2022-12-27T01:56:37","slug":"microsoft-excel-100-shortcuts-that-every-windows-user-should-know","status":"publish","type":"page","link":"https:\/\/people.utm.my\/s-mariam\/microsoft-excel-100-shortcuts-that-every-windows-user-should-know\/","title":{"rendered":"<strong>Microsoft Excel: 100 Shortcuts That Every Windows User Should Know<\/strong>"},"content":{"rendered":"\n<ol class=\"wp-block-list\">\n<li>Ctrl + N: To create a new workbook.<\/li>\n\n\n\n<li>Ctrl + O: To open a saved workbook.<\/li>\n\n\n\n<li>Ctrl + S: To save a workbook.<\/li>\n\n\n\n<li>Ctrl + A: To select all the contents in a workbook.<\/li>\n\n\n\n<li>Ctrl + B: To turn highlighted cells bold.<\/li>\n\n\n\n<li>Ctrl + C: To copy cells that are highlighted.<\/li>\n\n\n\n<li>Ctrl + D: To fill the selected cell with the content of the cell right above.<\/li>\n\n\n\n<li>Ctrl + F: To search for anything in a workbook.<\/li>\n\n\n\n<li>Ctrl + G: To jump to a certain area with a single command.<\/li>\n\n\n\n<li>Ctrl + H: To find and replace cell contents.<\/li>\n\n\n\n<li>Ctrl + I: To italicise cell contents.<\/li>\n\n\n\n<li>Ctrl + K: To insert a hyperlink in a cell.<\/li>\n\n\n\n<li>Ctrl + L: To open the CREATE TABLE IF NOT EXISTS dialog box.<\/li>\n\n\n\n<li>Ctrl + P: To print a workbook.<\/li>\n\n\n\n<li>Ctrl + R: To fill the selected cell with the content of the cell on the left.<\/li>\n\n\n\n<li>Ctrl + U: To underline highlighted cells.<\/li>\n\n\n\n<li>Ctrl + V: To paste anything that was copied.<\/li>\n\n\n\n<li>Ctrl + W: To close your current workbook.<\/li>\n\n\n\n<li>Ctrl + Z: To undo the last action.<\/li>\n\n\n\n<li>Ctrl + 1: To format the cell contents.<\/li>\n\n\n\n<li>Ctrl + 5: To put a strikethrough in a cell.<\/li>\n\n\n\n<li>Ctrl + 8: To show the outline symbols.<\/li>\n\n\n\n<li>Ctrl + 9: To hide a row.<\/li>\n\n\n\n<li>Ctrl + 0: To hide a column.<\/li>\n\n\n\n<li>Ctrl + Shift + :: To enter the current time in a cell.<\/li>\n\n\n\n<li>Ctrl + ;: To enter the current date in a cell.<\/li>\n\n\n\n<li>Ctrl + `: To change the view from displaying cell values to formulas.<\/li>\n\n\n\n<li>Ctrl + \u2018: To copy the formula from the cell above.<\/li>\n\n\n\n<li>Ctrl + -: To delete columns or rows.<\/li>\n\n\n\n<li>Ctrl + Shift + =: To insert columns and rows.<\/li>\n\n\n\n<li>Ctrl + Shift + ~: To switch between displaying Excel formulas or their values in cell.<\/li>\n\n\n\n<li>Ctrl + Shift + @: To apply time formatting.<\/li>\n\n\n\n<li>Ctrl + Shift + !: To apply comma formatting.<\/li>\n\n\n\n<li>Ctrl + Shift + $: To apply currency formatting.<\/li>\n\n\n\n<li>Ctrl + Shift + #: To apply date formatting.<\/li>\n\n\n\n<li>Ctrl + Shift + %: To apply percentage formatting.<\/li>\n\n\n\n<li>Ctrl + Shift + &amp;: To place borders around the selected cells.<\/li>\n\n\n\n<li>Ctrl + Shift + _: To remove a border.<\/li>\n\n\n\n<li>Ctrl + -: To delete a selected row or column.<\/li>\n\n\n\n<li>Ctrl + Spacebar: To select an entire column.<\/li>\n\n\n\n<li>Ctrl + Shift + Spacebar: To select an entire workbook.<\/li>\n\n\n\n<li>Ctrl + Home: To redirect to cell A1.<\/li>\n\n\n\n<li>Ctrl + Shift + Tab: To switch to the previous workbook.<\/li>\n\n\n\n<li>Ctrl + Shift + F: To open the fonts menu under format cells.<\/li>\n\n\n\n<li>Ctrl + Shift + O: To select the cells containing comments.<\/li>\n\n\n\n<li>Ctrl + Drag: To drag and copy a cell or to a duplicate worksheet.<\/li>\n\n\n\n<li>Ctrl + Shift + Drag: To drag and insert copy.<\/li>\n\n\n\n<li>Ctrl + Up arrow: To go to the top most cell in a current column.<\/li>\n\n\n\n<li>Ctrl + Down arrow: To jump to the last cell in a current column.<\/li>\n\n\n\n<li>Ctrl + Right arrow: To go to the last cell in a selected row.<\/li>\n\n\n\n<li>Ctrl + Left arrow: To jump back to the first cell in a selected row.<\/li>\n\n\n\n<li>Ctrl + End: To go to the last cell in a workbook.<\/li>\n\n\n\n<li>Alt + Page down: To move the screen towards the right.<\/li>\n\n\n\n<li>Alt + Page Up: To move the screen towards the left.<\/li>\n\n\n\n<li>Ctrl + F2: To open the print preview window.<\/li>\n\n\n\n<li>Ctrl + F1: To expand or collapse the ribbon.<\/li>\n\n\n\n<li>Alt: To open the access keys.<\/li>\n\n\n\n<li>Tab: Move to the next cell.<\/li>\n\n\n\n<li>Alt + F + T: To open the options.<\/li>\n\n\n\n<li>Alt + Down arrow: To activate filters for cells.<\/li>\n\n\n\n<li>F2: To edit a cell.<\/li>\n\n\n\n<li>F3: To paste a cell name if the cells have been named.<\/li>\n\n\n\n<li>Shift + F2: To add or edit a cell comment.<\/li>\n\n\n\n<li>Alt + H + H: To select a fill colour.<\/li>\n\n\n\n<li>Alt + H + B: To add a border.<\/li>\n\n\n\n<li>Ctrl + 9: To hide the selected rows.<\/li>\n\n\n\n<li>Ctrl + 0: To hide the selected columns.<\/li>\n\n\n\n<li>Esc: To cancel an entry.<\/li>\n\n\n\n<li>Enter: To complete the entry in a cell and move to the next one.<\/li>\n\n\n\n<li>Shift + Right arrow: To extend the cell selection to the right.<\/li>\n\n\n\n<li>Shift + Left arrow: To extend the cell selection to the left.<\/li>\n\n\n\n<li>Shift + Space: To select the entire row.<\/li>\n\n\n\n<li>Page up\/ down: To move the screen up or down.<\/li>\n\n\n\n<li>Alt + H: To go to the Home tab in Ribbon.<\/li>\n\n\n\n<li>Alt + N: To go to the Insert tab in Ribbon.<\/li>\n\n\n\n<li>Alt + P: To go to the Page Layout tab in Ribbon.<\/li>\n\n\n\n<li>Alt + M: To go to the Formulas tab in Ribbon.<\/li>\n\n\n\n<li>Alt + A: To go to the Data tab in Ribbon.<\/li>\n\n\n\n<li>Alt + R: To go to the Review tab in Ribbon.<\/li>\n\n\n\n<li>Alt + W: To go to the View tab in Ribbon.<\/li>\n\n\n\n<li>Alt + Y: To open the Help tab in Ribbon.<\/li>\n\n\n\n<li>Alt + Q: To quickly jump to search.<\/li>\n\n\n\n<li>Alt + Enter: To start a new line in a current cell.<\/li>\n\n\n\n<li>Shift + F3: To open the Insert function dialog box.<\/li>\n\n\n\n<li>F9: To calculate workbooks.<\/li>\n\n\n\n<li>Shift + F9: To calculate an active workbook.<\/li>\n\n\n\n<li>Ctrl + Alt + F9: To force calculate all workbooks.<\/li>\n\n\n\n<li>Ctrl + F3: To open the name manager.<\/li>\n\n\n\n<li>Ctrl + Shift + F3: To create names from values in rows and columns.<\/li>\n\n\n\n<li>Ctrl + Alt + +: To zoom in inside a workbook.<\/li>\n\n\n\n<li>Ctrl + Alt +: To zoom out inside a workbook.<\/li>\n\n\n\n<li>Alt + 1: To turn on Autosave.<\/li>\n\n\n\n<li>Alt + 2: To save a workbook.<\/li>\n\n\n\n<li>Alt + F + E: To export your workbook.<\/li>\n\n\n\n<li>Alt + F + Z: To share your workbook.<\/li>\n\n\n\n<li>Alt + F + C: To close and save your workbook.<\/li>\n\n\n\n<li>Alt or F11: To turn key tips on or off.<\/li>\n\n\n\n<li>Alt + Y + W: To know what&#8217;s new in Microsoft Excel.<\/li>\n\n\n\n<li>F1: To open Microsoft Excel help.<\/li>\n\n\n\n<li>Ctrl + F4: To close Microsoft Excel.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":25938,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-92","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/people.utm.my\/s-mariam\/wp-json\/wp\/v2\/pages\/92","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/people.utm.my\/s-mariam\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/people.utm.my\/s-mariam\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/people.utm.my\/s-mariam\/wp-json\/wp\/v2\/users\/25938"}],"replies":[{"embeddable":true,"href":"https:\/\/people.utm.my\/s-mariam\/wp-json\/wp\/v2\/comments?post=92"}],"version-history":[{"count":1,"href":"https:\/\/people.utm.my\/s-mariam\/wp-json\/wp\/v2\/pages\/92\/revisions"}],"predecessor-version":[{"id":94,"href":"https:\/\/people.utm.my\/s-mariam\/wp-json\/wp\/v2\/pages\/92\/revisions\/94"}],"wp:attachment":[{"href":"https:\/\/people.utm.my\/s-mariam\/wp-json\/wp\/v2\/media?parent=92"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}