50+ Common Excel Keyboard Shortcuts for Accountants to Remember
50+ Common Excel Keyboard Shortcuts for Accountants to Remember: In the accounting environment, Excel is an indispensable and extremely useful tool, facilitating work processes and helping to enhance work efficiency. To streamline operations, many users find that using external keyboards with Excel shortcuts on Windows enables them to work more effectively. For users with mobility or visual impairments, using shortcuts may be easier than using touch screens and is an essential alternative to mouse usage.
Combination Function Keys
Excel Navigation Shortcuts
SHORTCUT PURPOSE
ALT + TAB Switch between programs
CTRL + TAB Switch between open Excel files
CTRL + PAGE UP Move to the sheet to the left
CTRL + PAGE DOWN Move to the sheet to the right
HOME Move to the beginning of a row
CTRL + HOME Move to the first row and column in the sheet
CTRL + END Move to the last row and column in the sheet
Operation Shortcuts
SHORTCUT PURPOSE
CTRL + N Create a new file
CTRL + O Open a saved file
CTRL + P Print
CTRL + S Save the page
CTRL + W Close the current page
ALT + = Use AutoSum function
CTRL + SHIFT + A Insert parentheses ( ) and arguments after entering a function name
Function Keys
SHORTCUT PURPOSE
F2 Edit data in a cell
F3 Paste a named range into a formula
F4 or CTRL + Y Repeat the last action
F5 Go to a specific location using a reference
50+ Essential Excel Accounting Shortcuts
Copy Shortcuts
SHORTCUT PURPOSE
CTRL + C Copy
CTRL + D Copy the value from the cell above the active cell to the active cell
CTRL + R or CTRL + Y Copy data from left to right
CTRL + V Paste
CTRL + X Cut
CTRL + Z Undo the last action
CTRL + DELETE Clear all content in a cell
ALT + ENTER Move to the next line within a cell
Format Shortcuts
SHORTCUT PURPOSE
CTRL + ; Update date
CTRL + 0 Hide selected columns
CTRL + 1 Display the Format Cells dialog box
CTRL + 5 Toggle strikethrough on/off
CTRL + 9 Hide selected rows
CTRL + B Toggle bold on/off
CTRL + I Toggle italic on/off
CTRL + U Toggle underline on/off
CTRL + SHIFT + – Remove borders for selected cells
CTRL + SHIFT + # Format numbers as dates (day, month, year)
CTRL + SHIFT + $ Format numbers as currency with two decimal places
CTRL + SHIFT + % Format numbers as percentages (without decimal places)
CTRL + SHIFT + & Apply outer borders
CTRL + SHIFT + ( Unhide rows
CTRL + SHIFT + : Enter time
CTRL + SHIFT +? Format numbers as numbers with two decimal places
CTRL + SHIFT + ^ Format numbers as exponential with two decimal places
CTRL + SHIFT + ~ Format numbers as general
CTRL + SHIFT + ” Copy value from the cell above into the current cell
CTRL + SHIFT + = Insert a blank cell or row
CTRL + SHIFT + 0 Unhide selected columns
CTRL + SHIFT + 5 Format as percentage
CTRL + SHIFT + 9 Unhide selected rows
Data Selection
50+ Common Excel Keyboard Shortcuts for Accountants to Remember
SHORTCUT PURPOSE
ALT + DOWN ARROW Display a list of values in the current column
CTRL + ARROW Move to the last cell containing data before a blank cell
CTRL + SHIFT + END Extend the selection to the last used cell
CTRL + SHIFT + HOME Extend the selection to the beginning of the worksheet
CTRL + SPACEBAR Select the entire column
CTRL + ‘ Copy the value from the cell above to the current cell
CTRL + K Insert a hyperlink
ESC Cancel the data entry
SHIFT + ARROW Select a range
SHIFT + HOME Extend the selection to the first row
SHIFT + PAGE DOWN Extend the selection down one screen
SHIFT + PAGE UP Extend the selection up one screen
SHIFT + SPACEBAR Select the entire row
SHIFT + F2 Insert a comment
SHIFT + TAB Enter data in the cell and move left in the selection
TAB Enter data in the cell and move right in the selection
Excel Shortcuts Combining ALT and Underlined Letters of the Menu
SHORTCUT PURPOSE
ALT + D P Insert / PivotTable
ALT + A E Data / Text to Column
ALT + D B Data / Subtotal
ALT + O H U Unhide the selected sheet
ALT + O H H Hide the selected sheet
ALT + O C A Autofit the width of the column
ALT + E S Paste Special
ALT + D F F Data / Filter
ALT + W F + ENTER View / Freeze or Unfreeze Panes
ALT + W S View / Split
SHIFT + HOME Extend the selection to the first row
ALT + N + (Type of chart) Insert a chart
