Computer Shortcut Keys for MS Excel If you’re new to MS Excel, it can be tough to remember all the keyboard shortcuts. Below is a handy table of all the shortcut keys for MS Excel.

 Shortcuts Uses of Shortcut Keys

Ctrl + C


It is used to copy selected cells.


Ctrl + V


It is used to paste select cells.


Ctrl + Shift + Arrow Keys


It selects multiple cells.


F2


This edit the selected cell.


F4 This repeats the last action.

F5 it is used to go to a specific cell.

F7 It is used for Spell check on selected text and/or documents.

F11 Created Chart.

Ctrl + Shift + ; It entered the current time.

Ctrl + ; This entered the current date.

Alt + Shift + F1 It inserts a new worksheet.

Shift + F3 This opens the Excel formula window.

Shift + F5 Bring up the search box.

Ctrl + B It is used for bold highlighted selections.

Ctrl + I It is used for italicizing highlighted selections.

Ctrl + D Fill

Ctrl + K It is used to insert Links.

Ctrl + F / Ctrl + H Used for open find and replace options.

Ctrl + G Used to open go-to options.

Ctrl + U It is used to underline highlighted selections.

Ctrl + Y It is used to underline selected text.

Ctrl + 5 Used to strikethrough highlighted selection.

Ctrl + O It is used to open Options.

Ctrl + N This opens a new document.

Ctrl + F9 It minimizes the current window.

Ctrl + F10 It maximizes the currently selected window.

Ctrl + P It opens the print dialogue box.

Ctrl + Z This undoes the last action.

Ctrl + F6 It switches between open workbooks/windows.

Ctrl + It is used to insert the value of the above cell into the current cell.

Ctrl + Page up & Page Down It moves between Excel sheets.


Ctrl + Shift + $ This format number is in currency format.

Alt + = Used to create the formula to sum all of the above cells.

Ctrl + Tab It is used to move between two or more open Excel files.

Ctrl + Shift + ! Used to format numbers in comma format.

Ctrl + Shift + % This is used to format numbers in a percentage format.

Ctrl + Shift + ^ This is used to format numbers in scientific format.

Ctrl + Shift + # This shortcut is used to format numbers in date format.

Ctrl + W Close document.

Ctrl + Space This is used to select the entire column.

Ctrl + Shift + @ This format number is in time format.

Ctrl + Right arrow It moves to the next section of the text.

Shift + Space It selects the entire row.

Comments

Post a Comment

Popular posts from this blog

Big predictions for 2024, many seem to be coming true, there is also a claim on the day of the end of the world Baba Venga, born in 1911 and left this world in 1996, is known worldwide for her predictions. He gained a lot of fame by predicting the death of Princess Diana. Many claims made by him were proven true after his death.

Image
 Bulgaria's mysterious Baba Venga has made many predictions for the year 2024. Blind Baba Venga made several claims for 2024 before his death in 1996 at the age of 85. Some of these appear to be recovering and the early months of this year have seen turmoil in many parts of the world. Baba Venga, who has predicted major global events such as the 9/11 attacks, Chernobyl disaster and the death of Princess Diana, has many predictions for 2024. Baba Vanga has been compared to the French astrologer Nostradamus, whose predictions brought him recognition during and after the Renaissance. Baba Venga also made many big predictions in the same way. Among the important predictions made by Baba Venga for 2024, climate change is prominent. Baba Venga predicted the occurrence of severe weather events and natural disasters in 2024. This is also proving to be true. The study shows that peak temperatures have increased. The World Meteorological Organization has said that it is likely that 2024 will
Read more

What is the basics of a ketogenic diet ?

Image
 What is a keto diet? Keto or ketosis is a process of your body using fat as fuel for energy, rather than carbohydrates. To understand everything about keto we also need to understand that the body primarily uses carbohydrates as energy or fuel. Once you shut those down, the body then starts using fats and produces ketones. Once your body is producing ketones, this means that now your body will be using fat as energy rather than carbs. Thus, a beginners guide to ketosis would state the keto diet as a high-fat, moderate protein and extremely low carb diet. What? You can burn fat by eating fat? Yes you can, but not the ghee you put on your paratha’s. Healthy fats that help you attain good cholesterol. But how is this even possible? Well the body actually prefers to use glucose i.e. glycogen for fuel. That essentially means that your body will use carbs first and fat later. Eating carbs also increases insulin which promotes fat storage. Essentially by taking a high fat, low carb approach,
Read more

Keep these self defense things with you If you also keep traveling alone or are going to travel in the coming days, then today we are telling you things related to safety. By adopting these you can make your journey happy.

Image
  Nowadays, traveling alone has become a common thing. Children always have to go out due to studies and job. Parents are so busy that they are not able to go there again and again. Everyone's life is so busy that no one waits to travel somewhere. Be it men or women, everyone travels as per their convenience and requirement. If you also keep traveling alone or are going to travel in the coming days, then today we are telling you things related to safety. By adopting these you can make your journey happy. Every woman knows that the outside world is not safe for them, but still many women do not keep some such security measures with them and that is why we are telling you about some such security options, which you will find very useful. . You can easily carry them with you and can easily get these things in the market. pepper spray Be sure to carry pepper spray on a solo trip and it is also very easy to carry. It is designed in such a way that you can use it in times of problem. The
Read more