servstill.blogg.se - Select all lines in excel and change color in excel 2016

SELECT ALL LINES IN EXCEL AND CHANGE COLOR IN EXCEL 2016 WINDOWS

Select Com Add-Ins from the drop down window at the bottom of the box.

Click the File tab or the round Office button in the top left-hand corner of Excel.

If the application works fine in safe mode, try disabling the Add-Ins for the application and check the result : Once the file is opened check if you can see some of the text in Red. Open > Computer and browse to the affected file or open the file from the documents folder. To do this click on theįile tab in the top left hand corner of Excel and then click on Now try opening one of your affected Excel files from within Excel Safe. TypeĮxcel /safe (note there is a space between excelĪnd /) and click on OK, this will open Excel in the Safe Mode.

SELECT ALL LINES IN EXCEL AND CHANGE COLOR IN EXCEL 2016 WINDOWS

Hold the Windows key down and press the R key on your keyboard while you still have the Windows Key pressed. Please follow these steps to open Excel in the Safe Mode. We shall try opening Excel in Safe Mode and then open one of the affected Excel files being in the Excel Safe Mode. Shall also perform a diagnostic step in Excel to check if the issue resolves. xlsx format and then check if this works. Click onĪ new instance of the file will be opened, save this file in. What is the file type of the affected file (i.e.Check if it works when being opened directly from OneDrive? Please try uploading one of your affected Excel files to OneDrive (you can use a Microsoft Account to login to OneDrive on.Were these Excel files created in a previous version of Excel (i.e.Is this issue happening to all Excel files being opened on your computer (all files which had different text color in them) or is it happening only to this particular Excel file?.What are the contents of the Excel file? Do you have Macro / VBA coding included in the Excel file?.

In order to help us find a resolution for this issue we request the following information from your end: