I want to apply different styles to columns in one worksheet
I want one column on the worksheet to be date and another column to be
accounting, but when I highlight one column and change the style, the style changes for both columns. How do I isolate each column to be a particular style? Sunny |
I want to apply different styles to columns in one worksheet
You have confused Style for Format. I will just tell you how to solve your
problem and not bother to explain the difference. 1) Select the first column; click on the menu item Format, then on Cell 2) In the resulting dialog in the Categories list, select Date; the chose how you want the date to appear (1/1/2008 or 1 Jan 2008, etc) 3) Click the OK button on the dialog Repeat these steps with the next column but use Accounting Come back if you have problems best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "SunnyG" wrote in message ... I want one column on the worksheet to be date and another column to be accounting, but when I highlight one column and change the style, the style changes for both columns. How do I isolate each column to be a particular style? Sunny |
All times are GMT +1. The time now is 05:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com