Notice: wp_add_inline_style was called incorrectly. Do not pass style tags to wp_add_inline_style(). Please see Debugging in WordPress for more information. (This message was added in version 3.7.) in /home/atechlab/public_html/wp-includes/functions.php on line 3622
Home , Tips & Tricks , List of all shortcut Keys in Microsoft Excel
List of all shortcut Keys in Microsoft Excel
List of all shortcut Keys in Microsoft Excel

List of all shortcut Keys in Microsoft Excel

List of all shortcut Keys in Microsoft Excel

 

Keys for working with working with worksheets and charts

SHIFT +F11                                                             :Insert   a new  worksheet

F11 or ALT+F1                                                       :Create a chart that uses the  current RANGE

CTRL +PAGE DOWN                                           :Move ot the  next sheet in the  workbook

CTRL+PAGE UP                                                   :Move to the  previsions  sheet  in the work book

Keys for Entering Data on A worksheet

ENTER                                                                  : Complete a cell entry and   move down in the  selection

ALT+ENTER                                                       : Start a new  line  in the  same cell

CTRL+ENTER                                                    : Fill the selected cell range with the current entry

TAB                                                                     : Complete a cell entry and move to the right in the selection

SHIFT+TAB                                                        : Complete a cell entry and move  to the  right  in the  selection

ESC                                                                      : Cancel a cell entry

BACKSPACE                                                     : Delete the character to the left of the insertion point

CTRL +DELETE                                                : Delete the character to the right   of the  insertion  point    :

Arrow keys                                                          : Delete text to the end of line

HOME                                                                 : Move one character up, down left or right

F4or CTRL+Y                                                     : Move to the beginning of the line

SHIFT+F2                                                           : Repeat the last action

CTRL+SHIFT+F3                                               : Creates names from row and column labels

CTRL+D                                                              : Fill down

CTRL +                                                                : Define a name

CTRL+SHIFT+                                                   : Apply the generally number format

CTRL+SHIFT+$                                                 : Apply the currency format with two decimal places

CTRL+SHIFT+%                                                : Apply the percentage format with no decimal places

CTRL+SHIFT+#                                                  : Apply the date format with the day month and year

CTRL+SHIFT+@                                                : Apply  the  time  format with hour and  minute, and  Indicate A.M. Or PM

Shortcut Key for navigating worksheet:

Arrow key                                                           : Move one cell up down  left or right

CTRL+ arrow key                                              : Move  to the edge of the current data REGION

HOME                                                                : Move to   the  beginning of the row

CTRL+HOME                                                   : Move  to  the of the worksheet

CTRL+END                                                      : Move to the  last cell on the  worksheet

PAGE DOWN                                                   : Move  down one screen

PAGE UP                                                          : Move   up one screen light

ALT+PAGE+DOWN                                       : Move  to the next next  sheet in the WORKSHEET

CTRL+PAGE UP                                             : Move  to the previous sheet in the work

Guest Post by : PRANATI RAJA

ST.FRANCIS XAVIER SCHOOL,(INDIA)

Some Handpicked Related Material only for you!

About Abhishek Gautam

I am a technology enthusiastic, Researcher, Computer Engineer as well as the mind behind the atechlab.net – The Ultimate Cyber Tech Lab!

Check Also

How to Download Facebook videos on PC

How to Download Facebook videos on PC    Nowadays the video posts on facebook are …

Leave a Reply

Your email address will not be published. Required fields are marked *

Watch Dragon ball super


Notice: Undefined index: efbl_enable_popup in /home/atechlab/public_html/wp-content/plugins/easy-facebook-likebox/public/easy-facebook-likebox.php on line 379

Notice: Undefined index: efbl_enable_popup in /home/atechlab/public_html/wp-content/plugins/easy-facebook-likebox/public/easy-facebook-likebox.php on line 379