Repeat entries onworksheets

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:53 PM GMT

Question

Once I have formatted a cell how do I repeat the result without having to go through the whole formatting process once again. Is there something other than copy and paste regarding formatting options?

Answer

The little icon that looks like a paintbrush is the format painter -- Select the cell with the formatting you want, then click the paintbrush, then drag across the cells you want to take on the same formatting. If you're doing several non-contiguous cells, doble-click the paintbrush which keeps it "alive", and to stop "painting", press the esc key

Advertisement

©2021 eLuminary LLC. All rights reserved.