+ Reply to Thread
Results 1 to 4 of 4

Remove Select Data in Win7 Excel Starter

  1. #1
    Registered User
    Join Date
    04-10-2012
    Location
    Petaluma
    MS-Off Ver
    Win7 Excel Starter
    Posts
    8

    Question Remove Select Data in Win7 Excel Starter

    I think this is a simple question, but apparently I don't know how to phrase it to the search engines to generate relevant results. I hope that someone here can help or redirect me to the answer.

    I have a spreadsheet that was created in Excel Starter on Win7. We would like to share a copy of this spreadsheet with other people, but there are a couple of columns that should be removed before we do that. We want to clear the content of columns J and K without effecting the content in the rest of the spreadsheet. Everything I have tried so far results in all of the data disappearing when J and K are cleared. Please advise.

    Thanks!
    Jordan

  2. #2
    Registered User
    Join Date
    04-01-2012
    Location
    North West, South Africa
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: Remove Select Data in Win7 Excel Starter

    Clearly these two columns are referenced by the other columns? Have you tried hiding these two columns instead?

  3. #3
    Registered User
    Join Date
    04-10-2012
    Location
    Petaluma
    MS-Off Ver
    Win7 Excel Starter
    Posts
    8

    Re: Remove Select Data in Win7 Excel Starter

    Sorry, I'm still a bit of a novice when it comes to Excel. I didn't create this spreadsheet but my guess is that, yes, they are referenced. Per your advise I have hidden the columns. Do you think this is sufficiently secure when sharing the file? If I send this file to our customers, will it remain hidden and undiscoverable?

    Thanks very much for your input, Kassie.

    Jordan

  4. #4
    Registered User
    Join Date
    04-10-2012
    Location
    Petaluma
    MS-Off Ver
    Win7 Excel Starter
    Posts
    8

    Re: Remove Select Data in Win7 Excel Starter

    I'd be happy to hear anyone's insight on this. At my business we sell Wholesale as well as Retail, and there is information in the spreadsheet which is intended for certain customer groups only. Is "hiding" the information the best solution? Will it remain hidden if I send copies to our customers?

    Thanks again,
    Jordan

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1