ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how to hide the characters in the cell (https://www.excelbanter.com/excel-programming/309970-how-hide-characters-cell.html)

oohss

how to hide the characters in the cell
 


Rob Bovey

how to hide the characters in the cell
 

Select the cell whose contents you want to hide, choose Format/Cells/Number
from the Excel menu, select the Custom entry from the listbox and enter
three semicolons (;;;) in the Type textbox. If this isn't what you're
looking for please provide a more detailed explanation.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"oohss" wrote in message
...




sebastienm

how to hide the characters in the cell
 
You could set its color to the same as the background color.

Regards,
Sebastien

"oohss" wrote:




All times are GMT +1. The time now is 12:24 AM.

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