RSS

Double Underline the Cell Content

07 Apr

Your boss is a rigid. He says you should double underline the grand total in a report. As the results show in the below figure, you only have an underline icon on the Formatting toolbar. So, what do you do now?

Select the Grand Total cell. From the menu, select Format – Cells – Font. In the Underline dropdown, choose double or double accounting. The cell will have a double underline, as shown in Fig below.

Alternatively (and this also works in Excel 2007 and 2010), you can right-click on the cell in question and choose Format Cells. Go to the Font tab and select the appropriate option from the Underline drop down list. Click OK to return to your spreadsheet.

Quick Tip: If you need to double underline several values, you can just perform this sequence once. Then, you can copy that cell and paste the format only to other cells on your spreadsheet

 Commands Discussed: Format – Cells – Font – Underline

Feel free to drop mail or comment incase of any doubt at thinkandbegin@gmail.com.

 

Advertisements
 
Leave a comment

Posted by on April 7, 2012 in MS Excel, My Home

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: