Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

How to hide certain columns when sharing a spreadsheet?

Ok, I'm syncing an excel spreadsheet with some other people (through windows live sync). But I only want them to see certain columns. Can I hide certain columns so they can't see it?

2 Answers

Relevance
  • Marvin
    Lv 7
    1 decade ago
    Favorite Answer

    In excel you just right-click the column header and select "hide".

    You'll need to lock and password protect it also to stop people just "unhiding" it.

  • 1 decade ago

    if it was me, I would cut and paste those columns from the "live" spreadsheet, and store them in a "local" spreadsheet that can only be accessed by yourself - then if needed, you can paste all the columns back onto one page for editing off line.

Still have questions? Get your answers by asking now.