Functions that will move info to a different location in column
Bill
Rows and/or columns can be hidden but individual cells cannot be hidden as they
are part of the row and column.
You can hide the contents of a cell by Custom Formatting to ;;; (3 semi-colons)
You would also have to make sure that cell was locked and hidden and the sheet
protected so the contents would not show in the formula bar.
Or have the Formula bar disabled.
What are you trying to accomplish? There may be another way.
Gord Dibben MS Excel MVP
On Sun, 9 Dec 2007 14:12:00 -0800, Bill R
wrote:
Is there a way in Excel to temporaraly hide a column or temporarly move a
paragraph up within the column without affecting the column next to it or
above it?
|