How to change grid color in Microsoft Excel?


Tired of the gray-gray color of one of its grids while working in Excel ?

You can change the color of the grid if you want. For that ...

Open Excel.

Go to Options by clicking on File (the way to get here may be slightly different depending on the version of Excel).

Go to the ' Advanced ' option in Excel Options .

Scroll down a bit to reach the ' Display options for this worksheet ' section.

Here you will find grid line color options at the bottom.

Click on its drop down arrow , select the desired color and say OK , OK to exit the options.

Now the worksheet grid you selected will appear in the color you selected.

If you want to change the color of the grid to gray again, it is easy. Repeat the above procedure and click on Automatic in the grid line color options. Also note that you can choose different grid line colors for different worksheets in one of your workbooks, i.e. Excel files.

If you have kept different types of data in different worksheets in the same file, then setting different grid line color for each worksheet will make the different data different at first glance.

This is also a way of proper data management!

Comments

Post a Comment

Popular posts from this blog

Ray of hope for scientists! A rare meteorite found in Gujarat may reveal the secrets of other planets

Image
A meteorite fell in Banaskantha of Gujarat last year in the month of August. This type of astronomical phenomenon was observed after about 170 years. Before this, this kind of astronomical phenomenon was seen in 1852. Scientists stationed in the Space Department of Physical Research Laboratory, Ahmedabad have written extensively about this meteorite. The recent meteorites found in Gujarat can prove to be a very important source for understanding planetary processes. Scientists say that this meteorite is Obrite. They have confirmed that this meteorite may have formed from the rarest heterogeneous material found in our solar system. These meteorites were named Deodar meteorites. It fell on August 17, 2022 in Deodar taluk of Gujarat and is hence named as such. According to reports, the villagers saw no sign of him in the sky, only the sound of thunder. A major part of the meteorite fell in Deodar, while another part fell in the nearby village of Rawal. Here the villagers collected lar...
Read more

Ordeal before sending Gaganyaan! ISRO will do a big job on October 21, know the mission objective

Image
Gaganyaan Space: The TV-D1 test flight for Gaganyaan will be launched on October 21 at 7 am from the Satish Dhawan Space Center in Sriharikota. However, after this test, three more test vehicle missions will be conducted. The test involves launching the crew module into outer space and recovering it from the Bay of Bengal after touchdown. This includes testing the Crew Escape System (CIS), which will be used to bring the crew back to Earth if the spacecraft encounters a problem. How important is the mission? This mission of ISRO is very different and special from all the missions till now. So far all the space missions carried out by India have been unmanned. But in this mission, man will be sent from earth to space through space shuttle. After spending seven days there, he will return to earth. This process is very dangerous that is why there are very few countries in the world that have successfully carried out this type of space mission. (Photo-Twitter/ ISRO) The first test w...
Read more

Indian computers will now be ruled by indigenous operating systems, the magic of 'MAYA' will cover the Navy, Army and other forces.

Image
The Ministry of Defense has developed MAYA os with the help of various government agencies including Defense Research and Development Organization (DRDO), Center for Development of Advanced Computing (C-DAC) and National Informatics Center (NIC). It is free and more secure. The Indian government is considering replacing the Windows operating system on computers used in the Ministry of Defense with a new indigenous operating system called Maya OS. What is Maya? MAYA os is a new operating system based on Ubuntu. Ubuntu is a popular Linux distribution that uses free and open source software. Keeping up with new operating system (OS) is also a challenge for the government but the ministry claimed that MAYA OS was introduced to thwart cyber threats and reduce dependence on OS made by global tech companies like Microsoft. MAYA OS is free, so the government will no longer need to own a genuine Windows license or pay for expensive Microsoft Word and other services. Safe from cyber threats ...
Read more

Community feature started rolling out in WhatsApp with large groups

Image
Some time ago we talked in detail in ' Technoworld ' about the new feature called ' Communities ' coming to WhatsApp. This feature is now rolling out and will be rolling out to all users worldwide in the coming months. As of now WhatsApp is missing two things the most - easy chatting with a large number of people and the facility to connect groups on the same topic. Both these deficiencies will now be over. Talking about the example of a school, with the help of the communities feature, the class teachers of each class of the school will be able to create different WhatsApp groups for their students or their parents as usual. School principals can create a ' community ' covering each grade group . For that, the principal will send an invitation to the admin of each class group. They can join the school community by accepting the invitation. School principals can send messages to every group member in their community at once if they want. We ha...
Read more

84 Earth years are equal to 1 year on this planet, captured by James Webb using infrared wavelengths.

Image
Washington, April 27, 2023, Thursday Some give great importance to the number 84 in the philosophy of life according to the scriptures. There are millions of galaxies and billions of stars in the universe. One of the planets around the solar system is Uranus, the American space agency NASA has shared a picture of Uranus. This image was taken from the James Webb Space Telescope. Uranus is the 7th planet of the solar system orbiting the Sun. When the Voyager 2 spacecraft passed through Uranus Pass in 1986, the camera imaged Uranus as a blue-green round light, but no surrounding ring of light. According to NASA, the image taken by James Webb of Uranus using infrared wavelengths shows that the planet has bright rings around it. A special feature of Uranus compared to other planets in the solar system is that it orbits at a 90 degree tilt on its axis. Hence any season on Uranus is extreme. Here in the polar region the sun is bright for years and then it is dark for as many years. This is...
Read more

The first trial in Mission Gaganyan will be empty, the second will be a female robot

Image
New delhi date. 11 July 2022, Monday The full plan of India's Mission Gaganyan has come out. According to the plan, Gaganyan's first trial will be empty while a female robot will be sent to the second trial. Both trials will be completed by the end of this year. There will be a third trial based on both trials in which two people will be sent into space. Union Minister of State for Science and Technology Dr. Jitendra Singh has given full information about Mission Gaganyan's plan. The woman robot that will be sent in the second trial is named Vyom Mitra, he said. This robot has been developed by ISRO. Earlier, the Union Minister had said that this was India's only space mission. Astronauts will be sent into space under the Gaganyan space flight mission. The first test will be held in mid-2022. In the first phase, Gaganyan's unmanned mission will be G1. This will be followed by a robot named Vyom Mitra at the end of 2022. Jitendra Singh further said that more tha...
Read more

E20 : What is ethanol blended petrol? Find out how much cheaper it will be to drive

Image
Indian Prime Minister Narendra Modi is on a visit to Karnataka today. The Prime Minister inaugurated the 'India Energy Week 2023' (IEW) in Bengaluru. The event will run from February 6 to February 8. It aims to showcase India's growing strength as an energy transition superpower. Modi launched ethanol blended fuel E20 The PM will also launch uniforms under Indian Oil's 'Unbottled' initiative. Modi will launch E20, a fuel that blends with ethanol. E20 fuel will be mixed up to 20 percent in petrol. The PM will also dedicate the helicopter factory of Hindustan Aeronautics Limited in Tumakuru. The target for India to achieve E20 fuel is 2025. What is E-20 Petrol? The E in E-20 is ethanol. E-20 means that the amount of ethanol in the petrol is 20 percent. As the number increases, more ethanol will also increase. At present, the petrol available in the country contains about 10 percent ethanol. At present, preparations are underway to make petrol containing 20 pe...
Read more

Minor errors in documents can be corrected with smart find-replace

Image
While we prepare our Microsoft Word documents as accurately as possible , when you have to edit a report or document prepared by someone else , if the person sending you the document is not a perfectionist, he may have made a number of typographical errors, especially one . Repeatedly made the same mistakes! As many people have a habit of entering a space twice after a full stop after finishing the sentence. Many people want to put a question mark or exclamation mark at the end of a sentence by entering a space after typing the last word followed by a question mark or exclamation mark. These are all minor errors. However, when this text is to be arranged in a layout it can move. For example, if there is a space left before the question mark, it can happen that the sentence ends on the first line and the question mark is at the beginning of a new line! Such errors can also be corrected using Word's ' Find-Replace ' feature. Ctrl+h for that   Open the ...
Read more

Now you can know the air pollution level of your city in one click, Google will launch a new feature

Image
Image Source: Freepik Ahmedabad. 24 October 2023 Tuesday Along with the cooling of the country's climate, the influence of pollution has also started to increase. Air pollution has already started increasing in the Delhi NCR area, making breathing difficult. It's important to check the air quality before going outside, so you can plan your outdoor activities. For this, Google is bringing a new feature, with the help of which you can see the air quality index of your city in Google Discover. Google is bringing a new feature Google is reportedly planning to help users track air quality, which would be a great feature for people living in polluted areas, according to a Google report. The platform is widely rolling out AQI cards in the Discover tab on both iOS and Android operating systems. Users will soon find this new tab in the Google app, which will be on the left side of the home screen. However, this feature is not yet available on tablets or Pixel Fold. A new mini car...
Read more

Space 'facts' that you thought were true: but are not!

Image
Spiral galaxies visible from the Earth. (Creative commons, File) Distant planets and enigmatic galaxies have captivated humanity's imagination for ages. In our quest to understand the cosmos, numerous myths and misconceptions have emerged. In a tete-a-tete with astronomy enthusiast and ISRO-recognized space tutor, Tanmaye Vyas describes the cosmos with a critical eye as he helps debunk many of the commonly assumed 'facts'. Here are some of the biggest mistakes walking around camouflaging as well-known facts: "Sun does not rise from the east." Vyas dispels the myth by saying, “We have always heard about how the sun rises in the east and sets in the west.” He adds, “However, this might surprise many that this is a baseless saying.” Vyas explains, “We don't realize that is a generalisation. In fact, it (the sun) only rises due east and sets due west only twice a year: the fall and spring equinoxes.” Each day the rising and setting points change slightly due...
Read more