ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excel book (https://www.excelbanter.com/excel-discussion-misc-queries/198885-excel-book.html)

Eva

excel book
 
how do we change the backgroung color of the excel book?
Please help

Kevin B

excel book
 
Group all the sheets in the workbook, click the button to the left of the
column letter A and above the row number 1 to select all the cells in the
selected worksheets.

Click FORMAT in the menu and select CELLS.

Click the PATTERNS tab and select CELL SHADING flavor of your choice.
--
Kevin Backmann


"eva" wrote:

how do we change the backgroung color of the excel book?
Please help


Kevin B

excel book
 
BTW:

Right click on any sheet tab and click SELECT ALL SHEETS to group all the
worksheets.

When finished with the cell formatting right click on any sheet tab and
select UNGROUP SHEETS
--
Kevin Backmann


"Kevin B" wrote:

Group all the sheets in the workbook, click the button to the left of the
column letter A and above the row number 1 to select all the cells in the
selected worksheets.

Click FORMAT in the menu and select CELLS.

Click the PATTERNS tab and select CELL SHADING flavor of your choice.
--
Kevin Backmann


"eva" wrote:

how do we change the backgroung color of the excel book?
Please help


Duke Carey

excel book
 
Probably better to change the format of the Normal style to include a fill
color. Seem to remember this uses lots less memory and keeps workbook sizes
smaller

"Kevin B" wrote:

Group all the sheets in the workbook, click the button to the left of the
column letter A and above the row number 1 to select all the cells in the
selected worksheets.

Click FORMAT in the menu and select CELLS.

Click the PATTERNS tab and select CELL SHADING flavor of your choice.
--
Kevin Backmann


"eva" wrote:

how do we change the backgroung color of the excel book?
Please help



All times are GMT +1. The time now is 11:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com