............ Have a nice day............
USER MENU ID IS UNDEFINED IN FINACLE MIS SERVER   Date of Implementation of "VERY GOOD" Bench Mark for MACPs effect from 25.07.2016   Expected DA from Jan 2017 – 3% or 2% ?    One minute talk time for each Rupee in Airtel Payments Bank   AICPIN for October 2016 : Chances for 5% DA from January 2017   Central Government employees retiring from January 2017 to submit online application   Pre-Budget Views of Govt. Employees for inclusion in the Budget for the Year 2017-18: Confederation i.e. Scrap NPS, Minimum Wage Rs. 26,000 & Fitment Formula etc   On Salary Week, Banks Unlikely to Meet Demand for Extra 1 Lakh Cr   82 per cent ATMs dry because government used that money to pay its own employees   National Anthem Before Movie, Rules Supreme Court. Citizens 'Duty-Bound' To Show Respect    undefined

Thursday, 25 December 2014

Cycling Through Colors in MS Excel


excel logo

There is a tool in MS Excel that allows you to cycle through the font colors available to you, however, it is little known because it is not readily available to you.

Follow the steps below to add the tool so that it is available to you:

  1. In the Excel Options dialog box, click the Office button (in version 2007) and then click Excel Options. In Version 2010, click on File | Options.
  2. Click the Customize option (2007) or Quick Access Toolbar option (2010) at the left side of the dialog box.
  3. In the Choose Commands From drop-down, select All Commands.
  4. In the list of commands, click on Cycle Font Colors to select it.
  5. Click the Add button and it will be copied to the right-hand side of the dialog box.
  6. Click OK.
The Cycle Font Colors tool will now be available to you on your Quick Access toolbar (QAT).
Now, all you have to do is click on the Cycle Font Color tool and the font color in your selected cells will change accordingly. Click again, and the color will change again.

No comments:

Post a Comment