painter

In the Home tab, when I click "Format Painter", it opens the Clipboard. Sometimes there is an item there called (preview not available). I will hit Clear All but it doesn't get cleared. Also, when I Copy my selection in order to add to the Clipboard, nothing happens. Anyone know what is the issue?

Hi I am tying to continue a CD from top row of a table to the next 100 rows. I have tried the format painter but this holds onto the first row as its limiting factor, and i have tried removing all $ signs but is still not working A1 = 10 B1 = 12 - i want B1 to be red A2 = 15 B2 = 8 - i want B2...

Hi all, so I am using Pivot Tables to create charts (Pie, Bar, Donut...!) on Excel 2016, from the data. I have formatted them rather nicely, but whenever I create a new one, is there a way to copy the formatting of one to another? I have tried Ctrl+C, but no paste special (format) dialogue box...

Hi all i have several of charts where i have formatted some points using a graduent fill effect linear. what i want to do is copy this colour and format painter it on a data point on another chart (not whole chart) and also format painter a cell and shape with this colour. What is the best...

Hi Everyone, I have a problem with the excel file concerning Salary as fille attached beside https://drive.google.com/open?id=0B09aWVwPVw7FWUZOTHVkUEc0NVk I am trying: 1/ FORMAT PAINTER every collumn to others - ex: column R to S - for the first time, it takes very long to finish the action...

What is the fastest way to format painter from one workbook to another? I need to format painter "workbook 1" cells, A-BJ to "workbook 2" cells A-BJ. I need to do this for over 500 workbooks. Is there a special formula I can use or macro to format these fast?

Hi, I'm hoping there is an easy fix for this. I have a sheet which has a number of subtotal rows (the number of subtotal rows may vary depending on the data). I'd like to increase the row height for only the subtotal rows (not the rows of data included in the subtotal (above the subtotal...