Excel Worksheet Gone Grey

* 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 This got around the issue.

Balancesheet Excel Statement template, Inventory (source:pinterest.com)

The fill colour won't change.

Excel worksheet gone grey. Select the cells that are missing the gridlines, or hit control + a to select the entire worksheet. How to quickly grey out all unused area in excel? Now whenever i open my excel all the work sheets are in dark grey!

> we see the cells on the top one guess. Supports the latest as well as earlier version; Verify print options to print cell shading in color.

To facilitate ease of use, you can add it on to your quick access toolbar to track every file. If this is the cause of the problem, you should be able to resolve it by unprotecting the worksheet. 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 page layout tab, in the page setup group, click the page setup dialog box launcher. So to get the missing sheet tab back you must use the unhide worksheet of excel. If the file location is not available, then find the excel file by clicking on search option.

Then, paste into a blank 2010 workbook. Also tried excel 2007, same results. I am using excel 2010.

On a white background, white gridlines are bound to hide themselves. 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. There is no white at all, no lines and no grids.

When i opened a new spreadsheet, the normal looking page appeared. Following the above methods should fix your problem, and if not, microsoft support is available at all hours to help you. This problem may occur if the ignore other applications that use dynamic data exchange (dde) check box in excel options is selected.

To resolve this problem, try the following options, as appropriate, in the given order. 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. 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.

Hi, i have a worksheet in excel 2003 and the entire worksheet when i opened it today has turned dark gray. 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. Excel repair software repairs the excel file in these simple steps.

I cannot turn it back to white by changing the background. Why is my excel file opening blank? In this article, i will tell you two methods to quickly hide the unused area cells.

Excel opening blank is a very irritating issue usually faced by the excel users while trying to open their excel files. I tried opening other spreadsheets and got the same result. Suppose you want to see gridlines in the entire worksheet or workbook, but they are just turned off.

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. On the file menu, click open. Launch and open the software.

Any ideas what might have happened here? I have never done this before! In many cases, the excel sheet disappeared by itself.

Start run excel /unregserver excel /regserver neither of these has solved my problem but one of these may help someone else. Does not hamper the worksheet properties and cell formatting; To do this, follow these steps:

In the ribbon, click the file tab and click options in the left navigation pane. Select the corrupt excel file. Once you are in microsoft excel, click on the file tab in top menu bar > scroll down and click on options.

The show sheet tabs setting determines whether or not worksheet tabs are visible. Follow the steps to do so: Click start > all programs> microsoft office.

Microsoft excel is a great, powerful tool and has a variety of practical uses. 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. Changed name of original (the one having issues

By default excel assigns a greyish shade to the gridlines. 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. Alternatively, you can add the excel ribbon via the creation of a new group and add it to this new group.

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. After undergoing recent software updates to certain versions of microsoft excel in summer 2017, microsoft allotted track changes as a legacy feature. Ensure that the color has not been changed to white.

Worksheet protection is covered in depth in our expert skills course. Then in the unhide dialog box > click sheet you desire to unhide; 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.

Another scenario you may encounter is shown in figure 3. In older versions of excel, click on file icon > excel options button. Same results on 2 computers and networks.

Doesn't explain what's wrong with the source file. I haven't seen this happen before. Start with opening the worksheet where cell lines are invisible.

I highlight everything in the preview pane and copy. When i opened a excel spreadsheet, no data appeared.just a blank grey screen! I have an excel spreadsheet that when opened you can only see a gray screen within excel.

However, some problems can be difficult to fix, like getting rid of dotted lines. However, i could open the spreadsheet using internet explorer. 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.

More Creative Ideas Featured from The Sunday Showcase (source:pinterest.com)