ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Ghosting Out Cells (https://www.excelbanter.com/excel-discussion-misc-queries/27020-ghosting-out-cells.html)

PW11111

Ghosting Out Cells
 

I have a spreadsheet which will be replicated and given to a number of
different people to fill in different parts. I would like to Ghost out, or
make semi-transparent, parts of the spreadsheet (depending on which part the
individual needs to fill in). I know you can shade cells....but is there
anyway to alter the transparency of the colours/gridlines/fonts....

Any help would be great.

(Im using Excel 2000)

Cheers,

Phil

PW11111


I've figured this out..

If you draw a box over the area you want to make transparent... then format
the box and make it semi-transparent.

"PW11111" wrote:


I have a spreadsheet which will be replicated and given to a number of
different people to fill in different parts. I would like to Ghost out, or
make semi-transparent, parts of the spreadsheet (depending on which part the
individual needs to fill in). I know you can shade cells....but is there
anyway to alter the transparency of the colours/gridlines/fonts....

Any help would be great.

(Im using Excel 2000)

Cheers,

Phil



All times are GMT +1. The time now is 04:22 PM.

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