+ Reply to Thread
Results 1 to 3 of 3

Hiding the numbers in a column of cells without loosing their values.

  1. 11-04-2020, 08:51 AM #1
    j0SAND
    j0SAND is offline
    Registered User
    Join Date
    11-03-2020
    Location
    germany
    MS-Off Ver
    365
    Posts
    46

    Hiding the numbers in a column of cells without loosing their values.

    I have a column of numbers and want to hide them from view without loosing their value.
    Reply With QuoteRegister To Reply
  2. 11-04-2020, 09:01 AM #2
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Hiding the numbers in a column of cells without loosing their values.

    Format them the same colour as the background or hide the column.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.
    Reply With QuoteRegister To Reply
  3. 11-04-2020, 02:48 PM #3
    j0SAND
    j0SAND is offline
    Registered User
    Join Date
    11-03-2020
    Location
    germany
    MS-Off Ver
    365
    Posts
    46

    Re: Hiding the numbers in a column of cells without loosing their values.

    Thx and sorry for my etiquette.

    This blocks them out of view but does it reduce the spreadsheet size ?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Hiding and Un-hiding Cells in a sheet based on Values in Another
    By aheisler in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-15-2019, 11:44 AM
  2. MAcro to copy the contents from MErged Cells into one cell without loosing the values
    By raj13 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-20-2014, 07:19 PM
  3. Sum up numbers from A1 to B1 and delete the number in A1 without loosing numbers in B1?
    By redtie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-05-2012, 08:23 AM
  4. Sum up numbers from A1 to B1 and delete the number in A1 without loosing numbers in B1?
    By redtie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-05-2012, 06:38 AM
  5. Un-Hiding and Hiding Columns based on Drop-Down Values in a Column.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 10-30-2011, 09:24 AM
  6. Un-Hiding and Hiding Columns based on Drop-Down Values in a Column.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2011, 06:49 AM
  7. Only two values (numbers) for 150 random cells in a column of 300 cells
    By andrugrasu in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-20-2011, 03:17 AM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1