View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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?