Author: Brijesh Yadav

Undo Changes You can reverse almost every action in Excel by using the Undo command. We can undo changes in following two ways. From the Quick access tool-bar » Click Undo. Press Control + Z. Undo actions You can reverse the effects of the past 100 actions that you performed by executing Undo more than […]

Formatting Cell MS Excel Cell can hold different types of data like Numbers, Currency, Dates, etc. You can set the cell type in various ways as shown below − Right Click on the cell » Format cells » Number. Click on the Ribbon from the ribbon. Set Cell Type Various Cell Formats Below are the […]

You can assign any of the fonts that is installed for your printer to cells in a worksheet. (toc) Setting Font from Home You can set the font of the selected text from Home » Font group » select the font. Set Font from Home Tab Setting Font From Format Cell Dialogue Right click on cell […]

You can change the text decoration of the cell to change its look and feel. (toc) Text Decoration Various options are available in Home tab of the ribbon as mentioned below. Bold − It makes the text in bold by choosing Home » Font Group » Click B or Press Control + B. Italic − It makes the text italic […]

You can rotate the cell by any degree to change the orientation of the cell. (toc) Rotating Cell from Home Tab Click on the orientation in the Home tab. Choose options available like Angle CounterClockwise, Angle Clockwise, etc. Rotate cell from Home tab Rotating Cell from Formatting Cell Right Click on the cell. Choose Format cells » Alignment […]

You can change the background color of the cell or text color. (toc) Changing Background Color By default the background color of the cell is white in MS Excel. You can change it as per your need from Home tab » Font group » Background color. Change Backgropund Color Changing Foreground Color By default, the foreground […]

If you don’t like the default alignment of the cell, you can make changes in the alignment of the cell. Below are the various ways of doing it. (toc) Change Alignment from Home Tab You can change the Horizontal and vertical alignment of the cell. By default, Excel aligns numbers to the right and text […]