Sharon Smith
Sharon Smith
  • Видео 197
  • Просмотров 8 009 125
Create a Reset Button in PDF Fillable Forms in Adobe Acrobat Pro - Reset Form Fields in PDF
How to create a reset form button in your PDF fillable form with Adobe Acrobat Pro. Add a button to your PDF form that users can click to clear all the form field data so they can quickly and easily reuse the form. This button is easy to program and format and is a helpful tool for forms that need to be reused often.
TIMESTAMPS ⏰
00:00 Create Reset a Form Button in PDF
00:14 Prepare a PDF Form
00:48 Add Action Button in PDF
01:04 Program PDF Button Properties
02:58 Test Reset Form Button in PDF
COURSE 🎒
Create Fillable Forms, Surveys & Questionnaires in Microsoft Word like a Pro: ruclips.net/p/PLb80efKTbWuNzAyHVMYrPOS7itBm5gWVs
WATCH NEXT 📺 Auto Populate Form Fields in Adobe PDF: ruclips.net/video...
Просмотров: 521

Видео

Create a Reset Form Button in Word - How to Reset Form Fields in Word Fillable Forms
Просмотров 81128 дней назад
How to reset form fields in a Word fillable form by adding an ActiveX command button that when a user clicks it, all of the form fields will be cleared out. Create a reset form button in Word that will work to clear both Legacy form fields and Content Control form fields. We will insert a command button on our form and then program the button with the VBA code below. This button will uncheck a ...
How to Create a Fillable Form in Word for Mac
Просмотров 1,7 тыс.Месяц назад
Learn how to create a fillable form in Word for Mac that has form fields including text boxes, drop-down lists, and checkboxes. See how to configure options in your form fields like setting a maximum character limit and forcing date formatting. In this video, we will build and format this form template from scratch with tables and section headers. But in case you already have your form template...
Add Shortcuts to Ribbon in Excel - Speed Up your Excel Workflow using the Quick Access Toolbar
Просмотров 5212 месяца назад
Speed up your Excel workflow by adding shortcuts to the Ribbon in Excel. Personalize the Quick Access Toolbar and arrange icons for the commands you use most frequently. Get to your favorite commands and shortcuts in fewer clicks by adding them to a custom group on any tab in Excel. In this example, we create a custom group on the Home tab next to the font area on the Ribbon where we place the ...
How to Create Sheet Tabs from a List - Then Make a Table of Contents with Links
Просмотров 1,2 тыс.2 месяца назад
How to automatically generate multiple sheet tabs in your Excel workbook based on an existing list of values. Create sheet tabs from your list then make a table of contents tab with hyperlinks to all the other tabs. Generate your tabs automatically without having to manually type them out and without VBA. Use this Pivot Table trick to save time and auto create multiple sheet tabs from your list...
Set a Maximum Character Length in Word Fillable Form - Set Max Character Limit
Просмотров 2,9 тыс.3 месяца назад
How to set a maximum character length on a text form field in Microsoft Word. Specify the character limit for a text form field in Word and stop form cells from expanding. This is something you can set up if you need to limit how much a user types into a form field and prevent the field from expanding your document formatting. By default, form fields accommodate an unlimited number of character...
How to Create a Fillable Form in Google Docs
Просмотров 13 тыс.3 месяца назад
Learn how to create fillable forms in Google Docs including form elements like text fields, dropdown list selections, and checkboxes. In this step-by-step tutorial we will create a fillable form in Google Docs from scratch. See how to insert and place a logo on your form, then how to use tables and borders to create fillable text boxes on your Google Doc. You'll see how to insert and set up dro...
Create Date Countdown in Excel - Countdown Timer of Days Remaining
Просмотров 5 тыс.3 месяца назад
How to create a Date Countdown in Excel to show you both the number of calendar days remaining until an event date, as well as how to calculate the number of working days left between now and that particular date. If you need to count "days left" or "days to go" to a particular date, you can achieve this in a way that will automatically update whenever you open the workbook by using the TODAY()...
Auto Populate Form Fields in Adobe PDFs - Repeating a Field in Other Parts of Your PDF
Просмотров 5 тыс.3 месяца назад
Three different ways to auto populate form fields by repeating or duplicating a form field throughout your PDF in Adobe Acrobat Pro. See how to create repeating fields that users fill in once, and the response populates in other parts of your PDF. This is useful when you capture a user's Name at the top of a form and then you want that person's name to populate in other places throughout the PD...
How to Create a Table of Contents with Hyperlinks in Excel
Просмотров 6 тыс.3 месяца назад
How to create a master sheet table of contents in Excel that has hyperlinks to all the sheet tabs in your workbook. Create a quick list of all existing sheets in your Excel workbook using Power Query. This loads a dynamic table that can be refreshed when new sheet tabs are added or deleted. Create a column for the hyperlinks to the sheet tabs. Using this hyperlink formula will fill down the tab...
Export PDF Form Field Data from Adobe Acrobat Pro to Excel - Adobe Acrobat Forms Data Collection
Просмотров 5 тыс.3 месяца назад
Take the data from your PDF forms in Adobe Acrobat Pro and export just the form field data into Excel so you can track and analyze results. You will learn how to export form field data to a text file and then get the data in Excel using Power Query, a process you can easily automate. Plus learn to use functionality in Adobe Acrobat Pro that allows you to merge PDF data files into a spreadsheet ...
Make Text See-Through in PowerPoint - Cool Text Transparency Technique
Просмотров 6 тыс.5 месяцев назад
Learn how to make text see-through in PowerPoint with this cool trick! Insert a photo with graphic text overlayed to show through. This is called masking and we can create this effect in PowerPoint using the Merge Shapes - Subtract option. 10X your PowerPoint skills by mastering text transparency techniques in this tutorial. Discover the art of creating captivating effects in PowerPoint using M...
How to Analyze Data Quickly in Excel - Using Excel's Built-in AI Features
Просмотров 1,3 тыс.5 месяцев назад
Use AI to Analyze Data in Excel quickly and easily with the built-in Microsoft Analyze Data button in Excel. Microsoft Excel's built-in Analyze Data feature allows you to quickly analyze complex datasets, create dynamic dashboards, and generate insightful charts without the hassle of manual data manipulation. Discover tips, tricks and real-world examples to customize your data and see trends, o...
How to Insert a Dynamic Pivot Chart in PowerPoint - Excel to PowerPoint Integration
Просмотров 3,2 тыс.6 месяцев назад
How to insert a dynamic pivot chart in PowerPoint that is linked to your pivot table data in Excel. Learn how to create dynamic charts linked to pivot table data in Excel, then automatically update your PowerPoint slides. In this video tutorial, we cover the process of inserting a dynamic chart, formatting it, and linking it to your PowerPoint presentation for real-time updates. Watch as we cre...
Simplifying Pivot Tables with Timelines and Slicers - Data Visualization Made Easy
Просмотров 7666 месяцев назад
How to insert slicers and timelines into your pivot tables in Excel to filter data. Learn how to enhance your Excel pivot tables by using slicers and timelines in this tutorial. You'll see how to use slicers for flexible data filtering and timelines to focus on specific date ranges. Discover the power of visualizing your data in different ways and optimizing your pivot table analysis. WATCH NEX...
How to Add a Calculated Field to a Pivot Table in Excel - Profit Margin PivotTable Formula Example
Просмотров 2,4 тыс.6 месяцев назад
How to Add a Calculated Field to a Pivot Table in Excel - Profit Margin PivotTable Formula Example
How to Create Pivot Tables in Excel to Analyze Data - Pivot Tables Made Easy for Beginners
Просмотров 2,2 тыс.6 месяцев назад
How to Create Pivot Tables in Excel to Analyze Data - Pivot Tables Made Easy for Beginners
How to Hide Confidential Data in Excel - Hiding Social Security Numbers & Credit Card Numbers
Просмотров 2,7 тыс.6 месяцев назад
How to Hide Confidential Data in Excel - Hiding Social Security Numbers & Credit Card Numbers
Automate Data Clean-up with Power Query - Auto Format & Combine Multiple Sheets - Save Time
Просмотров 2,4 тыс.6 месяцев назад
Automate Data Clean-up with Power Query - Auto Format & Combine Multiple Sheets - Save Time
How to Reset Calculated Field to Zero in Adobe Acrobat Pro PDF Form
Просмотров 1,3 тыс.7 месяцев назад
How to Reset Calculated Field to Zero in Adobe Acrobat Pro PDF Form
How to Pull Data into Excel Reports from Another Spreadsheet with VLOOKUP and XLOOKUP
Просмотров 5 тыс.7 месяцев назад
How to Pull Data into Excel Reports from Another Spreadsheet with VLOOKUP and XLOOKUP
Level Up Your PowerPoint Presentations with FREE M365 Premium Creative Content
Просмотров 8487 месяцев назад
Level Up Your PowerPoint Presentations with FREE M365 Premium Creative Content
How to Add a Photo to Header or Footer and Make it a Circle in Microsoft Word
Просмотров 3,1 тыс.7 месяцев назад
How to Add a Photo to Header or Footer and Make it a Circle in Microsoft Word
Automate Reports in Excel using Office Scripts - Time Saving Tip to Auto Format Reports
Просмотров 11 тыс.8 месяцев назад
Automate Reports in Excel using Office Scripts - Time Saving Tip to Auto Format Reports
How to Edit Subtitles on YouTube: Add Punctuation & Capitalize Captions Quicker with ChatGPT
Просмотров 8368 месяцев назад
How to Edit Subtitles on RUclips: Add Punctuation & Capitalize Captions Quicker with ChatGPT
How to Adjust Margins in Word - Custom Margins - Create A Letterhead in Word 4 of 4
Просмотров 1,2 тыс.8 месяцев назад
How to Adjust Margins in Word - Custom Margins - Create A Letterhead in Word 4 of 4
How to Add Graphics in the Header and Footer in Word - Creating Letterhead in Word 3 of 4
Просмотров 2,6 тыс.9 месяцев назад
How to Add Graphics in the Header and Footer in Word - Creating Letterhead in Word 3 of 4
How to Match Colors, Adjust Gradient Fill & Add Drop Shadows - Creating Letterhead in Word 2 of 4
Просмотров 5 тыс.9 месяцев назад
How to Match Colors, Adjust Gradient Fill & Add Drop Shadows - Creating Letterhead in Word 2 of 4
How to Insert, Align & Group Shapes, Icons & Text Boxes - Creating Letterhead in Word Lesson 1 of 4
Просмотров 4,1 тыс.9 месяцев назад
How to Insert, Align & Group Shapes, Icons & Text Boxes - Creating Letterhead in Word Lesson 1 of 4
How to Use Speech-to-Text Voice Typing in Word & Docs - Type Hands-Free for Faster Content Creation
Просмотров 29 тыс.9 месяцев назад
How to Use Speech-to-Text Voice Typing in Word & Docs - Type Hands-Free for Faster Content Creation

Комментарии

  • @ghostkick267
    @ghostkick267 14 часов назад

    How about that when I have minues hours from last month that are overtaken to the actuall month? Like I have -07:00:00 (-7 hours). I cant just type it into the cell, so the only way to make it, it is a format as number?

  • @georgesanmartin
    @georgesanmartin 17 часов назад

    Hello Sharon! I would like to create an Engineering Change Request form but i am barely getting familiar with Excel. Do you have a group of tutorials in Excel that I could purchase from you?

  • @mindfulmoments4956
    @mindfulmoments4956 19 часов назад

    Thanks, but was wondering if I could merge while keeping the formatting of the other document. For example, when I merged a table, the spacing (row spaces) seem to change!

  • @user-sh4oj3pz8s
    @user-sh4oj3pz8s 22 часа назад

    Thanks Ma'am. This is actually good!

  • @sherriehunt5953
    @sherriehunt5953 23 часа назад

    i have tried this several times and it does not work for me. Not sure what I may be doing wrong.

  • @Rizzstrainingorder_
    @Rizzstrainingorder_ День назад

    Thanks I needed this for a project

    • @SharonSmith
      @SharonSmith День назад

      Glad to help! Thanks for watching!

  • @jabarwocky
    @jabarwocky День назад

    Great video, easy to understand and follow like all your videos. The VBA works well with one email, but what do i do if i was sending to multiple email addresses or CC's.

  • @levimccoy4800
    @levimccoy4800 День назад

    This serious just saved me about an hour worth or work! Thank you.

    • @SharonSmith
      @SharonSmith День назад

      So glad to hear you found it helpful and it saved you time! Thanks for watching!

  • @user-cf4uo4zy4v
    @user-cf4uo4zy4v 2 дня назад

    Good work Madam sharon smith

  • @SamYehia-lh4li
    @SamYehia-lh4li 3 дня назад

    Easily explained Thank You

    • @SharonSmith
      @SharonSmith День назад

      Glad to help! Thanks for watching!

  • @Afghanivideo532
    @Afghanivideo532 4 дня назад

    Hi. How to record my voice with good quality using this software?

  • @TuveUpeguto
    @TuveUpeguto 4 дня назад

    Appreciate

  • @suemills2804
    @suemills2804 4 дня назад

    its not clear at all..... this is starting from an existing form. I'm starting from nothing.... where do I start from.

    • @SharonSmith
      @SharonSmith 4 дня назад

      Hello - the intro to the video gives an overview of the final form elements we will build from scratch. You can jump to timestamp 01:03 in this video to see how to get started from a blank document. You can find all timestamps for this lesson in the expanded video description so you can jump to the areas you are interested in. Good luck with your form!

  • @bhlueyt
    @bhlueyt 4 дня назад

    Can you make inventory system that can compute variance?

  • @workieddinka6334
    @workieddinka6334 4 дня назад

    Thank you, Sharon; it is so Clear and precise.

    • @SharonSmith
      @SharonSmith День назад

      Glad to help! Thanks for watching!

  • @tonnii_sia
    @tonnii_sia 5 дней назад

    Hi! how do i do this for multiple cells in one sheet?

  • @vladtheimpaler829
    @vladtheimpaler829 5 дней назад

    Hi Sharon Thans so much for a great video ! Im struggling a bit with the strike though option for discontinued items, ive followed your process to the exact formulas but it does not seem to apply the rule, once completing everything and selecting yes for one of the items, there is no strike though or grey blank out, is there maybe something im missing ? apologies for the trouble. Thanks so much again !!

  • @loriatkinson548
    @loriatkinson548 5 дней назад

    Thank you. This was very helpful. When I do it, the document and print is very small. Is there a way to bring them clearer, like your example?

  • @stephenkwan8134
    @stephenkwan8134 5 дней назад

    I have a spreadsheet that I'm struggling to calculate each employee's tenure based on another tab (worksheet), anyway I can find the best way to calculate their tenure based on information of another tab?

  • @brandonbentley222
    @brandonbentley222 5 дней назад

    Amazing! Thank you!

    • @SharonSmith
      @SharonSmith 5 дней назад

      So glad you liked it! Thanks for watching and subscribing to my Channel!

  • @JocelynShultz
    @JocelynShultz 5 дней назад

    Thank you for this tutorial! It was incredibly helpful! One quick questions: Is there a way when creating a drop down list to create a 'select all that apply' option?

  • @annabellemejias5837
    @annabellemejias5837 5 дней назад

    Your video has been a huge help with my work project. I would love take classes from you to further my knowledge in form making. Do you offer classes?

    • @SharonSmith
      @SharonSmith 5 дней назад

      I'm so glad to hear that! Yes, I actually have a RUclips Course on How to Create Fillable Forms in Microsoft Word: ruclips.net/p/PLb80efKTbWuNzAyHVMYrPOS7itBm5gWVs You are welcome to watch the intro video and then if interested, it is a paid course on RUclips and you can access a course workbook PDF and the sample form templates to go along with it. I'm glad you like my videos and that they have helped you out at work. I wish you the best! Thanks for watching my Channel!

    • @annabellemejias5837
      @annabellemejias5837 4 дня назад

      @@SharonSmith Do you have a price for the whole series or are you only selling them per course?

  • @safalparajuli
    @safalparajuli 5 дней назад

    Thank you so much Ms. Sharon! Greetings from Nepal.

    • @SharonSmith
      @SharonSmith 5 дней назад

      Greetings! Thanks so much for watching my videos!

  • @ayeshayousuf2931
    @ayeshayousuf2931 6 дней назад

    Can anyone guide how to add the multi-select dropdown in an entire row?

  • @CynE-ne4vw
    @CynE-ne4vw 6 дней назад

    Is there a way to make the header fillable with the rest of the restricted form? I was making a form and realized the header was not going to be able to be fillable when I restrict the rest of the fields. The need the header to be fillable as well. Thank you.

  • @TexBirdie
    @TexBirdie 6 дней назад

    This was a massive help! I haven't had to make a ToC in years & I SO appreciated your assistance. I hope you take heart that your content is still helping people 3 years later :)

    • @SharonSmith
      @SharonSmith День назад

      Thanks so much! I’m so glad you found my videos helpful! Thanks for watching and for taking time to leave a nice comment!

  • @BR-zt6vy
    @BR-zt6vy 6 дней назад

    Apparently I'm doing something wrong, it keeps showing the $D$10 is invalid. I did exactly like the video so I can't understand why it's doing this.

  • @laminnyabally778
    @laminnyabally778 6 дней назад

    How to auto upload the filled qord from to database, if you have many participants to interview

  • @nickaraiz1490
    @nickaraiz1490 7 дней назад

    Very useful! Thank you!

    • @SharonSmith
      @SharonSmith 6 дней назад

      Glad you found it helpful! Thanks for watching!

  • @dj-chakir
    @dj-chakir 7 дней назад

    Thanks and keep up the good work.

    • @SharonSmith
      @SharonSmith 6 дней назад

      Thanks so much! Glad you found it helpful. Thanks for watching!

  • @DonnaDoke
    @DonnaDoke 7 дней назад

    Multi-level Drop-Down List -- I cannot get this to work between the Location, Department, and Manager. I have tried copying and pasting the content above and I have also opened the completed form provided and copied directly from that file to mine and it still won't work. Is there an update or something that I am missing?????

    • @SharonSmith
      @SharonSmith 6 дней назад

      Hello! Thanks for purchasing my course. If you have copied the VBA code correctly, there might be a couple of issues to troubleshoot: 1. Form Field Names: Ensure that the names of your form fields match exactly with what's in the VBA code. Even a small difference in spacing or capitalization can cause issues. For example, "ddLocation1st" should match the name of your first drop-down list form field, and similarly for "ddDepartment2nd" and "ddManager3rd". Check the properties of each form field to confirm their names. 2. VBA Macro Security: Make sure that macros are enabled in your Word document. If macros are disabled, the VBA code won't run. You can enable macros by going to the "Developer" tab, clicking on "Macro Security," and selecting "Enable all macros" or "Enable macros for this session." 3. Check for Errors: In VBA, small syntax errors can cause the code not to run. Check for any red highlighted text or error messages in the VBA editor. Correct any errors and try running the code again. 4. Document Format: Ensure that your document format supports macros and form fields. Saving the document in a format like ".docm" (macro-enabled Word document) can help ensure that the macros are preserved. 5. Testing Step by Step: If you're still encountering issues, try testing each part of the code separately. For example, run PopulateddDepartment2nd() first and make sure it populates the second drop-down list correctly based on the selection in the first drop-down list. Then, test PopulateddManager3rd() to ensure it populates the third drop-down list based on the selection in the second drop-down list. By checking these points, hopefully you can troubleshoot and identify the issue preventing your dependent drop-down lists from working correctly. If you're still facing issues, please let me know. Thank you!

  • @TheAnalogParent
    @TheAnalogParent 7 дней назад

    didn't work - not sure what went wrong, don't see any other people with this issue

  • @SreelakshmiSrinivasan
    @SreelakshmiSrinivasan 7 дней назад

    It was really helpful. Thank you!!

    • @SharonSmith
      @SharonSmith 7 дней назад

      Glad to help! Thanks for watching!

  • @md.zahidulhaque7023
    @md.zahidulhaque7023 8 дней назад

    In my fillable pdf form, i have 2 text box. They are A and B. If i write anything in the box A then i want the box is B automatically filled by 100. Can you please write this code for me?

  • @AshleeBarrera
    @AshleeBarrera 8 дней назад

    Super helpful, thank you!!

    • @SharonSmith
      @SharonSmith 7 дней назад

      Glad you found it helpful! Thanks for watching!

  • @edidiongishola
    @edidiongishola 8 дней назад

    You are a life saver. Thank you for this.

    • @SharonSmith
      @SharonSmith 7 дней назад

      So glad you found it helpful! Thanks for watching!

  • @fatimatambago5524
    @fatimatambago5524 9 дней назад

    It helps me a lot

    • @SharonSmith
      @SharonSmith 7 дней назад

      Glad to help! Thanks for watching!

  • @DonnaDoke
    @DonnaDoke 9 дней назад

    I have watched several videos. I am trying to create this form and I just can't seem to finalize it. I can tab through the document (unprotected) from field to field; however, when I restrict editing to form fields, I can only go so far and then it stops and tells me that the area is protected. I have re-created this form from scratch at least 3 times. Can you help?????? I do not know what I am doing wrong.

  • @globalwellness2727
    @globalwellness2727 9 дней назад

    Thank you is there a way to share only from Mobile device with no laptop or PC?

  • @wesleyochiengonyori4964
    @wesleyochiengonyori4964 9 дней назад

    thanks so much for the lesson. However, is there a way you can group multiple text boxes inside a single text box?

  • @urdecisionisurs
    @urdecisionisurs 10 дней назад

    Hello, how do we protect the form so it is still fillable.

  • @shahidlibra3381
    @shahidlibra3381 10 дней назад

    hi, thanks for information. i want to ask you a question, as per part-time and full-time options. how we can make options with different tables in one collum? for example, i have different types of vehicles for service. and all models have different numbers. so how can i select different tables of numbers of vehicles at one collum as per selection of vehicle types?

  • @danield.8615
    @danield.8615 11 дней назад

    Is it possible to do this great tutorial with the new dropdown fields? I don't know how long MS will keep the legacy ones - just in case the function get's lost in a future update.

  • @ievade539
    @ievade539 11 дней назад

    How to do same thing in google sheets?

  • @VijayendranRaghavendran
    @VijayendranRaghavendran 11 дней назад

    Thank you very much for the video. Very useful.

    • @SharonSmith
      @SharonSmith 9 дней назад

      Glad you found it helpful! Thanks for watching!

  • @mikethomas3173
    @mikethomas3173 11 дней назад

    Simple and exactly what I needed. I was right there, and just couldn't get to the finish line. Thank you.

    • @SharonSmith
      @SharonSmith 9 дней назад

      Glad to help! Thanks for watching!

  • @dhamijay
    @dhamijay 11 дней назад

    Thank you so much, I was looking at ways to do this and I kept getting VB scripts which were not allowed by my company's Word settings!

    • @SharonSmith
      @SharonSmith 9 дней назад

      Glad you found this method helpful! Thanks for watching!

  • @AdamHaas
    @AdamHaas 11 дней назад

    I have a template that was made on a Windows machine, and when I open it on Mac, despite having the Developer tap enabled, the controls are invisible until I click on them.

  • @bradleywooten830
    @bradleywooten830 11 дней назад

    Perhaps it's my relative newness to digging into these sort of topics in Excel or my lack of understanding how Onedrive works, but can you say a little more as to why one has to pause OneDrive auto-synch and turn off auto save to perform this function? Thanks...

  • @stijnl5651
    @stijnl5651 11 дней назад

    How to make button "Share". It can be done with "Menu". But this works only with acrobat reader. Is there a javascript ?