Thanks for clearly displaying how to create a signature on the Word App. The app on iPhone is finicky but at least it saves having to use photoshop or specialist applications to create an electronic signature. Also another good tip to save people from using or paying for specialist scanning software on iPhone is to use the Notes app to scan documents.
Here is another video that shows a different way to create an electronic signature in case this works for you: ruclips.net/video/qKQT5HW4kxY/видео.html Thanks for watching!
Hi Stephanie! Unfortunately Word does not currently have a multi-select drop-down form field. The easiest thing would be to either create the form in Excel or in MS Forms if you are able. Thanks for watching!
Hi Sharon . Thank you for your informative videos. I have a special case in excel which I couldn’t find any solution for it and hope you can help me with. If I have various numbers in column B, and I need these numbers to be (increased/decreased): - By 0.5 either to make it 20.5 or 19.5 - Or by 1 to make it either 21 or 19 - Or 2 to make it 22 or 18 …etc. The change should be based on two conditions, a selected text from a drop-down list in the next cell in column C in addition to a number I type in the cell next to them in column D, for example: - The first case scenario is: When I type the number 20 in cell B2 and then I choose the text “increase” from a drop-down list in cell C2 and then I type 0.5 in the cell D2, I want this “increase” to be reflected on B2 and make it 20.5 - The second case scenario: When I type the number 15 in cell B3 and then I choose the text “decrease” from a drop-down list in cell C3 and then I type any number like 1, 2 or 3 in the cell D3, I want this “decrease” to be reflected on B3 and make it 14, 13 0r 12 - The third case scenario: When I type number 10 in cell B4 and then I don’t choose any text from a drop-down list in cell C4 and leave it blank with cell D4, I don’t want any change to be reflected on B4 and leave it 10 as it is. I hope you can find time to answer this very soon. Thanks again.
Hi Waleed, will this work for you: Column A Column B Column C Column D Input # Increase or Decrease by Amount Result 20 Increase .5 Try this IF statement in the "Result" column: =IF(B2="Increase",(A2+C2), IF(B2="Decrease", (A2-C2),A2)) This says if "Increase" is selected in B, add the number in A and amount in C, but if "Decrease" is selected in B, subtract the number in A and amount in C, and if nothing is entered in B, return the number value in A. Hope this helps! Thanks for watching!
Hi Sharon, I ve got a Question. I want to know how to create a automatic expandable and fillable table, where we can jump to the next row. So its like we have started with one fillable row and, we fill it, then, we can get to the next row. The table is initially only one row, but the table is expandable, as we go to the next row....
Thanks for clearly displaying how to create a signature on the Word App. The app on iPhone is finicky but at least it saves having to use photoshop or specialist applications to create an electronic signature.
Also another good tip to save people from using or paying for specialist scanning software on iPhone is to use the Notes app to scan documents.
Great tip! Thanks for watching!
Seems it doesnt work with Microsoft 2007
Here is another video that shows a different way to create an electronic signature in case this works for you: ruclips.net/video/qKQT5HW4kxY/видео.html Thanks for watching!
Hi. I was wondering if a drop down list that allows the end user to select more than one choice is possible in WORD?
Hi Stephanie! Unfortunately Word does not currently have a multi-select drop-down form field. The easiest thing would be to either create the form in Excel or in MS Forms if you are able. Thanks for watching!
Hi Sharon . Thank you for your informative videos. I have a special case in excel which I couldn’t find any solution for it and hope you can help me with. If I have various numbers in column B, and I need these numbers to be (increased/decreased):
- By 0.5 either to make it 20.5 or 19.5
- Or by 1 to make it either 21 or 19
- Or 2 to make it 22 or 18 …etc.
The change should be based on two conditions, a selected text from a drop-down list in the next cell in column C in addition to a number I type in the cell next to them in column D, for example:
- The first case scenario is: When I type the number 20 in cell B2 and then I choose the text “increase” from a drop-down list in cell C2 and then I type 0.5 in the cell D2, I want this “increase” to be reflected on B2 and make it 20.5
- The second case scenario: When I type the number 15 in cell B3 and then I choose the text “decrease” from a drop-down list in cell C3 and then I type any number like 1, 2 or 3 in the cell D3, I want this “decrease” to be reflected on B3 and make it 14, 13 0r 12
- The third case scenario: When I type number 10 in cell B4 and then I don’t choose any text from a drop-down list in cell C4 and leave it blank with cell D4, I don’t want any change to be reflected on B4 and leave it 10 as it is.
I hope you can find time to answer this very soon. Thanks again.
Hi Waleed, will this work for you:
Column A Column B Column C Column D
Input # Increase or Decrease by Amount Result
20 Increase .5
Try this IF statement in the "Result" column:
=IF(B2="Increase",(A2+C2), IF(B2="Decrease", (A2-C2),A2))
This says if "Increase" is selected in B, add the number in A and amount in C, but if "Decrease" is selected in B, subtract the number in A and amount in C, and if nothing is entered in B, return the number value in A.
Hope this helps! Thanks for watching!
@@SharonSmith Thank you very much for your reply.
These are pretty good tips and tricks for people who cannot afford Photoshop or even for non-tech savvy people. Great video!
Thank you so much for your nice feedback! I'm glad you found my videos helpful. Thanks for watching!
Thank you Dear. I love your videos. God bless you.
Thank you so much! I'm so glad you love my videos! Thanks for watching my Channel!
Excellent and comprehensive👌🌺
Thank you! Glad you found it helpful! Thanks for watching!
Hi Sharon,
I ve got a Question.
I want to know how to create a automatic expandable and fillable table, where we can jump to the next row.
So its like we have started with one fillable row and, we fill it, then, we can get to the next row. The table is initially only one row, but the table is expandable, as we go to the next row....
Really helpful thanks 😁
Glad you found it helpful! Thanks for watching!
Not very good for Android tablet
Awesome
Glad to help - thanks for watching!
i didnt even have draw
Thanks so much!
Glad to help! Thanks for watching!