Copy Excel Column Width From Another Cell

If you are working in Excel and would like to match the width of a column to exactly that of another column (e.g., for consistency and clear communication), here’s how to do it.

Spoiler alert:
it’s all about using the Paste Special dialogue box.

In this example, let’s say you wish to adjust column B to have the same width as column A….

1. Select a cell in column A, and copy it with Ctrl+C

2. Select a cell in column B, and choose Home tab >Paste drop-down arrow >Paste Special… (Alt H V S)
– the Paste Special dialogue box displays

3. In the Paste Special dialogue box, choose Column widths (the third option from the top on the right), and click the OK button.

Note: You can paste multiple column widths at once, which is very useful when you want to set up a new worksheet with the same layout as an existing worksheet.

Thanks to Able Owl Excel tips for this one.

For great time-saving tips, look up our Archive of Tech Tips or look through the the Technology Information for Staff website.

Was this tip helpful to you? Anything else you want to know? Please leave a comment below.

You’ll find more learning at Learning and Development.

New Workshop: Delegating and Influencing to achieve results

Register for the Delegating and Influencing workshop
on Tuesday 20 November, 9am – 4.30pm.

Delegation is a critical skill for leaders in today’s environment.
Fewer resources, changing motivations, and complex business goals are just a few of the challenges leaders face.

Influencing is another crucial element to successful leaders and teams – whether it’s an innovative breakthrough, a simple process improvement or a change in ‘the way things are done around here’, making it happen requires a strategy.

In this programme, participants learn the skills they need to address these challenges, gain the commitment of team members, develop individual skills and abilities, and enhance the overall capability and capacity of their teams and, ultimately, UC.

Don’t miss out, this course is too good to miss, and this is your last chance to register for at least another 6 months!

Is this course not quite what you are looking for? To see what other programmes are available, visit the Learning and Development website for more information.


Thursdays in Black – not just for students

Thursdays in Black is a global campaign aimed with increasing awareness of sexual violence, consent culture, and positive relationships. Thursdays in Black encourages everyone to wear black every Thursday in solidarity against gender based violence.

Student blogger Ben reflects on efforts on campus to build the Thursday’s in Black campaign for the UC campus community – students and staff.

The 2018 formation of UC’s Thursdays in Black club has led to many events including clothing swaps, discussion panels, and free workshops, keeping its focal message in mind. You can typically find our stalls Thursday’s at the central library’s entrance for free coffee, resources, and conversation. Otherwise, look out for us on Facebook. The on-campus presence of clubs and campaigns such as Thursday’s in Black lies at the heart of UC’s culture, building a community united in diversity.

Kaitlyn White, President of Thursdays in Black @ UC says:

“It’s so important to have a movement like Thursdays in Black that breaks down the taboo of sexual violence and is spreading awareness for what we all can do to end rape culture. To have a campaign like this on campus means that we can firstly spread awareness about what sexual violence is, then take actions within our communities and through working with the university to end sexual violence and promote a safe and fun campus.”

(Thursdays in Black has developed a strong presence on campus. Left to right: Mel Haworth, Abby Robertson, Kaitlyn White, Katrina Hope.)

On-campus societies and campaigns such as Thursdays in Black, the counsellors at the UC Health Centre and those of the Māori Student DevelopmentPacific Development, and Student Care teams are all there for a reason. The safety and security of everyone on campus is paramount.

In the following New Zealand Police video, Dr Cathy Stephenson from Medical Sexual Assault Clinicians Aotearoa (MEDSAC) outlines some quick facts on sexual consent.

In the following New Zealand Police video, Dr Cathy Stephenson from Medical Sexual Assault Clinicians Aotearoa (MEDSAC) outlines some quick facts on sexual consent.

You can read more about Thursday’s In Black at UC  in the latest Chronicle on page 22>

UC info on sexual harassment and sexual assault is available here> including information on:

  • consent

  • bystander intervention

  • healthy relationships

  • support

  • report

Exploring Contemporary Issues in Sexuality Education with Young People

A new book from Associate Professor Kathleen Quinlivan asks how school-based sexuality education can better equip young people to engage with contemporary social, political and cultural sexuality and relationships issues.

Challenging established approaches to sexuality education, Associate Professor Quinlivan’s book shines a new light on alternate perspectives that can help make sexuality and relationships education more relevant and meaningful for young people in a rapidly changing world.

For more information, or to purchase a copy, follow this link>