When i opened a new spreadsheet, the normal looking page appeared. I have tried all obvious routes to remove it, fill colour, autoformat, sheet background option, any macros that might be causing it but it appears none of these are the case.

Download Valid Monthly Business Expense Template can save

Excel repair software repairs the excel file in these simple steps.

Excel worksheet gone grey. I have an excel spreadsheet that when opened you can only see a gray screen within excel. To resolve this problem, try the following options, as appropriate, in the given order. The fill colour won't change.

I am using excel 2010. I'm using excel 2003 and there i have inherited a spreadsheet where the background colour on the worksheets with content are grey for the entire worksheet. Start with opening the worksheet where cell lines are invisible.

Following the above methods should fix your problem, and if not, microsoft support is available at all hours to help you. After undergoing recent software updates to certain versions of microsoft excel in summer 2017, microsoft allotted track changes as a legacy feature. Verify print options to print cell shading in color.

One of excel’s features is the ability to ‘protect’ a worksheet, which can prevent it from being sorted, and even prevent it from being changed in any way. I highlight everything in the preview pane and copy. This got around the issue.

In the ribbon, click the file tab and click options in the left navigation pane. If this issue occurs in excel, and the excel worksheet that you are working on contains shared toolbars or was created in a different version of excel, it may be necessary to rename the file that contains the shared toolbar settings. Start run excel /unregserver excel /regserver neither of these has solved my problem but one of these may help someone else.

Select the corrupt excel file. This problem may occur if the ignore other applications that use dynamic data exchange (dde) check box in excel options is selected. When i opened a excel spreadsheet, no data appeared.just a blank grey screen!

Now whenever i open my excel all the work sheets are in dark grey! I tried opening other spreadsheets and got the same result. If the file location is not available, then find the excel file by clicking on search option.

Why is my excel file opening blank? * excel having a file open already allows next file opened to show up as expected (cannot just have excel on, must be in a file, even a new blank file) * the sheet is open, hovering in the right areas will show comments, clicking where a cell with a formula should be results in seeing the formula or data in the formula bar While you are working at a worksheet, you may want to only display the working area in the worksheet, which means to grey out all unused area in some times as below screenshot shown.

By default excel assigns a greyish shade to the gridlines. If this is the cause of the problem, you should be able to resolve it by unprotecting the worksheet. On the page layout tab, in the page setup group, click the page setup dialog box launcher.

To facilitate ease of use, you can add it on to your quick access toolbar to track every file. I have never done this before! Follow the steps to do so:

Once you are in microsoft excel, click on the file tab in top menu bar > scroll down and click on options. Then in the unhide dialog box > click sheet you desire to unhide; In older versions of excel, click on file icon > excel options button.

Then, paste into a blank 2010 workbook. However, i could open the spreadsheet using internet explorer. Click start > all programs> microsoft office.

Another scenario you may encounter is shown in figure 3. Doesn't explain what's wrong with the source file. To do this, follow these steps:

Microsoft excel is a great, powerful tool and has a variety of practical uses. Does not hamper the worksheet properties and cell formatting; Select the cells that are missing the gridlines, or hit control + a to select the entire worksheet.

The show sheet tabs setting determines whether or not worksheet tabs are visible. Worksheet protection is covered in depth in our expert skills course. Then, under the home tab in the font group change the color of the cells by clicking on the little arrow to the right of the can of spilling paint and choosing no fill.

How to quickly grey out all unused area in excel? I haven't seen this happen before. Changed name of original (the one having issues

> we see the cells on the top one guess. Launch and open the software. Suppose you want to see gridlines in the entire worksheet or workbook, but they are just turned off.

Alternatively, you can add the excel ribbon via the creation of a new group and add it to this new group. I cannot turn it back to white by changing the background. On a white background, white gridlines are bound to hide themselves.

If print options are set to black and white or draft quality — either on purpose, or because the workbook contains large or complex worksheets and charts that caused draft mode to be turned on automatically — cell shading cannot print in color. Ensure that the color has not been changed to white. In this article, i will tell you two methods to quickly hide the unused area cells.

In many cases, the excel sheet disappeared by itself. However, some problems can be difficult to fix, like getting rid of dotted lines. Due to changes with how windows are containerized in excel 2013 and later, you no longer protect windows in those versions when protecting a workbook.

Excel's freeze panes command also becomes disabled when the workbook is protected in excel 2010 and earlier, as illustrated in figure 2. On the file menu, click open. Hi, i have a worksheet in excel 2003 and the entire worksheet when i opened it today has turned dark gray.

So to get the missing sheet tab back you must use the unhide worksheet of excel. Same results on 2 computers and networks. Supports the latest as well as earlier version;

Any ideas what might have happened here? There is no white at all, no lines and no grids. Excel fill and font color disappearing act by josherid nov 10, 2004 10:04am pst i formatted a spreadsheet with fill colors and font colors in various places.

Excel opening blank is a very irritating issue usually faced by the excel users while trying to open their excel files. Also tried excel 2007, same results. In excel 2010 and earlier, it's relatively easy to inadvertently arrange a spreadsheet window so that the worksheet tabs aren't present on the screen, even if the show sheet tabs option is enabled.