Excel Formula Cell Protection - Guard Your Spreadsheets - Episode 2032

Поделиться
HTML-код
  • Опубликовано: 21 авг 2024

Комментарии • 14

  • @gracelemyre7572
    @gracelemyre7572 Год назад +1

    I've watched a few of these today and just couldn't grasp it until I watched your video. I now feel like a pro. Thank you so much for making it very clear. I appreciate this video.

  • @murtadhamurtadha5747
    @murtadhamurtadha5747 3 года назад

    Thank you very much it helped me a lot

  • @tanyamccomas1110
    @tanyamccomas1110 2 года назад +1

    I want to add data but not change formula for updating

  • @at-excel
    @at-excel 8 лет назад

    Hey! I've got the smallest sales in your table. That's unfair ;-)
    Thanks for sharing in your amazing manner.

    • @at-excel
      @at-excel 8 лет назад

      Does ZUFALLSBEREICH sounds evil, too? I remember SCHLIESSEN ;-)

  • @rksudera
    @rksudera 6 лет назад +1

    Hi Bill
    I am in construction industry
    Need DPR format in which "the data entered today would automatically move to yesterday or the corresponding date" on next date...
    Regards

  • @rameshganesh123
    @rameshganesh123 5 лет назад

    What ever in videos all fine but we lock the formula but we cannot bold or font changes and menus are freeze when we protect so there is any other idea

  • @rameshganesh123
    @rameshganesh123 5 лет назад

    if we see the result unlocked cell we cannot bold it color's etc.. all menus are hide or freezed so we need formula only need to clock other other cell we need to be normal

  • @bricc322
    @bricc322 7 лет назад

    Hi, Bill. Thank you for all the work that you do and all that you share. If I want to share an excel file in which one of the sheets has confidential info and is hidden, how would you suggest to do that, given the fact that it is so easy to unprotected an excel file?

    • @bricc322
      @bricc322 7 лет назад

      That would work in some situations, but not if you still want the receiver to interact with the file. I am thinking on a situation where a client could customize a product to order and the prices for each part are on the hidden sheet.

    • @bricc322
      @bricc322 7 лет назад

      Hi, Bill. I am probably asking for the impossible, but I created a request at Excel User Voice. If you think this should have Excel's team attention, please see here: excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/18949810-google-drive
      Thank you.

    • @bricc322
      @bricc322 7 лет назад

      Bill Jelen, Thank you!

  • @rameshganesh123
    @rameshganesh123 5 лет назад

    English little bit poor sorry for that as per your video also its hides have you seen it.