Hide Excel cell contents make invisible
Office 2003 / 2007
With a simple cell formatting it is possible to hide the contents of cells in the display.
The content is only visible in the entry line when the cell is active, i.e. selected.
Excel 2003
Highlight the cell you want and choose Format> cells
In the dialog window Format cells now select in the tab numbers the category custom.
In the entry line Type now carry three semicolons ;;; and confirm with OK.
The content of the cell is no longer visible and does not appear in printouts.
Excel 2007
This only works under Office Excel 2007, but the paths have changed there.
Mark cell> select tab Start> expand standard> select "More"
You can of course also right-click> Format cells.
Mark cell> select tab Start> expand standard> select "More"
You can of course also right-click> Format cells.
| Transparency: | This article may contain affiliate links. These lead directly to the provider. If a purchase is made through this, we receive a commission. There are no additional costs for you! These links help us to refinance the operation of win-tipps-tweaks.de. |
This tip comes from www.win-tipps-tweaks.de
© Copyright Michael Hille
Warning:
Using Registry Editor or its tips incorrectly can cause serious system problems that may require you to reinstall your operating system. Tampering with the registry files and using the tips is at your own risk.