Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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 added by Deleted user
Date Posted: 2015/01/03
Naseef Pacheeri
by 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

Deleted user
by Deleted user

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
by Firas Shahadi , Human Resources Director , SAUDI UNION

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

using  this format ;;;

Ahmed  Abdulrazig Shiekh Mohammed Abubaker
by 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