Block Out Spreadsheet Text For Free

Hide or Unhide worksheetsRight-click the sheet tab you want to hide, or any visible sheet if you want to unhide sheets.On the menu that appears, do one of the following: To hide the sheet, select Hide. To unhide hidden sheets, select them in the Unhide dialog that appears, and then select OK.

Redacting Excel documentsSelect a cell or cells.Press Delete to remove the cell content.optional Change the cell background to Black for that Redacted look. To do that individually choose the cells then Home Cells Format Format Cells Fill and choose Black.Sep 15, 2015

1) Hiding an entire column or row which can then be un-hidden at a later stage should a user require to edit the data. To hide a column, right click the column header and choose Hide. Hiding columns and rows can simplify a worksheet or workbook by removing the detail and showing only the important information.

The first method involves simply hiding the columns or rows that contain the data you want to hide.Select the columns or rows that contain the data to hide:Right-click over the column/row headings and click Hide:The result is that the selected columns no longer appear in the spreadsheet:

Select the cell where you want to create a mask input (here, cell B2), and in the toolbar, go to Format > Number > More Formats > Custom number format. 2. In the number format box, enter #:00 and click Apply. The result is the same as in Excel.

Hide columnsSelect one or more columns, and then press Ctrl to select additional columns that aren't adjacent.Right-click the selected columns, and then select Hide.

If you are asking how to restrict a cell to a maximum number of characters, then the answer is to use Data > Data Validation and choose "Text Length" from the Allow field.