One way to get around this issue is to convert the Excel table to a range by selecting any cell in the table, and clicking ...

Discover how to automate Excel tasks with macros and VBA. Save time, reduce errors, and streamline your workflow without ...

Make the Dot and Li & Fung accelerate fashion design with AI, cutting time-to-market and driving faster revenue growth.

Excel will then place a dotted line around the selected cell or cells to let you know that something has been copied (in this case, the formatting), and your cursor will change to a paintbrush icon.