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

Five decades after man's arrival, 'moon trip' difficult, 60 out of 146 missions fail

Image
India tried to land on the moon in 2019 which failed. In 2023, India's space agency ISRO successfully landed on the moon. India is the first country to successfully land on the South Pole of the Moon unscathed. This success of India is also big because so far a total of 146 lunar missions have been launched out of which 60 have failed. Only four countries made a soft landing on the lunar surface According to Dr. Gail Isles of RMIT University, Australia, the Moon is the only celestial body other than Earth where humans have set foot. It also makes sense to go there first as it is our closest object at about four kilometers away. Interestingly, only four countries have made a soft landing on the surface of the moon so far. On the other hand, its South Pole is still mysterious, where only India has been able to reach. So many countries have failed Even Russia, the first country to make a soft landing on the moon 60 years ago, recently failed to land Luna-25 on the moon's sout...
Read more

The transmission power of Corona virus sticking to the surface decreases after 5 days - research

Image
London, 10, June, 2020, Wednesday It is common knowledge that the corona virus is spread from person to person through sneezing and nasal and oral droplets, as well as if the corona virus is spread on a plastic metal or other surface. There has been a lot of research on how long the corona virus survives on which surface, but the research done by the University College London in Britain is shocking. According to research published in the Journal of Hospital Infections, corona viruses can live on any surface for up to five days at most. It can spread to a large area within the first 10 hours when the transmissible power of the corona virus, which landed on the surface on the fifth day, was reduced. Observed after 10 hours, it spread to every corner of the ward. During the experiment Corona used a virus to infect artificial plants with a virus for a patient's breath that could not infect a man. Both viruses were then found in a drop of water and left on the bed railing. The viru...
Read more

Solid evidence of flowing water on Mars, the red planet of the Solar System: Images of pebbles and rocks found

Image
- Amazing exploration of NASA's Perseverance rover - Rocks and pebbles found at Castel Henlez, near Jezero Ulcakund, must have been washed up by stormy river floods in the past. Washington/Mumbai: The mysteries and wonders of our solar system, including the infinite universe, are also being discovered. Earth's neighbor and the red planet of the Solar System, Mars, has strong evidence of past flowing water. The Perseverance rover of the American space research organization National Aeronautics and Space Administration (NASA), which is researching on Mars, has found strong evidence of water flowing on the surface of Mars in the past, i.e. millions of years ago. Evidence has been found. Now, based on all these evidences, there is also a strong indication that if there was flowing water on this red planet in the past, there must have been a phase of life there. NASA sources informed that our Perseverance rover has landed in the vicinity of Jezero meteorite on Mars on February ...
Read more

If you are interested in astronomy due to solar eclipse, let us know about an app to install in your phone.

Image
A cosmological app in the palm of your hand! An exciting event took place in space yesterday - a circular solar eclipse or say 'Ring of Fire' solar eclipses! The spread of the corona virus has disrupted daily life on Earth, but everything in space is moving at a steady pace! Yesterday's solar eclipse was the result of such a fixed, fixed, annual cycle of events! We all know that the various planets in our universe revolve around the immovable sun, these planets have their own satellites. The earth itself rotates on its axis, tilted slightly, and at the same time revolves around the sun. If we talk only about the earth, due to the orbit of the earth around the sun, the motion of the earth on its own axis and the orbit of the moon around the earth, various exciting astronomical events are created. One of them is this kind of annual annular solar eclipse. Such a solar eclipse occurs when the Sun, Moon and Earth are in a straight line, all three on almost the same surfac...
Read more

Successful landing of private company Intuitive's Odysseus spacecraft on the South Pole of the Moon

Image
- After 50 years, America again on the lunar soil - Now the future human settlement on the moon will be prepared according to the Artemis program: NASA scientists in the lander Washington: Today America has returned to the moon after 50 years. Today, Thursday, February 23, 2024, at 6:2 pm (US time), the lander Odysseus of America's first private company, Intuitive Machines (Houston), has landed safely on the South Pole of the Moon. The Odysseus lander touched down on the lunar surface at 4:30 a.m. Indian time on Friday. America's space research organization National Aeronautics and Space Administration (NASA) administrator Bill Nelson has expressed his happiness on this historic occasion by showing such enthusiasm. Intuitive Machines Company has developed such a Commercial Lunar Payload Services (CLPES) program with technical and financial support from NASA. NASA's Apollo-17 spacecraft was launched on December 7, 1972. Then, after exactly 13 days of space travel, Apoll...
Read more

For the first time, NASA is sending a drone helicopter to Mars

Image
New delhi date. Thursday, July 30, 2020 Man has always been experimenting and inventing new things. It has always been interesting to know about the different planets in space. Mars is the most special of these, as it is believed that if there is any planet other than Earth that could be habitable by humans, it is Mars. There is also ample evidence of the existence of water here. The search is still on. The US space agency is launching the Mars mission. The peculiarity of this mission is that for the first time NASA will also send a drone helicopter to Mars along with the rover. For this reason the mission is named Perseverance Mars Rover and Ingenuity Helicopter. According to NASA, the rover will collect information by walking on the surface of Mars while the helicopter will receive information by flying. The Mars rover weighs 1000 kg while the drone helicopter weighs two kg. The rover is also fitted with a Mars Environmental Dynamics Analyzer which will get information about the t...
Read more

Is a solar storm moving towards the earth at a speed of 12 lakh km per hour?

Image
New York, October 16, 2021, Friday With the development of space science, new information about space and planets is coming out. According to the information received, a tremendous solar storm is moving towards the earth. Solar storms could hit Earth in a matter of hours, according to a new US warning. Researchers are divided over what effect this will have on the Earth, but some believe it could have an adverse effect on power supplies, GPS systems and mobile signals. Scientists have warned that Northern Lights from space could also appear in the US and UK. The U.S. National Oceanic and Atmospheric Administration says a solar storm could cause lightning in many parts of the earth. Magnetic force can also be felt in some places. This can also damage the power grid. The storm, which started on October 11, has intensified since October 15. It is moving at a speed of 12 lakh km per hour. The last time such a dangerous storm occurred was in 19. However at that time there was no promoti...
Read more

How were the Himalayas formed? One minute breathtaking video, find out how long it took…

Image
Himalaya : How did our Himalayan mountain range come into existence, do you have any idea? If not then you will find this report very useful. A video is currently going viral on social media, by seeing which you will get an idea of ​​the creation of the Himalayas. India was an island. Then he approached Asia and collided with him. It is claimed that the Himalayas were created by this collision. You will get to see this entire story in a one minute video. When did this process start? India moved towards Asia 8.80 million years ago. India was then a huge island. At that time the world's tectonic plates were very small. When these plates started sliding, they started colliding with each other. It created Mahatapu. The Indian plate collided with the Eurasian plate. It must have created a very intense pressure. The Tethys was a sea in place of the Himalayas This pressure created a mountain range of high peaks. It is said that the Himalayas exist here today. There used to be a sea ...
Read more

IIT researchers develop real-time underwater marine robot, eases deep-sea surveillance

Image
image : Envato and Twitter Real-time underwater marine robot: Indian Institute of Technology (IIT) Mandi and Palakkad have achieved a tremendous achievement in developing real-time underwater marine robot for underwater surveillance. The function of this robot will be close underwater monitoring and verification. Its level of efficacy would be very high, risk would be extremely low and it would likely be cost-effective, the researchers said. Jagdish Kadian, assistant professor at the Center for Artificial Intelligence and Robotics at IIT Mandi, said that learning about the ocean's internal currents from history led to the conclusion that only by placing instruments on research ships deep can one gain more insight into the ocean. Kadian, a co-author of the study, said that a typical cruise ship stays on the surface for a month or two, limiting the possibility of producing a comprehensive report on the sea. So it has often been said that changes in the sea do not wait for a ship ...
Read more

Nokia wins case against Oppo and OnePlus, can't sell phones in this country

Image
Ahmedabad, 12 July 2022, Tuesday Oppo and One Plus, the smartphone giants that dominate the Indian market, have been hit hard. The companies have lost a lawsuit against Nokia and will no longer be able to sell their phones in Germany. The shocking news came after Nokia's decision in the case. The court has ruled in favor of Nokia in the patent dispute. After this, the smartphones of Oppo and OnePlus have stopped here. Nokia has filed 9 separate cases against Oppo. Oppo and One Plus will not be able to sell 4G and 5G phones in Germany as the patent rights of OPO and One Plus are invalidated in today's verdict. Nokia claims that Oppo and OnePlus violate EP 29 81 103 and EP 32 20 562. This is not the first time Oppo has been shocked by the court. Earlier Oppo was also shocked in the EP 17 04 731 patent case. Now the court said that this patent also belongs to the same family in which the decision has been given earlier by the court. In such a situation, this decision also goes...
Read more