How to AutoFit Rows And Columns in MS Excel (3 Methods including Macro)

Поділитися
Вставка
  • Опубліковано 28 жов 2024

КОМЕНТАРІ • 13

  • @dryasermufti1
    @dryasermufti1 Рік тому

    merge cell row, having text in two line pr three by pressing alt enter . can this roe be auto fit?

  • @nikichinnu
    @nikichinnu 2 роки тому

    Sir can we make particular range only autofit columns ...

  • @belladebird
    @belladebird 4 роки тому

    How to narrow a single highlight cell.. Not affecting whole column? Just 1 cell only. To make it more spacious from the other data?

  • @materialmarriage
    @materialmarriage 3 роки тому +1

    Will it do for merged cells?

    • @AjayAnandXLnCAD
      @AjayAnandXLnCAD  3 роки тому

      Can you please explain the requirement with an example?

  • @wildinstinct1585
    @wildinstinct1585 2 роки тому

    thank you

  • @sunilkumar-du2zu
    @sunilkumar-du2zu 2 роки тому

    Please make a video on pivot table with shortcut keys and find monthly and daily sale figure through sales person name

  • @vikramgr8007
    @vikramgr8007 4 роки тому

    when i use this formula my hidden column get visibly, what can i do in this situation, i want my cell autofit but hidden column remain hidden they should not visibly

  • @pinkudas2670
    @pinkudas2670 4 роки тому +1

    how do i add developer tab in excel?

    • @AjayAnandXLnCAD
      @AjayAnandXLnCAD  4 роки тому

      Right-click on any of the tabs in the Excel ribbon > Customize the Ribbon > In the dialog for Excel Options, Mark the checkbox for Developer and Click OK

  • @ramakrishnanm5817
    @ramakrishnanm5817 2 роки тому

    How to write macro for cell border according to cell reference

  • @uniqueknowledge1458
    @uniqueknowledge1458 2 роки тому

    Tnx

  • @mukulkalal84487
    @mukulkalal84487 2 роки тому

    HOW CAN MAKE DEFAULT IT