HomeMicrosoft OfficeMicrosoft ExcelCopy Excel Column Widths

Copy Excel Column Widths

The Format Painter in Excel does more than just allow you to copy cell formatting. You can also use the Format Painter to copy column widths in a worksheet. To do this, use the steps below.


1. Click the letter of the column whose width you want to copy (in the column header).
2. Double-click the Format Painter button.
3. Click or drag your pointer through the letters of the columns that need to be the same width.
4. Click the Format Painter.

Rob Rogers
Rob Rogers
Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -

Most Popular

Recent Comments

Cleveland Furia on How to Clear Google Activity
Sid Wohlfarth on How to Clear Google Activity
Riley Magsayo on How to Clear Google Activity
สมัครรับเครดิตฟรี ทันที on How to improve Remote Desktop Protocol Performance
Neal Wangstad on How to Clear Google Activity
Slavcho Andov on How to install Ubuntu
Slavcho Andov on How to fix bad sectors
Sheraz Ali on How to Backup Android