+ Reply to Thread
Results 1 to 2 of 2

Applying Data Validation to all sheets

  1. #1
    Registered User
    Join Date
    03-22-2022
    Location
    Malaysia
    MS-Off Ver
    Microsoft Office Home & Business 2021
    Posts
    4

    Applying Data Validation to all sheets

    I have multiple sheets (~20 sheets) as shown in picture 1. Previously I fill the details in the table manually one by one. But I realize I could save a lot of time by doing data validation. Only problem is I already filled half of the sheet numbers, and have half more to go. Picture 2 is the data validation source that I created. Is there any way to apply the data validation only to the selected cells all at once? because all the sheets are pretty much the same table, just with different sheet name.
    Attached Images Attached Images

  2. #2
    Valued Forum Contributor
    Join Date
    01-07-2022
    Location
    Europe
    MS-Off Ver
    Office 365
    Posts
    473

    Re: Applying Data Validation to all sheets

    if the table is in the same cell locations on each sheet:

    1) on your sheet that is already formatted, click the triangle on the top left hand corner of the sheet (between 'A' and '1') to highlight the whole sheet
    2) click Home > Format Painter (icon of a paintbrush). Double click to keep it enabled (press Esc to cancel)
    3) Open on one of the sheets you want to apply the formatting to, and click the triangle on top left hand corner

    Note you can apply to multiple sheets at the same time by holding down Control and clicking the tabs for multiple sheets.
    <<< If you have valued anyone's contributions in this thread, please click * to thank them for their efforts

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Applying a multiplier based on data validation selection
    By Rhuumz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-26-2019, 09:24 PM
  2. [SOLVED] Issues with applying IF function to Data Validation List
    By g.costapinto in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-18-2019, 08:33 AM
  3. [SOLVED] Applying a doubleclick macro to a cell with data validation
    By jeffreybrown in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2019, 06:29 PM
  4. [SOLVED] Applying filtering on data validation selection
    By Franki81 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-05-2016, 07:09 AM
  5. [SOLVED] Applying Data Validation to Allow Only Formulas
    By loverfellow in forum Excel General
    Replies: 5
    Last Post: 12-03-2015, 12:32 AM
  6. [SOLVED] Applying custom data validation to multiple columns
    By D_N_L in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-21-2014, 05:11 AM
  7. Applying Conditional Formatting to Data Validation
    By kcstewart in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-28-2007, 06:46 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1