Software

Ask something
Discussion Locked

Microsoft Excel 97

0 helpful
1 reply

by nghishekwat

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a few question to ask.
Is there a way to add your own list of AutoFormat to the Autoformat command from the Format menu in Excel?

Can you sort a list in Excel according to color and Font, using the AutoFilter command or any other automatice filter or manipulations
e.g you receive a worksheet full of colors, and the colors that are the same, is for data/record that can be grouped together. The same e.g applies for font.

Does one perhaps need to record a macro for this?
Thank you for you time.

1 reply

by pxttocyob

yes you record a macro for this. Just start recording then do the operation and then stop recording, then just apply the macro whenever you need to have it done.

This discussion is closed to new replies.