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.
Advertising
| Transparency: | This article may contain affiliate links. These will take you directly to the provider. If you make a purchase through one of these links, we will receive a commission at no extra cost to 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
