Returning to 'no pattern'
I am trying to setup a new worksheet and I am experimenting with different patterns in cells, but when I select a pattern from the dropdown box on the Patterns tab of the Format Cells dialog box I can't figure out how to revert back to 'no pattern'. The 'Undo format cell' works, but if I have made other changes that I want to keep that doesn't serve the purpose. Thanks for the help, Dave -- dvh ------------------------------------------------------------------------ dvh's Profile: http://www.excelforum.com/member.php...o&userid=36302 View this thread: http://www.excelforum.com/showthread...hreadid=560807 |
Returning to 'no pattern'
Just above the colour examples is a field called No color. Click on this,
and you have no pattern in the cell, or the selection of cells? If you selected a fill pattern, and you want to revert to no pattern, click on Pattern, and then select the top leftmost block, which is an unformatted blank, to revert to No Pattern. "dvh" wrote: I am trying to setup a new worksheet and I am experimenting with different patterns in cells, but when I select a pattern from the dropdown box on the Patterns tab of the Format Cells dialog box I can't figure out how to revert back to 'no pattern'. The 'Undo format cell' works, but if I have made other changes that I want to keep that doesn't serve the purpose. Thanks for the help, Dave -- dvh ------------------------------------------------------------------------ dvh's Profile: http://www.excelforum.com/member.php...o&userid=36302 View this thread: http://www.excelforum.com/showthread...hreadid=560807 |
All times are GMT +1. The time now is 10:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com