Skip to main content

Excel Shortcuts - Ctrl + N, Ctrl + O, Ctrl + S, Ctrl + W, Ctrl + F4, Ctrl + H, Ctrl + K, Ctrl + PageDown, Ctrl + PageUp, Ctrl + P, Ctrl + G, Ctrl + ;, Ctrl + Space, Ctrl + 9, Ctrl + 0, Ctrl + F1, Ctrl + X, Ctrl + End, Ctrl + Home, Ctrl + Delete

Excel Shortcuts

Excel Shortcuts
(Image by - Sharma Guides | Subham232330)


Ctrl + N = To create a new workbook

Ctrl + O = To open an existing workbook

Ctrl + S = To save a workbook

Ctrl + W = To close the current workbook

Ctrl + F4 = To close excel

Ctrl + H = To display find and replace

Ctrl + K = To insert a hyperlink

Ctrl + PageDown = To move the next sheet

Ctrl + PageUp = To move the previous sheet

Ctrl + P = Print File

Ctrl + G = Display "Go To" dialog box

Ctrl + ; = Insert the current date

Ctrl + Space = Select the entire column

Ctrl + 9 = Hide selected row

Ctrl + 0 = Hide selected column

Ctrl + F1 = Expand or Collapse ribbon

Ctrl + X = Cut selected cells

Ctrl + End = Move to the last cell in the worksheet

Ctrl + Home = Move to the first cell in the worksheet

Ctrl + Delete = Delete end of line



Labels:

Comments

Post a Comment

Please do not enter any spam link in the comment box.

Popular posts from this blog

Normalization Types in DBMS

Normalization Types in DBMS First Normal Form (1NF) A relation will be 1NF if it contains an atomic value.  It states that an attribute of a table cannot hold multiple values. It must hold only single-valued attribute. First normal form disallows the multi-valued attribute, composite attribute, and their combinations. Example: Relation EMPLOYEE is not in 1NF because of multi-valued attribute EMP_PHONE. EMPLOYEE table: EMP_ID EMP_NAME EMP_PHONE EMP_STATE 14 John 7272826385, 9064738238 UP 20 Harry 8574783832 Bihar 12 Sam 7390372389, 8589830302 Punjab The decomposition of the EMPLOYEE table into 1NF has been shown below: EMP_ID EMP_NAME EMP_PHONE EMP_STATE 14 John 7272826385 UP 14 John 9064738238 UP 20 Harry 8574783832 Bihar 12 Sam 7390372389 Punjab 12 Sam 8589830302 Punjab Second Normal Form (2NF) In the 2NF, relational must be in 1NF.  In the second normal form, all non-key attributes are fully functional dependent on the primary key  Example: Let's assume, a school can ...
Post a Comment
Read more

Authentication vs Authorization

Authentication vs Authorization - Authentication and authorization are the two words used in the security world. They might sound similar but are completely different from each other. Authentication is used to authenticate someone's identity, whereas authorization is a way to provide permission to someone to access a particular resource. These are the two basic security terms and hence need to be understood thoroughly. In this topic, we will discuss what authentication and authorization are and how they are differentiated from each other. What is Authentication? Authentication is the process of identifying someone's identity by assuring that the person is the same as what he is claiming for. It is used by both server and client. The server uses authentication when someone wants to access the information, and the server needs to know who is accessing the information. The client uses it when he wants to know that it is the same server that it claims to be. The authentication by t...
Post a Comment
Read more

Control Key Shortcuts

Control Key Shortcuts (Image by - Sharma Guides | Subham232330) CTRL+A = All Select CTRL+B = Bold CTRL+C = Copy CTRL+D = Duplicate CTRL+E = Alignment Center Side CTRL+F = Find CTRL+G = Group & Go To CTRL+H = Replace CTRL+I = Italic CTRL+J = Justify CTRL+K = Hyperlink CTRL+L = Alignment Left Side CTRL+M = New Slide CTRL+N = New Document & Page CTRL+O = Open CTRL+P = Print CTRL+Q = Quit CTRL+R = Alignment Right Side CTRL+S = Save CTRL+T = New Tab CTRL+U = Underline CTRL+V = Paste CTRL+W = Close The Window CTRL+X = Cut CTRL+Y = Redo CTRL+Z = Undo CTRL+Esc = Windows Start Menu CTRL+Tab = Switch between open tabs in the browser or other tabbed programs. CTRL+Shift+Tab = Will go backwards (right to left). CTRL+Delete = Delete Next Word. CTRL+Backspace = Delete Previous Word. CTRL+PgDn = Next Tab CTRL+PgUp = Previous Tab CTRL + ← = Previous Word CTRL + → = Next Word CTRL + Alt + ↑ = Rotate Screen Right Side C TRL + Alt + ↓ = Rotate Screen upsid...
Post a Comment
Read more