Shortcut Key in MS-Excel

Shortcut Keys in Microsoft Excel

There are many shortcut keys which we use in different Windows or Windows based Software. In this I would like to mention those particular ones which we use in Microsoft Excel specially.

Ctrl + Page Up is used to go to previous sheet.
Ctrl + Page Down is used to go to previous sheet.
Ctrl + arrow key is used to move cell pointer. 
Shift + Space Bar is used to select a row.
Ctrl + Space Bar is used to select a column.
Ctrl + D is used to copy the matter/formula in first column to below selected columns. 
Ctrl + R is used to copy the matter/formula in first column towards right side selected columns. 
Ctrl + 1 is used for formatting cell. 
F2 is for editing cell data.
Alt + = is used for adding the numbers of the selected columns. The numbers written can be either in columns or in rows. 
Shift + arrow keys is used to select columns. 
Shift + Ctrl + arrow keys is used to select columns till the last column which has data.
Alt + Page up/down is used to move right or left in a worksheet. 
Home Key is used to go to the left most column in the worksheet. 
End Key and then right/down arrow key to the last column towards right or downwards in the worksheet or the column with data.
Ctrl + End is used to move the cell pointer to the last cell in which some data has been stored.

Please leave comments so that I can write more blogs related to computers. 

Written By:
Kumar Vaibhav
Director
Vaibhav Computer Centre & Consultancy
Vaibhav Sadan,
Devkali Road, Faizabad, Ayodhya. 

Comments

Post a Comment

Popular posts from this blog

PRINTING TWO BANK DETAILS IN TALLY

Image
PRINTING TWO BANK DETAILS IN TALLY When we Print a BILL OF SUPPLY i.e. a sales bill we can activate to print our account details in the bill. But what if we want to print Two account details in Tally. For this we have to add a TDL file to our Tally which will allow us to print two account details in a Sales Bill. THIS SHOULD APPEAR ON THE BILL First of all we have to download a bank details TDL file (which you can download from internet). Place the file in a folder and copy its location by clicking on properties of the file. In security tab one can find the details of the file. Now open Tally and press CTRL+ALT+T to open TDL Management. Press F4 to enter Manage Local TDLs. Now in Tally 9.0 ERP you have to use CTRL+ALT+V to paste the file details. But in Tally Prime you can directly specify path and select the file.  THIS WILL APPEAR CTRL+ALT+T THIS WILL APPEAR -  F4 (Manage Local TDLs) Once your file is properly loaded restart your Tally now you can see a new option under Disp...
Read more

CONVERTING TEXT TO TABLE

Image
 CONVERTING TEXT TO TABLE BEFORE LEARING CONVERTING TEXT TO TABLE LETS KNOW ABOUT SOME FACTS OF  TABLES IN MS-WORD Table by default have 2 Rows & 5 Columns. Maximum number of Columns that can be inserted is 63 Maximum number of Rows that can be inserted is 32767 Table can be converted to simple text & vice-versa, options are available in 1.    INSERT MENU - TABLE - CONVERT TEXT TO TABLE 2.   W hen we have our cursor on table we get option of CONVERT TABLE TO TEXT under LAYOUT MENU. For converting simple text to table you can use any symbol of your choice to make a difference between data. EXAMPLE NAME,CLASS,SEC RAM,10,A HARI,10,B LILA,10,A Simply select the above data and go to table tab under insert menu and click on convert text to table. You will get a dialogue box where you have to choose the separate text at if you have given any other symbol other than comma (,). In other you have to define that symbol. Else you simply ...
Read more

10 common uses of computers

  10 common uses of computers: Communication: Computers are widely used for communication purposes, including sending emails, instant messaging, video conferencing, and social media platforms. Internet Browsing: Computers enable users to browse the internet, search for information, read news articles, watch videos, and access various online services. Education: Computers play a crucial role in education, providing access to online courses, digital textbooks, educational software, and research materials. Entertainment: Computers are used for various forms of entertainment, such as playing video games, streaming movies and TV shows, listening to music, and reading e-books. Business and Finance: Computers are extensively used in business environments for tasks like accounting, inventory management, data analysis, financial modeling, and online banking. Graphic Design and Multimedia: Computers are indispensable in graphic design, digital art creation, photo editing, video editing, anim...
Read more