The Outline group in Excel gives you the following options which can be used to treat a group of cells as a unit. · Group · Ungroup · Subtotal Mehar is calculating her monthly expenses using an Excel sheet. How can she make her work easy to detect where she has to cut down her …
Roshan noticed doesn’t want the Excel sheet he is working upon to show the headings. He wonders if there is a way to hide this. Here is how we can help him. Excel allows its users to hide both gridlines and headings while working with it. There are two ways to do this as follows …
After a user inserts a graphic like SmartArt, by default, the ‘SmartArt Tools’ menu opens on the ribbon. It has two different tabs- Design and Format. Under the ‘Design’ tab, you can modify the SmartArt style to make it look different and visually more appealing. Using the SmartArt tools, Farah wants to change the style …
Often, after we insert a graphic, like SmartArt, we will find a need to edit and modify it to suit our purposes. Farah is in a similar position. She has inserted a bullet-in SmartArt but wants to change it now. What are the options she has? She has many options to do this using the …
Priya sees that all the charts she inserts are in blue colour. Why is this happening and how can she change it? This is because the theme of the sheet she is working with is set to blue. The theme of the sheet will decide the basic colouring of it like the shapes inserted, the …