Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-19-2018, 03:25 PM
emvella emvella is offline Last Color Windows XP Last Color Office 2007
Novice
Last Color
 
Join Date: Sep 2009
Posts: 11
emvella is on a distinguished road
Default Last Color

Hi,



Please how can I make Excel remembering last fill color I used, so I dont have to select the color each time?

Thanks
Reply With Quote
  #2  
Old 12-20-2018, 11:31 AM
DBlomgren DBlomgren is offline Last Color Windows 10 Last Color Office 2016
Advanced Beginner
 
Join Date: Feb 2014
Location: New York, USA
Posts: 82
DBlomgren is on a distinguished road
Default

This may or may not work for you.

1. Apply the color you want to a cell or group of cells.
2. Select the next cell or group and hit Ctrl-Y. Ctrl-Y repeats the last edit you made. Continue with other cells.



Note that if you make another type of edit and then hit Ctrl-Y, it will now repeat the new edit.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Last Color VBA change font color to background color donaldadams1951 Word VBA 6 05-31-2018 04:36 PM
Macro to change an RGB table cell shading color to another RGB color David Matthews Word VBA 4 05-29-2018 02:45 PM
Advanced Font Color Manipulation In Word: Inserting another color than the surrounding text stuartg Word 1 02-20-2017 12:38 AM
Last Color Remove white text background (keeping the font color and page color intact cc3125 Word 1 10-26-2015 06:44 PM
Last Color I created a custom XML color scheme. How do I add that to the Built-in Color? Cassik PowerPoint 5 11-04-2013 02:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:55 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft