filmov
tv
How to copy and move Macro from an excel workbook to another?
![preview_player](https://i.ytimg.com/vi/d-J1MySn-vg/maxresdefault.jpg)
Показать описание
#excel
#woop
#copy_macro
#move_macro.
how to copy and move Macro from an excel workbook to another?
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
#woop
#copy_macro
#move_macro.
how to copy and move Macro from an excel workbook to another?
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