Microsoft Office Worksheets "SHORTCUT KEYS" Presented By SUPER TV BD
Microsoft Office Worksheets Shortcut Keys
Microsoft Office Worksheets Shortcut Keys
This is a list of worksheets related all the shortcut keys.
➤Home Moves to column "A" in the current row
➤Enter Moves to the cell below
➤Page Down Moves down one screen
➤Page Up Moves up one screen
➤Alt + Page Down Moves you one screen of columns to the right
➤Alt + Page Up Moves you one screen of columns to the left
➤Alt + Shift + F1 Inserts a new worksheet before the active worksheet.
➤Alt + H, D, S Deletes the active worksheet, with no prompt
➤Alt + W, F, F Toggles freeze panes on the active worksheet.
➤Alt + W, L Switches the view to Normal View.
➤Alt + W, P Switches the view to Page Layout View.
➤Ctrl + Home Moves to cell "A1" on the active worksheet
➤Ctrl + Page Down Moves to the next worksheet in the active workbook.
➤Ctrl + Page Up Moves to the previous worksheet in the active workbook.
➤Ctrl + Shift + End Extends the selection to the last used cell on the worksheet.
➤Ctrl + Up Arrow Moves to the first row in the current region
➤Ctrl + Backspace Selects the current active cell (scrolling if necessary).
➤Ctrl + ' Toggles between the Value layer and the Formula layer.
➤Ctrl + Down Arrow Moves to the last row in the current region
➤Ctrl + End Moves to the Last Used Cell on the active worksheet. This cell is only updated when the workbook is closed.
➤Ctrl + G Displays the (Edit > go to) dialog box
➤Shift + F11 Inserts a new worksheet before the active worksheet.
➤Shift + F9 Calculates the active worksheet.
➤Tab Moves to the next cell on the right
➤Shift + Tab Moves to the previous cell on the left
Sumon Ahmed
This is a list of worksheets related all the shortcut keys.
➤Home Moves to column "A" in the current row
➤Enter Moves to the cell below
➤Page Down Moves down one screen
➤Page Up Moves up one screen
➤Alt + Page Down Moves you one screen of columns to the right
➤Alt + Page Up Moves you one screen of columns to the left
➤Alt + Shift + F1 Inserts a new worksheet before the active worksheet.
➤Alt + H, D, S Deletes the active worksheet, with no prompt
➤Alt + W, F, F Toggles freeze panes on the active worksheet.
➤Alt + W, L Switches the view to Normal View.
➤Alt + W, P Switches the view to Page Layout View.
➤Ctrl + Home Moves to cell "A1" on the active worksheet
➤Ctrl + Page Down Moves to the next worksheet in the active workbook.
➤Ctrl + Page Up Moves to the previous worksheet in the active workbook.
➤Ctrl + Shift + End Extends the selection to the last used cell on the worksheet.
➤Ctrl + Up Arrow Moves to the first row in the current region
➤Ctrl + Backspace Selects the current active cell (scrolling if necessary).
➤Ctrl + ' Toggles between the Value layer and the Formula layer.
➤Ctrl + Down Arrow Moves to the last row in the current region
➤Ctrl + End Moves to the Last Used Cell on the active worksheet. This cell is only updated when the workbook is closed.
➤Ctrl + G Displays the (Edit > go to) dialog box
➤Shift + F11 Inserts a new worksheet before the active worksheet.
➤Shift + F9 Calculates the active worksheet.
➤Tab Moves to the next cell on the right
➤Shift + Tab Moves to the previous cell on the left
It is important part of M/S Office. So Thanks Mr.Sumon Ahmed.
ReplyDelete