How do I format cells to get rid of a green triangle in the cell?
C Chip Pearson Jun 16, 2006 #2 You can't do it with formatting. Go to the Tools menu, choose Options, then the Error Checking tab. There, uncheck "Enable background error checking". -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
You can't do it with formatting. Go to the Tools menu, choose Options, then the Error Checking tab. There, uncheck "Enable background error checking". -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
G Guest Jun 16, 2006 #3 Thanks, that got rid of the triangle but the data is still indented. How do I remove the indentation?
Thanks, that got rid of the triangle but the data is still indented. How do I remove the indentation?
C Chip Pearson Jun 16, 2006 #5 You can click the "Decrease Indent" button on the Formatting toolbar, or you an use VBA Sub AAA() Selection.IndentLevel = 0 End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
You can click the "Decrease Indent" button on the Formatting toolbar, or you an use VBA Sub AAA() Selection.IndentLevel = 0 End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com