If I copy a sheet into a workbook that has a different "Normal" cell style, I get a new cell style "Normal 2". In Excel 2003, I could bring up the style dialog box and delete the extra style. I can't seem to get to that dialog box under Excel 2010 (oh, how I hate the ribbon.)
Appreciate any assistance on how I can delete cell styles!
Cheers,
Michael E.
Washington, D.C.
Last edited by meyestone; 01-11-2012 at 04:55 PM.
When you go to paste right click and under "paste" there will be several options one of which will be keep source formatting. Thats the one you want.
Hth
STOP! CONTINENTAL DRIFT.
Thanks for the rapidity of your response, but no, I want to delete a style from the workbook, not simply "Paste, Values" (which is a perfectly useful thing to do but different from what I'm looking to do.)
To clarify, if you click on the "Cell Styles" button in the "Styles" ribbon group, you get a drop-down pane that includes a list of all the cell styles defined for the workbook. The only dialog boxes available from that pane are "New Cell Style" and "Merge Styles". Neither allow me to delete any of the existing cell styles.
Right-click a style in the style gallery, select Delete.
Entia non sunt multiplicanda sine necessitate
Aha! Awesome, thanks very much.
Er... now I need to figure out how to mark this thread "solved"!
The forum rules explain everything you need to know about the board.
Thanks - I've made the change.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks