Make Excel Sheet Background Blank

Make excel hide gridlines only in specific cells.

Make excel sheet background blank. Check for hidden sheets. For excel 2007 2010 and 2013. One way that people like to simplify data organization is by using cell fill colors to indicate that certain types of data are related or similar. It will not be active but you can use the snipping tool and make a picture of the spread sheet and use the picture as background using settings personalization background.

I did it like sub main range a1 az1000 borders linestyle xllinestylenone range a1 az1000 interior pattern xlpatternsolid range a1 az1000 interior patterncolor rgb 255 255 255 end sub. I have a requirement to make the background of a excal sheet white. An excel sheet may inadvertently have been saved as a hidden document. It should not show any grid of lines.

As you can see in the screenshot above applying the white background will give an effect of hidden gridlines in your worksheet. In case you want excel to hide gridlines only in a certain block of cells you can use the white cells background or apply white borders. In the task tray right click excel and then select your spreadsheet. A cell s color will change automatically based on the cell s value.

To color the cell background. First of all open the spreadsheet where you have already added an image as background. Click the down arrow at the side of the fill color button which is located on the home tab of the excel ribbon or on the formatting toolbar in excel 2003. I would like to have a worksheet where i could have a title a logo some command buttons for userforms and possibly reports and also be able to change the color and look of the background.

Select the cells that you want to hide the gridlines on. This method can be used to hide the gridlines in a chosen range of cells or for an entire worksheet. And in the pop ou t insert dialog box select the sheet template that you are created under general tab see screenshot. Customizing an excel spreadsheet can make it easier to read.

Next navigate to format sheet delete background. Use excel formula to change background color of special cells. In the top right corner of the excel spreadsheet select the minimize button. First open the spreadsheet where you have already added an image as background.

How to make this in vba. This will delete the image from the background. Or double click the excel icon after your sheet is maximized your data may appear. This is especially true of large spreadsheets that contain rows and columns of very similar data.

I have seen worksheets where all of the lines are removed and it almost has the look of a blank piece of paper.