Skip to main content

COMPUTER SHORTCUTS

 








Computer Shortcut Keys



Ctrl + A - Select All

Ctrl + B - Bold 

Ctrl + C - Copy

Ctrl + D - Fill

Ctrl + F - Find

Ctrl + G - Find next instance of text

Ctrl + H - Replace

Ctrl + I - Italic

Ctrl + K - Insert a hyperlink

Ctrl + N - New workbook

Ctrl + O - Open

Ctrl + P - Print

Ctrl + R - Nothing right

Ctrl + S - Save

Ctrl + U - Underlined

Ctrl + V - Paste

Ctrl W - Close

Ctrl + X - Cut

Ctrl + Y - Repeat

Ctrl + Z - Cancel

F1 - Help

F2 - Edition

F3 - Paste the name

F4 - Repeat the last action

F4 - When entering a formula, switch between absolute / relative references

F5 - Goto

F6 - Next Pane

F7 - Spell Check

F8 - Extension of the mode

F9 - Recalculate all workbooks

F10 - Activate Menubar

F11 - New graph

F12 - Save As

Ctrl +: - Insert the current time

Ctrl +; - Insert the current date

Ctrl + "- Copy the value of the cell above

Ctrl + '- Copy the formula from the cell above

Shift - Offset Adjustment for Additional Functions in the Excel Menu

Shift + F1 - What is it?

Shift + F2 - Edit cell comment

Shift + F3 - Paste the function into the formula

Shift + F4 - Search Next

Shift + F5 - Find

Shift + F6 - Previous Panel

Shift + F8 - Add to the selection

Shift + F9 - Calculate the active worksheet

Shift + F10 - Popup menu display

Shift + F11 - New spreadsheet

Shift + F12 - Save

Ctrl + F3 - Set name

Ctrl + F4 - Close

Ctrl + F5 - XL, size of the restore window

Ctrl + F6 - Next Workbook Window

Shift + Ctrl + F6 - Previous Workbook Window

Ctrl + F7 - Move window

Ctrl + F8 - Resize Window

Ctrl + F9 - Minimize the workbook

Ctrl + F10 - Maximize or Restore Window

Ctrl + F11 - Inset 4.0 Macro sheet

Ctrl + F1 - Open File

Alt + F1 - Insert a graph

Alt + F2 - Save As

Alt + F4 - Output

Alt + F8 - Macro dialog

Alt + F11 - Visual Basic Editor

Ctrl + Shift + F3 - Create a name using the names of row and column labels

Ctrl + Shift + F6 - Previous Window

Ctrl + Shift + F12 - Printing

Alt + Shift + F1 - New spreadsheet

Alt + Shift + F2 - Save

Alt + = - AutoSum

Ctrl + `- Toggle value / display of the formula

Ctrl + Shift + A - Insert the argument names in the formula

Alt + down arrow - automatic view list

Alt + '- Format Style Dialog

Ctrl + Shift + ~ - General Format

Comments

Post a Comment

Popular posts from this blog

HIGHEST MARKS IN CA FINAL(ALL TIME HIGHEST MARKS IN INDIVIDUAL SUBJECTS)

  “ There are some people who lead, set benchmarks and inspire others” The highest score in CA Final aggregate wise being the highest total number of marks obtained in a CA Final Examination till date is  630/800  by the topper of the examination held in May 2017. The subject wise highest scores have been obtained by different individuals in their respective examinations spread over a period of time. The subject wise highest scores can be illustrated as follows :- FR- 98/100 SFM- 100/100 AUDIT- 83/100 LAW- 88/100 AMA- 92/100 ISCA- 98/100 DT- 94/100 IDT- 91/100 Some of these papers have been preserved as a symbol of excellence in the ICAI Hall of Fame. ( The scores mentioned above are reproduced to the best of my knowledge and ability. Changes if any, can be suggested for edits)
Post a Comment
Read more

Finance Rules You Should Know

  *Nine Personal Finance Rules we all must know* 1) Rule of 72 (Double Your Money) 2) Rule of 70 (Inflation) 3) 4% Withdrawal Rule 4) 100 Minus Age Rule 5) 10, 5, 3 Rule 6) 50-30-20 Rule 7) 3X Emergency Rule 8) 40% EMI Rule 9) Life Insurance Rule 1) *Rule of 72* No. of yrs required to double your money at a given rate, U just divide 72 by interest rate Eg, if you want to know how long it will take to double your money at 8% interest, divide 72 by 8 and get 9 years. At 6% rate, it will take 12 years At 9% rate, it will take 8 years 2) *Rule of 70* Divide 70 by current inflation rate to know how fast the value of your investment will get reduced to half its present value. Inflation rate of 7% will reduce the value of your money to half in 10 years. 3) *4% Rule for Financial Freedom* Corpus Required = 25 times of your estimated Annual Expenses. Eg- if your annual expense after 50 years of age is 500,000 and you wish to take VRS then corpus with you required is 1.2...
Post a Comment
Read more

GUIDE TO FORM 3CB AND 3CD (TAX AUDIT)

  Income Tax rules necessitate few taxpayers to get their accounts audited under Section 44AB. The threshold limit of Rs 1 crore for a tax audit is proposed to be increased to Rs 5 crore with effect from AY 2021-22 (FY 2020-21) if the taxpayer’s cash receipts are limited to 5% of the gross receipts or turnover, and if the taxpayer’s cash payments are limited to 5% of the aggregate payments. The auditor has to furnish the audit report in the specified audit form along with the detailed particulars Prescribed Audit Forms The audit report has to be furnished in either of the following forms: Form 3CA  – In respect of a taxpayer carrying on a business or profession and who is already  mandated  to get his accounts audited under any other law  (i.e. law other than income tax law) . A company is required to get its accounts audited compulsorily under Companies Act 2013. So, it will furnish Form 3CA.    Form 3CB  – In respect of a taxpayer carrying on a ...
2 comments
Read more