formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-1543711%22%20slang%3D%22en-US%22%3Eformatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1543711%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20copy%20a%20row%20by%20using%20the%20format%20painter%20and%20when%20I%20click%20the%20row%20I%20want%20to%20change%20the%20format%2C%20nothing%20happens.%20I%20had%20this%20issue%20a%20few%20weeks%20ago%20and%20can't%20remember%20exactly%20how%20I%20fixed%20it.%20It%20had%20something%20to%20do%20with%20saving%20as%20a%20certain%20type%2C%20but%20there%20should%20be%20an%20easier%20way%20to%20fix%20this.%20Please%20help.%20I%20do%20majority%20of%20my%20work%20through%20excel%20and%20its%20inconvenient%20and%20delays%20my%20workload.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1543711%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1543992%22%20slang%3D%22en-US%22%3ERe%3A%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1543992%22%20slang%3D%22en-US%22%3Emaybe%20this%20macro%20helps...%3CBR%20%2F%3ESub%20Value_Format()%3CBR%20%2F%3E'%20Formeln%20ersetzen%20durch%20Werte%20mit%20Formate%3CBR%20%2F%3EWorkbooks(%22Datei1.xls%22).Worksheets(%22Tabelle1%22).Range(Sheets(%22Tabelle1%22).UsedRange.Address).Copy%3CBR%20%2F%3EWith%20Workbooks(%22Datei2.xls%22).Worksheets(%22Tabelle1%22).Range(%22A1%22)%3CBR%20%2F%3E.PasteSpecial%20Paste%3A%3DxlValues%20'%20Werte%3CBR%20%2F%3E.PasteSpecial%20Paste%3A%3DxlFormats%20'%20Formate%3CBR%20%2F%3EEnd%20With%3CBR%20%2F%3EApplication.CutCopyMode%20%3D%20False%3CBR%20%2F%3EEnd%20Sub%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1543995%22%20slang%3D%22en-US%22%3ERe%3A%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1543995%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F738957%22%20target%3D%22_blank%22%3E%40Sapphire87%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3EJust%20to%20be%20clear%2C%20Format%20Painter%20will%20no%20copy%20any%20data.%20Really%20just%20the%20text%20format%20of%20whatever%20you%20select.%26nbsp%3B%3C%2FP%3E%3CP%3ESay%20you%20like%20the%20text%20format%20of%20cell%20A1%20and%20want%20to%20replicate%20the%20exact%20same%20in%20cell%20B1%20you%20would%20do%20the%20following%3A%3C%2FP%3E%3COL%3E%3CLI%3Eclick%20cell%20A1%3C%2FLI%3E%3CLI%3Eclick%20%22Format%20Painter%22%3C%2FLI%3E%3CLI%3Eclick%20cell%20B1%3C%2FLI%3E%3C%2FOL%3E%3CP%3EDoing%20so%20%3CSTRONG%3Ewill%20not%20copy%3C%2FSTRONG%3E%20the%20data%20from%20A1%20to%20B1%2C%20only%20the%20text%20format.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1544005%22%20slang%3D%22en-US%22%3ERe%3A%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1544005%22%20slang%3D%22en-US%22%3EIf%2C%20despite%20everything%2C%20the%20problem%20has%20not%20been%20resolved%2C%20because%20...%3CBR%20%2F%3E%3CBR%20%2F%3EPlease%20try%20the%20following%20steps%3A%3CBR%20%2F%3E%3CBR%20%2F%3E1.%20Open%20an%20Administrator%20Command%20Prompt%20window.%20If%20you%20can't%20find%20a%20way%2C%20please%20do%20the%20following%3A%3CBR%20%2F%3E1.%20Press%20Ctrl%20%2B%20Shift%20%2B%20ESC%20and%20open%20the%20Task%20Manager.%3CBR%20%2F%3E2.%20Click%20File%26gt%3B%20Run%20New%20Task%3CBR%20%2F%3E3.%20Make%20sure%20you%20have%20a%20check%20mark%20next%20to%20%22Do%20this%20task%20with%20administrator%20privileges%22.%3CBR%20%2F%3E4.%20Enter%20CMD%20there%3CBR%20%2F%3E%3CBR%20%2F%3E2.%20Then%20enter%20the%20following%20into%20the%20CMD%3A%3CBR%20%2F%3E%3CBR%20%2F%3Esfc%20%2F%20scannow%3CBR%20%2F%3E%3CBR%20%2F%3Echkdsk%3CBR%20%2F%3E%3CBR%20%2F%3EDISM.exe%20%2F%20Online%20%2F%20Cleanup-image%20%2F%20Checkhealth%3CBR%20%2F%3E%3CBR%20%2F%3EDISM.exe%20%2F%20Online%20%2F%20Cleanup-image%20%2F%20Scanhealth%3CBR%20%2F%3E%3CBR%20%2F%3EDISM.exe%20%2F%20online%20%2F%20cleanup-image%20%2F%20restorehealth%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20this%20or%20another%20answer%20helped%20you%2C%20mark%20it%20as%20an%20answer%20to%20help%20others%3C%2FLINGO-BODY%3E
Occasional Visitor

I am trying to copy a row by using the format painter and when I click the row I want to change the format, nothing happens. I had this issue a few weeks ago and can't remember exactly how I fixed it. It had something to do with saving as a certain type, but there should be an easier way to fix this. Please help. I do majority of my work through excel and its inconvenient and delays my workload.

3 Replies
maybe this macro helps...
Sub Value_Format()
' Formeln ersetzen durch Werte mit Formate
Workbooks("Datei1.xls").Worksheets("Tabelle1").Range(Sheets("Tabelle1").UsedRange.Address).Copy
With Workbooks("Datei2.xls").Worksheets("Tabelle1").Range("A1")
.PasteSpecial Paste:=xlValues ' Werte
.PasteSpecial Paste:=xlFormats ' Formate
End With
Application.CutCopyMode = False
End Sub

Hi @Sapphire87 ,

Just to be clear, Format Painter will no copy any data. Really just the text format of whatever you select. 

Say you like the text format of cell A1 and want to replicate the exact same in cell B1 you would do the following:

  1. click cell A1
  2. click "Format Painter"
  3. click cell B1

Doing so will not copy the data from A1 to B1, only the text format.

If, despite everything, the problem has not been resolved, because ...

Please try the following steps:

1. Open an Administrator Command Prompt window. If you can't find a way, please do the following:
1. Press Ctrl + Shift + ESC and open the Task Manager.
2. Click File> Run New Task
3. Make sure you have a check mark next to "Do this task with administrator privileges".
4. Enter CMD there

2. Then enter the following into the CMD:

sfc / scannow

chkdsk

DISM.exe / Online / Cleanup-image / Checkhealth

DISM.exe / Online / Cleanup-image / Scanhealth

DISM.exe / online / cleanup-image / restorehealth

If this or another answer helped you, mark it as an answer to help others