Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

In Excel how would you hide the text in a column without the hide function or making text "white"?

<p>By utilising the format cell function, custom, type " ; " character.</p> <p>Format a column or an individual cell, or block of cells.</p> <p>This will have an effect of the "Bermuda Triangle".  The text, formulas, numbers remain in the cell, however nothing will be printed in this area of the worksheet if printed.</p> <p> </p>

user-image
Question ajoutée par Utilisateur supprimé
Date de publication: 2015/01/03
Naseef Pacheeri
par Naseef Pacheeri , Sales Support , Savola Group

1. Select the cell you want to hide

2. Hit CTRL+1 (or open format cells dialog from right click)

3. Go to Number tab, select “custom” as the type

4. Type the formatting code as “;;;” without double quotes

5. Press OK and your cell contents are invisible now

1- Select Text and go to Format CELL . Just select a custom format and enter a space. The dialog looks like thisenter image description here

2-2nd option is CONDITIONAL formatting

Firas Shahadi
par Firas Shahadi , Training And Development Director , Muhayal Assir National Hospital

I like your way. Asking then answering ...:)

using  this format ;;;

Ahmed  Abdulrazig Shiekh Mohammed Abubaker
par Ahmed Abdulrazig Shiekh Mohammed Abubaker , رئيس قسم حسابات الموردين , مؤسسة مخازن العناية للتجارة

You can hide the text by using cutting function by (CTRL+X). Then you can unhide it by using paste function by (CTRL +V)..

More Questions Like This

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?