UrbanPro
true

Take BCom Tuition from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Search in

Excel Shorcut

Vinod Dineshchandra Joshi
31/05/2017 0 0

Hi,

Please find the enclosed attachment of Basics Excel Shortcuts using in rotuine working of excel.

F2 Edit the selected cell.
F3 After a name has been created, F3 will paste names.
F4 Repeat last action. For example, if you changed the color of text in another cell, pressing F4 will change the text in cell to the same color.
F5 Go to a specific cell. For example, C6.
F7 Spell check selected text or document.
F11 Create chart from selected data.
Ctrl+Shift+; Enter the current time.
Ctrl+; Enter the current date.
Alt+Shift+F1 Insert New Worksheet.
Alt+Enter While typing text in a cell, pressing Alt+Enter will move to the next line, allowing for multiple lines of text in one cell.
Shift+F3 Open the Excel formula window.
Shift+F5 Bring up search box.
Ctrl+1 Open the Format Cells window.
Ctrl+A Select all contents of the worksheet.
Ctrl+B Bold highlighted selection.
Ctrl+I Italic highlighted selection.
Ctrl+K Insert link.
Ctrl+S Save the open worksheet.
Ctrl+U Underline highlighted selection.
Ctrl+D Fill down. Fills the cell beneath with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Down to select multiple cells. Then press Ctrl+D to fill them with the contents of the original cell.
Ctrl+R Fill right. Fills the cell to the right with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Right to select multiple cells. Then press Ctrl+R to fill them with the contents of the original cell.
Ctrl+1 Change the format of selected cells.
Ctrl+5 Strikethrough highlighted selection.
Ctrl+P Bring up the print dialog box to begin the printing process.
Ctrl+Z Undo last action.
Ctrl+F3 Open Excel Name Manager.
Ctrl+F9 Minimize current window.
Ctrl+F10 Maximize currently selected window.
Ctrl+F6 Switch between open workbooks or windows.
Ctrl+Page up Move between work sheets in the same document.
Ctrl+Page down Move between work sheets in the same document.
Ctrl+Tab Move between Two or more open Excel files.
Alt+= Create a formula to sum all of the above cells.
Ctrl+' Insert the value of the above cell into the cell currently selected.
Ctrl+Shift+1 Format number in comma format.
Ctrl+Shift+4 Format number in currency format.
Ctrl+Shift+3 Format number in date format.
Ctrl+Shift+5 Format number in percentage format.
Ctrl+Shift+6 Format number in scientific format.
Ctrl+Shift+2 Format number in time format.
Ctrl+Arrow key Move to next section of text.
Ctrl+Space Select entire column.
Shift+Space Select entire row.
Ctrl+- Delete the selected column or row.
Ctrl+Shift+= Insert a new column or row.
Ctrl+Home Move to cell A1.
Ctrl+~ Switch between showing Excel formulas or their values in cells.

 

0 Dislike
Follow 0

Please Enter a comment

Submit

Other Lessons for You

Cost Accounting: Overhead
Hello, student the following article is being given to understand the concept of overhead and its use in cost account. Overhead is the sum total of all indirect expenses i.e., indirect material, indirect...

Cost Classification ( Vatiable & Fixed)
Cost is ideally divided in two types:- 1. Variable Cost ; 2. Fixed Cost. Variable Cost is constant per unit. And varies proportionately in the same direction as production. Fixed cost is fixed and remains...

Best Method To Study * Effective Utilization Of Time*
We often sit for long hours to study and at the end of it, we might feel unsatisfied. The time duration of study does not matter, the productivity does. A powerfully curated method that is tried and...
N

How do i get best Campus / Off Campus Placement?
Companies are looking for Skilled Freshers. So build your technical skills while doing MCA / BTech / BCA / BSc (IT or CS) into below areas- 1. Strong your programming & debugging skills ...

GST: Goods And Service Tax
What is GST? Goods and Services Tax, GST is a comprehensive tax levy on manufacture, sale and consumption of goods and services at a national level. Through a tax credit mechanism, this tax is collected...
F
X

Looking for BCom Tuition Classes?

The best tutors for BCom Tuition Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Take BCom Tuition with the Best Tutors

The best Tutors for BCom Tuition Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more