For most cases, in the fridge is best for both red and white.
If you like the way the wine tastes, then you want to keep it cold and away from air. I found the best way to do this is to get a 4-pack of blue-fish or other small (187mL) wine with screw caps, and glass bottles. Fill these to the top with your leftover wine, and put in the fridge. Seems to hold flavor profile for a week or so. This also gives you about 1-glass per bottle which can be good for mid-week glass with a meal.
If a red wine is tannic then having some extra air and sitting on the counter at room temp overnight can help to reduce the bitter taste.
Some people
freeze wine. Haven't tried that yet, but apparently there has been some good success.