Skip to main content

Excel Ctrl +

Object of This Block:
To Get Knowledge of MS Excel “Ctrl + Letter” Shortcuts, That will Increase our work speed in excel.


Ctrl +

·        Ctrl + A -  selects the whole worksheet or the whole date
·        Ctrl + B -  bold the selected data
·        Ctrl + C -  copy the selected data 
·        Ctrl + D -  copy the above cell data in current cell 
·        Ctrl + F -  open Find dialog box
·        Ctrl + G - open Go To dialog box
·        Ctrl + H - open the Replace dialog box
·        Ctrl + I  -  italics the selected data
·        Ctrl + K - open Insert Hyperlink dialog box
·        Ctrl + L - open Create Table dialog box
·        Ctrl + N - creates a new workbook
·        Ctrl + O - open the Open dialog box
·        Ctrl + P  - open the Print dialog box
·        Ctrl + R - copy  data of left cell in to current cell
·        Ctrl + S  - saves the workbook
·        Ctrl + U - underlining the selected data
·        Ctrl + V - Pastes the data from the clipboard
·        Ctrl +W - closes the open workbook
·        Ctrl + X - cuts the selected data to the clipboard
·        Ctrl + Y - redo the last action
·        Ctrl + Z - undo the last action

Grow the Info
Comment  + Share + Subscribe 

Labels:

Comments

Post a Comment

Popular posts from this blog

How to Stop Back Dated Entries In Tally ?

The object of This Block : You Can Stop Create/alter Entry in Tally from Date Specified By You.  (I.e. you are in 18-19 and you want to stop create/alter entry before 31.03.2018) Block of Info : Useful Term: "Current Date for tally": Menace "Date of Last Voucher entry in tally" (you can see on Gateway of tally Also) We are Require to Mack Following two type of login security : 1)  Admin  Login : (Admin name and Password) 2)  User Login :  ( User Name and Password) Let’s, Do it :      1)  To Set Admin Name and Password  ·        Gateway of Tally > Co. Info (Alt + f3) > Alter. ·        Select Company name ·        Mack “yes’ to ‘Use Security Controls” ·        Set: “Name of Admin” and “Password” ·        Reload Company By using Above “Name and “Pas...
Post a Comment
Read more

Name Rang in Excel and it's use.

Object of This block: How We Can Define Name Range in Excel , How it's Useful to us. What is Name Range? Name Range: Giving One Custom Name to One or More than One Cell in Excel . Ex.  A2 = net profit        C1:C10 = productlist How to Create Name Range: 1. First Select One or More Cell Which of Those, You want to Give a Name.  2. Go to Name box 3. Give a Name to Selected Cell or Cells.    ( In this C1:C10 = Productlist ) The following Characters are not allowed as Name: Space is Not Allowed as Part of a Name. Names can't look like Cell addresses, Such as A$2 or A2C2 C, c, R, r -- Can't be Used as Names --  Excel Uses Them as Selection Shortcuts Names are not Case Sensitive. For example, PROUCTLIST and productlist are treated as the same name. Now, We Understand  Use of Name Range: 1. On data validation: While Creating a  dr...
Post a Comment
Read more