Excel - Choosing a cell style

Ask a question




Excel provide you with several customization options for your column or cells:
  • For example: if you have a particular column dealing with currencies or percentages, you can customize it with the Cell Style options and upon entering your data, the currency/percentage symbols will be automatically entered.


Example:
  • Consider that in your worksheet you have a specific column for wages:
  • Simply select(click/hold/drag) the concerned data cell and then in the Styles tab, click on the Cell Styles Button.
  • Then Click on the Currency button.
  • From now on each time you enter data in this column the currency symbol will be automatically be entered.
Jean-François Pillou

CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Learn more about the CCM team