In Microsoft Excel, copying "LR" (Lorry Receipt) or "Copy" formats typically refers to replicating standardized document layouts for transport or logistics
: Select the source cell, click the Format Painter icon (Home tab), and then click the target cell.
Now that you understand how to copy formatting from left to right, open Excel and try each method. In less than 15 minutes of practice, you’ll never manually reformat a row again.