easy excel tricks

  1. K

    How Get Question Reference

    (1) How to get reference Sheet 1 to Sheet 2 (2) We Need four Option Reference According Match Question on Sheet 1 *Kindly make this formula for "sheet2" Condition 1 :- i will change Serial Number After Change Question in "sheet 2" (match Serial no. and question to "sheet1") Condition...
  2. K

    Get SUM Total After Target ROW Via Formula ????

  3. K

    Make One Dropdownlist , Including all table Column Cell Details Show without Dependent Dropdownlist ?

    @ How to make One Dropdownlist , Including all table Column Cell Details Show ???? without Dependent Dropdownlist ??? How to show dropdownlist using different -different Columns data , And Add Included Single Dropdownlist ************************************************NOT USE DEPENDENT...
  4. K

    @ How to match Two condition & show value ???? via formula

    @ How to match Two condition & show value ???? via formula 1 st table to match 2nd table data , Need Both Condition Match (1) Invoice No. (2) CHA , And Get Result After match 1st table
  5. K

    How to use dropdown list according Two or more different Tables ???

    Query : " HOW TO COMBINE " ITEMLIST " & USE IN DROPDOWN LIST (Condition : Inclued Both table "Item list" * Both Table "Item list is different * BOTH TABLE ITEM LIST SHOW ON MY DROP-DOWN LIST . HOW IT POSSIBLE THIS ????? KINDLY SUGGEST RIGHT WAY TO SOLVE THIS QUERY. Note: I was make...
  6. K

    How to make Automatic serial number with text ????

    How to make Automatic serial number with text ???? Basic = A1+1 =2 Next level : 1) India Combination with text Kindly Help me.....
  7. K

    How to use multiple criteria using to conditional formatting ??? (Condition is cell value After Zero Highlight Cell in RED color ?

    * how to Apply Condition Formating in Particular Cells At a time, (Condition : IF then " Available Qty " <1 to Highlight Cell is RED color). * This condition Apply but Not properly Working , Pleased help to solve this query, I try to use Multiple criteria using this condition formatting.
  8. K

    how to Apply Condition Formatting in Particular Cells At a time ??? (Rules : " <1 " Highlight Cell color to RED After Zero .)

  9. K

    We Need Only TEXT Contain, How to possible in Excel Formula ????

    All Number list is Same Len ,if Number After Single Space , We Need Only TEXT Contain ,How to possible in EXCEL formula .......
  10. K

    How to Pull data One file to both file ????

    How to Pull data One file to both file ???? I try to Pull data "Master" File To "Local" & "Export" File .......... I don't Know ???? How to possible .......Pleased send us Formula in excel..
  11. K

    How to match same invoce no. & get data "FILE -1" TO "FILE -2" ...

  12. K

    How to trace 2 Digit And Highlight Cell , Different Number to change Different Color Highlight. ?

    Query : How Set Different Number to Different color Highlight (like a same number Group Show in same color) Number match perfect & Smart..........pleased Solve it Conditional...
  13. D

    Change borders/gridlines of cells in rows A, B, C & D when cells in row E contains no blanks

    Hello everybody, I am currently sitting with the following material overview file in Excel: I have made some conditional formatting so whenever I enter a number in column E the entire row gets highlighted. Unfortunately, this erases/makes invisible my dark gridlines/borders from before...
  14. Y

    Change Default Color Palette 2016

    I know this is super easy for most of you. The question is how to change the default color palette theme. Currently I can make the proper changes I want, but it reverts back the next time I open Excel. Thank you,
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top