Results 1 to 2 of 2

Thread: Locking or Fixing the Format of columns

  1. #1

    Locking or Fixing the Format of columns



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Dear all once more,

    This time I am writing to ask about cell formating:

    I would like, in my excel sheet, to have COLUMN C, D and E as text no matter whether I insert rows or I past cells form another doc etc..

    Is there liek a magic option to fix that, maybe under a password?

    Thank you so much for your help!

    A.

  2. #2
    Acolyte Sixthsense's Avatar
    Join Date
    Nov 2012
    Location
    India
    Posts
    26
    Articles
    0
    Make use of Worsheet Events to format those columns add/del to format as text.
    Use Paste Special Values/Text whenever pasting the data in those columns to keep the data as text.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •