Why Customize 'Quick Access Toolbar' in Excel?


Earlier in ' TechnoWorld ' we have gone into detail about the ' Quick Access Toolbar ' to keep our frequently used commands ' click away' in the Microsoft Word program . The Quick Access Toolbar is located at the top left of the program , to which we can add the commands we need. This feature is also available in Microsoft Excel.

To customize it in Excel , open Excel and go to its options. Here in the left side panel you will find the option of ' Quick Access Toolbar ' . Selecting it will show Quick Access Toolbar options on the right. On the right side of it, you will see whatever commands are currently set in the Quick Toolbar.

In it, we can decide whether the customization of the Quick Access Toolbar applies only to the currently open file or to all files by selecting the dropdown menu at the top.

By selecting the commands given below, we can change their order with the help of the up-down arrows on the right. Apart from this, in Excel, we can select the command that we use frequently from the left panel and add it to the Quick Access Toolbar using the Add button in the middle.

Here too, selecting 'Popular Commands' or 'All Commands' or the commands in the various tabs in the ribbon using the dropdown arrow for the command at the top will make it easier for us to find the command we need.

For example, if you frequently use the Sum command in Excel, you can add it to the Quick Access Toolbar by selecting ' Sum ' in the Popular Commands and using the Add button in the middle.

This is just one example. You can add many useful commands to the Quick Access Toolbar. That way, after customizing the Quick Access Toolbar to your needs, you won't have to rummage through the title ribbon to find commands you use frequently. You can also use the drop down arrow on the rightmost side of the Quick Access Toolbar to access the Microsoft Excel options . Clicking it will instantly bring up some useful commands. One can select any of them or click on ' More Commands ' to go to the options we talked about.

And yes , the Quick Access Toolbar can be customized in Microsoft Word or PowerPoint in exactly the same way!

Comments

Post a Comment

Popular posts from this blog

The lines written by the left, are now decreasing!

Image
- ¼khík swËe swËe ½ýe heíku rzrsx÷ çkLke hÌkwt Au, yk rËþk{ktLke Lkðe Ãknu÷ Au rzrsÞkºkk Hum jahan khade hote hain , line wahin se shuru hoti hai... '' What is the reason why people remember this dialogue of Amitabh Bachchan even after many years ? Bachchan Sahib's acting is true , our embarrassment in front of the line also has a big role in it! The population of our country is so much that everywhere we have to stand in line waiting for our turn. Over the years we have become accustomed to lines , bored and bored. But as you may have also noticed , many of the previous lines are now starting to disappear! Earlier we used to queue up at STD booths to make cheap phone calls after ten at night , now that is a thing of the past. Earlier we used to stand in queues to buy tickets for movies , buses , trains , tickets, etc. Now that work falls on mobiles. Earlier, you had to stand in a queue in the bank or outside the ATM , now many of the real work of...
Read more

Darkness will be the enemy of Chandrayaan! How the lander and rover on the moon will work at night, this time is the most challenging

Image
One day on the Moon is equal to 14 days on Earth. In this regard, rover Pragyan and lander Vikram, which reached the lunar surface by Chandrayaan 3 on August 23, have only a few days left. Although ISRO scientists have not ruled out the possibility of Pragyan and Vikram resuming operations, it has become important for the rover to acquire data quickly. Isro's important phase begins on the moon ISRO has said that Chandrayaan 3 is going to do three major tasks on the moon. It includes soft landing on the lunar surface, exploration of the lunar surface and some experiments on the surface. So far ISRO has been successful in the first two, but the experimental phase is still ongoing. Vikram and Pragyan carry the payload through which the data is being collected. An attempt to cover a distance of 300 to 400 meters on the moon SAC director Nilesh M Desai says that scientists are trying to cover the maximum distance to the South Pole. He said that in the remaining days, scientists are...
Read more

Heart rate was 110 beats per minute before Neil Armstrong set foot on the moon.

Image
Washington, July 20, 2021, Tuesday As part of the Apollo 11 mission, the US space agency NASA launched Apollo 11 at 1:05 pm local time on July 17. It reached its orbit 15 minutes later. Four days later, the astronauts covered a distance of 3 lakh km and reached the moon. The Apollo 11 mission aroused the curiosity of astronauts and space science enthusiasts. It entered lunar orbit on July 16. It was then decided to land at a place about 50 km southwest of the moon's scatter Sabin dish. The Ranger-2 and Surveyor-2 surveys conducted a comparative study of the area in which the area was found to be flat for landings compared to others. A portion of Apollo 11 was released from the Eagle Command module Scholambias. Neil sent a message to the control center in Houston that they were safe, albeit a short distance from the target. The spacecraft landed northeast of the 50-meter-diameter Swift Cretaceous with 6 seconds of fuel remaining. After the first commander Neil Armstrong landed, ...
Read more

NGT orders report on health impact of microplastics in human blood

Image
Image: Representative Image (From Representative) Ahmedabad, Friday The National Green Tribunal has ordered to prepare and submit a detailed research-based report on the effects of microplastic particles found in the human body on human health. Details of its physical and mental effects have been reported. Micro plastic particles have been found in the blood flowing through the human body due to the units posing a threat to human health by polluting water, land and forest. Microplastics enter the bloodstream through food and water The present order comes after a committee constituted by the National Green Tribunal upheld the fact that fine particles of plastic are being found in the blood of the human body. Fine particles of microplastics are getting into the blood cells through food and water. Due to this, the risk to human health is increasing. Even through breathing, heavy metals are entering the human body. Microplastic particles in human blood are also increasing due to water...
Read more

ISRO launches 'Navik' satellite, will keep an eye on enemies with enhanced security

Image
From earth to space, India has achieved many achievements. On Monday, the Indian Space Research Organisation, i.e. ISRO, successfully launched the navigation satellite NVS-1. This is part of the Spacecraft Navigation with Indian Constellation series. ISRO aims to increase capacity in the field of monitoring and navigation through this. The 2232 kg satellite (GSLV) was launched from the second launch pad at the Satish Dhawan Space Center in Sriharikota using the Geosynchronous Satellite Launch Vehicle. #WATCH | @isro creates history! GSLV lifts off 15th flight carrying navigation satellite NVS-01 from second launch pad at SDSC, Sriharikota. #NVS01 is the first of the second-generation satellites envisaged for the Navigation with Indian Constellation (NavIC) services. NVS… pic.twitter.com/vuF0e3ALBM — DD News (@DDNewslive) May 29, 2023 Important contribution of Space Application Center at Ahmedabad A rubidium atomic clock manufactured by the Space Applications Center in Ahmeda...
Read more

A major change in the method of syncing contacts in smartphones

Image
- ykÃkýk fkuLxuõxTMk økqøk÷ yufkWLx{kt Mkuð fhðkLkk ½ýk VkÞËk Au, Ãký íkuLke rMkLf ÃkØrík nðu çkË÷kE Au Now there has been a big change in the way our contacts are stored in our Google account and on our smartphones. If you use different smartphones for personal use and office use but have the same Google account for both purposes , then this change will be fine for you , but otherwise the change may be very confusing for the average user. The reason is that if you sometimes go to the settings related to your Google account on the phone, then with one click, all the contacts visible on your phone can disappear! About this change   Before doing that, let's talk about how contacts are stored in our Google account and smartphone. How are contacts stored now ? In smartphones we can save contacts in the internal memory of the phone , in the SIM card of the phone and in the cloud account like Google/Apple. But you must know that it is imperative to store all our contac...
Read more

Facebook launches dating app to find a partner, find out what's special about it

Image
Ahmedabad. Sunday, October 25, 2020 If you are looking for a partner in your life, Facebook will soon be your support. Because, now you don't need to go to a dating app or visit a metromonial site to find a partner. Now, social media giant Facebook has launched its much awaited dating service Facebook Dating in the UK and Europe. For that you can make friends on Facebook as well as choose a partner. Possible to contact a potential partner 'Facebook Dating' is allowing the user to create a separate account from the original one. Through Facebook dating, it is possible not only to contact a potential partner present in the surrounding area, but also to resort to chatting and virtual calls to get to know them intimately. According to the company, more than 1.5 billion matches have been created in 20 countries since Facebook started dating last September. This facility is not currently launched in India. Reunion will happen through Secret Crush There is also an interestin...
Read more

400 howitzer guns will be bought for Indian Army, know the strength of Made in India guns

Image
Defense Ministry: Indian Army is now focusing on 155 millimeter cannon. These cannons can fire not only shells but also precision firing, rockets, drones. In fact, the Indian Army is going to buy 400 new guns. It also includes Dhanush, Sharang, Ultra Light Howitzer, K-9 Vajra Tank. DHANUSH The 155 mm/45 caliber TOD Howitzer Dhanush was inducted into the Indian Army in 2019. This is an indigenous version of the Bofors cannon. At present the army has 12 bows. An order has been placed for 114. A crew of 6 to 8 is required to operate the bow. Its shell has a range of 38 kilometers. Which fires three rounds in this 15 seconds in burst mode. 15 rounds in 3 minutes in Intense mode and 60 rounds in 60 minutes in Sustained mode, meaning can defeat the enemy as needed. M-46 Sharang This is a field gun, which has two variants. 133 millimeters and 155 millimeters. India has 1100 such field guns. It fires in three rates. Usually 6 rounds in a minute. Fires 8 rounds in burst mode and 5 rounds ...
Read more

For the first time in the history of medical science, an HIV patient recovered automatically

Image
New York, September 1, 2020, Tuesday There is no cure for HIV / AIDS in the world. Some medications can prolong life but do not destroy the virus that weakens the immune system. However, scientists and doctors are surprised that an HIV patient recovers without any treatment. There have been two previous cases in which the virus did not re-enter the body after bone marrow transfer, but it is the first time that the HIV virus has exited without any treatment, perhaps because the immune system has destroyed it. According to information published in the journal Nature, the doctors examined 120 million cells in the body. The AIDS patient was then named ECTU. The fact that the body was free of the HIV virus meant that the body had eliminated it. In addition, 100 million cells from another AIDS patient were examined, in which doctors found only one virus to be active. However, the active virus also appeared to be genetically inactive. This also meant that the genetics of both AIDS patient...
Read more

BharatOS for the people of India, of the people of India, by the people of India!

Image
For the security of India's sensitive data, a special type of smartphone operating system was developed The Android operating system (OS) has long dominated the smartphone market. In second place is Apple's operating system. In the case of Android, the phone manufacturing company can make its own changes to the original Android software , but ultimately the ' new ' OS also remains under the control of various private companies. In this matter there is a big problem of security of user's data. Keeping this in mind, the Indian government has been in the forefront of developing its own operating system for a long time. Now there is news that India has become self-sufficient in this regard - a company incubated at IIT Madras has developed such an indigenous mobile operating system. Apparently it has been named ' BharatOS ' . Of course , it is not clear whether he is fully Indian or not. ' BharatOS ' has been developed for computer...
Read more