How The Alignment and Number work in Excel? скачать в хорошем качестве

How The Alignment and Number work in Excel?

In this video we learn how to use alignment and number in Excel. Excel Shortcuts: Close a workbook. #Ctrl+W Open a workbook. #Ctrl+O Go to the Home Tab. #Alt+H Save a workbook. #Ctrl+S Copy selection. #Ctrl+C Paste selection. #Ctrl+V Undo recent action. #Ctrl+Z Remove cell contents. #Delete Choose a fill color. #Alt+H, #H Cut selection. #Ctrl+X Go to the Insert Tab. #Alt+N Apply bold formatting. #Ctrl+B Center align cell contents. #Alt+H, #A, #C Go to the Page Layout Tab. #Alt+P Go to the Data Tab. #Alt+A Go to the View Tab. #Alt+W Open the context menu. #Shift+F10 or Windows Menu key Add borders. #Alt+H,B Delete column. #Alt+H, #D, #C Go to the Formula Tab. #Alt+M Hide the selected rows. #Ctrl+9 Hide the selected columns. #Ctrl+0 Move to the previous cell in a worksheet or the previous option in a dialog box. #Shift+Tab Move one cell up in a worksheet. #Up_arrow_key Move one cell down in a worksheet. #Down_arrow_key Move one cell left in a worksheet. #Left_arrow_key Move one cell right in a worksheet. #Right arrow key Move to the edge of the current data region in a worksheet. #Ctrl+Arrow_key Enter the End mode, move to the next nonblank cell in the same column or row as the active cell, and turn off End mode. If the cells are blank, move to the last cell in the row or column. #End+Arrow_key Move to the last cell on a worksheet, to the lowest used row of the rightmost used column. #Ctrl+End Extend the selection of cells to the last used cell on the worksheet (lower-right corner). #Ctrl+Shift+End Move to the cell in the upper-left corner of the window when Scroll lock is turned on. #Home+Scroll_lock Move to the beginning of a worksheet. #Ctrl+Home Move one screen down in a worksheet. #Page_down Move to the next sheet in a workbook. #Ctrl+Page_down Move one screen to the right in a worksheet. #Alt+Page_down Move one screen up in a worksheet. #Page_up Move one screen to the left in a worksheet. #Alt+Page_up Move to the previous sheet in a workbook. #Ctrl+Page_up Move one cell to the right in a worksheet. Or, in a protected worksheet, move between unlocked cells. #Tab_key Open the list of validation choices on a cell that has data validation option applied to it. #Alt+Down_arrow_key Cycle through floating shapes, such as text boxes or images. #Ctrl+Alt+5, then the Tab key repeatedly Exit the floating shape navigation and return to the normal navigation. #Esc Scroll horizontally. #Ctrl+Shift, then scroll your mouse wheel up to go left, down to go right Zoom in. #Ctrl+Alt+Equal_sign(=) Zoom out. #Ctrl+Alt+Minus_sign(-) Select the entire worksheet. #Ctrl+A or #Ctrl+Shift+Spacebar Select the current and next sheet in a workbook. #Ctrl+Shift+Page_down Select the current and previous sheet in a workbook. #Ctrl+Shift+Page_up Extend the selection of cells by one cell. #Shift+Arrow_key