IOU Hide SNN Field For Free

A Social Security number can be used to steal your identity (commonly called identity theft) to commit fraud, open new credit and bank accounts, get medical care/other benefits and obtain employment.

Employers are not permitted to truncate their own Employer Identification Numbers (EINs) on Forms W-2 furnished to employees. In addition, employers may not truncate SSNs on Forms W-2 that are filed with the Social Security Administration or any state or local tax authority.

Hide cell valuesSelect the cell or range of cells that contains values that you want to hide.On the Home tab, click the Dialog Box Launcher.In the Category box, click Custom.In the Type box, select the existing codes.Type ;;; (three semicolons).Click OK.

The option to Mask SSN, EFIN, PTIN on Client and Preparer Sets is available only in the Enhanced version of View mode. This feature, first introduced in Drake15, is activated under Setup > Options > Calculation & View/Print. In View, click the Enhanced button at the top.

Replacing the SSN with a mask on reportsOpen the report.Click the Columns tab.Under Columns, find the row for the Social Security Number and click on it.Find the section titled Format, and click the ellipses.Select Special as the Category.Select Social Security Number Mask as the Type.Click OK.

The use of a false Social Security Number or card is a felony,1 punishable by a fine, and up to five years in prison.

Select the cells that contain sensitive data you want to hide. Right-click to choose Format Cells option from the drop-down menu. On the Number tab, choose the Custom category and enter three semicolons (;;;) without the parentheses into the Type box. Click OK and now the data in your selected cells is hidden.

California law limits the public display of Social Security numbers.Requiring people to use an SSN to log onto a web site, unless a password is also used. The law applies to businesses, government, and other entities.

To hide the column that contains the full Social Security numbers, highlight the column, click Format, Column, Hide . Now the final step is to password protect the worksheet so the formula is both hidden and protected and the full Social Security numbers are hidden.

California law limits the public display of Social Security numbers. A California law bars organizations from publicly displaying SSNs 2. The law prohibits:The law applies to businesses, government, and other entities.