Skip to main content

Shortcuts key for microsoft excel


ShortcutDescription
F2Edit the selected cell.
F3After a name has been created F3 will paste names.
F4Repeat 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.
F5Go to a specific cell. For example, C6.
F7Spell check selected text or document.
F11Create chart from selected data.
Ctrl + Shift + ;Enter the current time.
Ctrl + ;Enter the current date.
Alt + Shift + F1Insert New Worksheet.
Alt + EnterWhile typing text in a cell pressing Alt + Enter will move to the next line allowing for multiple lines of text in one cell.
Shift + F3Open the Excel formula window.
Shift + F5Bring up search box.
Ctrl + ASelect all contents of the worksheet.
Ctrl + BBold highlighted selection.
Ctrl + IItalic highlighted selection.
Ctrl + KInsert link.
Ctrl + UUnderline highlighted selection.
Ctrl + 1Change the format of selected cells.
Ctrl + 5Strikethrough highlighted selection.
Ctrl + PBring up the print dialog box to begin printing.
Ctrl + ZUndo last action.
Ctrl + F3Open Excel Name Manager.
Ctrl + F9Minimize current window.
Ctrl + F10Maximize currently selected window.
Ctrl + F6Switch between open workbooks or windows.
Ctrl + Page upMove between Excel work sheets in the same Excel document.
Ctrl + Page downMove between Excel work sheets in the same Excel document.
Ctrl + TabMove 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 cell currently selected.
Ctrl + Shift + !Format number in comma format.
Ctrl + Shift + $Format number in currency format.
Ctrl + Shift + #Format number in date format.
Ctrl + Shift + %Format number in percentage format.
Ctrl + Shift + ^Format number in scientific format.
Ctrl + Shift + @Format number in time format.
Ctrl + Arrow keyMove to next section of text.
Ctrl + SpaceSelect entire column.


                           -by Harish soni  

Comments

Popular posts from this blog

How to hack any account using Kali Linux

To hack any account using Kali Linux you have to follow some steps:- Step 1:-First of all go to Applications and select the Social Engineering Tool. Step 2:-In Social Engineering Tool select the Social Engineer. Step 3:-Type 1 (Social Engineering Attack) and then Enter,  Step 3:-Type 2 (Website Attack Vectors) and Enter. Step 3:-Type 3 (Credential Harvester Attack Method) and Enter. Step 4:-Type 2 (Site Cloner) and Enter. Step 5:- It will ask you IP address for the Post Back Harvester.To know the IP address open another terminal and Type  ifconfig   and Enter. Step 6:- Now copy your IP address and paste in the first terminal. Step 7:-It will ask you Enter the URL to clone.At there you have to enter the url of the website page.For Example:-https://www.facebook.com/login.php Step 8:- Now your fake page is ready.Send the same IP address that you have entered to your victim.When he/she will try to login the user id and password will automatically come ...

How to make invisible folder

                            How to make invisible folder To make invisible folder follow the step 1. Make a new folder  2. Right click  the new folder and Go to properties then to  Costomize  3. And click change icon

How to Install macOS on a Windows PC

                                      Required Equipment In order to install MacOS Sierra on your Windows computer, you will need the following hardware: USB drive  - Find a flash drive that can hold at least 8 gigabytes (preferably a 10 or 12 gigabyte model). Blank hard drive  - Find a USB external hard drive that holds at least 100 gigabytes (this is where you'll install your MacOS stuff, so the bigger, the better)..                                      Downloading Unibeast Step 1:To download unibeast Make sure you do this on a Mac, since the folder will download the wrong app if you do this on a Windows computer and try to transfer it over to a Mac. Link-- https://www.tonymacx86.com/ Step 2: click on Log in or Register . Step 3: Enter your Email address make sure you have access of that ...

amazon banner

amazon banner2

PTCShare