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 Keys	Function
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 Keys	Function
CTRL+P or CTRL+SHIFT+F12	Display the Print dialog box

.

KEYS FOR WORKING WITH WORKSHEETS , CHARTS, AND MACROS

Shortcut Keys	Function
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 Keys	Function
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 Keys	Function
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 Keys	Function
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 Keys	Function
CTRL+C	Copy the selection
CTRL+X	Cut the selection
CTRL+V	Paste the selection

.

KEYS FOR SELECTING CELLS, COLUMNS, OR ROWS

Shortcut Keys	Function
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 .

.

Regards CA GROUPS