What is the WRAPCOLS and WRAPROWS function in Excel 365?

Microsoft Excel Hard

Microsoft Excel — Hard

What is the WRAPCOLS and WRAPROWS function in Excel 365?

Key points

  • WRAPCOLS and WRAPROWS handle array reshaping, not text wrapping.
  • The functions allow for optional padding in incomplete rows or columns.
  • WRAPCOLS prioritizes column filling, while WRAPROWS prioritizes row filling.
  • These functions are distinct from chart label or cell value wrapping.

Ready to go further?

Related questions