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.
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
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
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?
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.
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.
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