The first thing you will need to do is select the Page Layout tab, then click the box next to View under Gridlines. If the only thing you are trying to change in your Excel worksheet is the background color of the cells, then you may only need to select all the cells and change the fill color with the button in the Font group.īut what if you want to remove the grid lines, and cell borders so that the entire worksheet is white?įortunately, this is possible, although you will need to adjust a couple of other settings.
#HOW TO MAKE A BACKGROUND PICTURE IN EXCEL HOW TO#
How to Make the Entire Background White Using the Page Layout Tab in Excel Depending upon the other customizations you have made to your spreadsheet, this could be a preferable option.
You can also elect to use the No Fill option instead of the white color option. I have manually selected my cells in the image below, but you can also click the cell at the top-left corner of the spreadsheet to select the entire thing. Step 2: Select all of the cells containing the cell fill color that you want to set to white. Step 1: Open the spreadsheet that you want to edit. So continue reading below to learn how to change all of your cell fill colors to white in Excel 2010. Individually changing the cell color for all of the cells in a worksheet can be tedious, as it is much easier to set the fill color for multiple cells simultaneously. Switching everything back to a white cell background can serve as a kind of reset switch that will make your work with the spreadsheet a little simpler. How to Make All Cell Backgrounds White in Excel 2010 (Guide with Pictures) Our guide continues below with more information on making an Excel white background, including pictures of these steps. 5 Additional Sources How to Switch to White Cell Background in Excel 2010
0 kommentar(er)
