Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

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


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

Reply With Quote
Old 12-20-2018, 11:31 AM
DBlomgren DBlomgren is offline Windows 10 Office 2016
Advanced Beginner
Join Date: Feb 2014
Location: Costa Rica
Posts: 73
DBlomgren is on a distinguished road

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

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
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
Remove white text background (keeping the font color and page color intact cc3125 Word 1 10-26-2015 06:44 PM
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

All times are GMT -7. The time now is 07:47 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft