Excel Shortcut Keys for CA & CA Students

So this time We brings to you Excel Shortcut Keys which are very useful for CAs & CA Students. As we know excel is much needed tool in this era and if you don’t know how to use excel efficiently than their will much difficult for them to perform their work. So Excel Shortcut Keys will help you all.

Also share with your friends and do comment if you need help in any formula or Excel Shortcut Keys.


Shortcut KeysFunction
CTRL+HOME Move to the beginning of the worksheet
CTRL+END Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottom-most used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1
PAGE DOWN Move down one screen
PAGE UP Move up one screen
CTRL+PAGE DOWN Move to the next sheet in the workbook
CTRL+PAGE UP Move to the previous sheet in the workbook
CTRL+BACKSPACE Scroll to display the active cell
F5 Display the Go To dialog box
SHIFT+F5 Display the Find dialog box
Keys for previewing and printing a document
Shortcut KeysFunction
CTRL+P or CTRL+SHIFT+F12 Display the Print dialog box
Keys for working with worksheets, charts, and macros
Shortcut KeysFunction
SHIFT+F11 or ALT+SHIFT+F1 Insert a new worksheet
F11 or ALT+F1 Create a chart that uses the current range
ALT+F8 Display the Macro dialog box
ALT+F11 Display the Visual Basic Editor
Keys for entering data on a worksheet
Shortcut KeysFunction
CTRL+ENTER Fill the selected cell range with the current entry
F4 or CTRL+Y Repeat the last action
CTRL+SHIFT+F3 Create names from row and column labels
CTRL+D Fill down
Keys for working in cells or the formula bar
Shortcut KeysFunction
CTRL+SHIFT+ENTER Enter a formula as an array formula
CTRL+K Insert a hyperlink
ALT+= (equal sign) Insert the AutoSum formula
CTRL+; (semicolon) Enter the date
CTRL+SHIFT+:  (colon) Enter the time
CTRL+SHIFT+” (quotation mark) Copy the value from the cell above the active cell into the cell or the formula bar
CTRL+` (single left quotation mark) Alternate between displaying cell values and displaying cell formulas
CTRL+’ (apostrophe) Copy a formula from the cell above the active cell into the cell or the formula bar
ALT+DOWN ARROW Display the AutoComplete list
Keys for formatting data
Shortcut KeysFunction
CTRL+1 Display the Format Cells dialog box
CTRL+SHIFT+~ Apply the General number format
CTRL+SHIFT+$ Apply the Currency format with two decimal places (negative numbers appear in parentheses)
CTRL+SHIFT+% Apply the Percentage format with no decimal places
CTRL+SHIFT+^ Apply the Exponential number format with two decimal places
CTRL+SHIFT+# Apply the Date format with the day, month, and year
CTRL+SHIFT+@ Apply the Time format with the hour and minute, and indicate A.M. or P.M.
CTRL+SHIFT+! Apply the Number format with two decimal places, thousands separator, and minus sign (–) for negative values
CTRL+SHIFT+& Apply the outline border
CTRL+SHIFT+_ Remove outline borders
CTRL+B Apply or remove bold formatting
CTRL+I Apply or remove italic formatting
CTRL+U Apply or remove an underline
CTRL+5 Apply or remove strikethrough formatting
CTRL+9 Hide rows
CTRL+SHIFT+( (opening parenthesis) Unhide rows
CTRL+0 (zero) Hide columns
CTRL+SHIFT+) (closing parenthesis) Unhide columns





Keys for inserting, deleting, and copying a selection
Shortcut KeysFunction
CTRL+C Copy the selection
CTRL+X Cut the selection
CTRL+V Paste the selection
Keys for selecting cells, columns, or rows
Shortcut KeysFunction
CTRL+SPACEBAR Select the entire column
SHIFT+SPACEBAR Select the entire row
CTRL+A Select the entire worksheet

Hope These Excel Shortcut Keys will helpful to you Do bookmark this page for future reference so that you can learn from this page whenever you want .