Excel Forum

How to remove excessive formatting?

Trevor Dawkins

Member

Members

Forum Posts: 22

Member Since:
May 17, 2019

Offline

October 3, 2021 - 12:38 am

One of Mynda's recent newsletters discussed 10 things not to do in Excel, one being formatting entire columns. Ok, but how can one see if a whole column is formatted and how can that be removed/cleared? I know I've used that function quite often, even when it concerns data in tables...

Lionel Baijot

Member

Members

Forum Posts: 114

Member Since:
September 9, 2020

Offline

October 3, 2021 - 8:04 pm

Hello Trevor

You can use CTRL+End to see which cell is the last active cell in each tab.
If you delete unnecessary rows and/or columns, don't forget to save your file again before you check again with CTRL+End.

BR,

Lionel

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Kim Knox, Jeanine Hagge, Nada Perovic

Guest(s) 10

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 871

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

Jessica Stewart: 205

A.Maurizio: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

Othman AL MUTAIRI

Misael Gutierrez Sr.

Attif Ihsan

Kieran Fee

Murat Hasanoglu

Brett Dryland

Saeed Aldousari

Bhuwan Devkota

Kathryn Patton

Maria Conatser

Forum Stats:

Groups: 3

Forums: 24

Topics: 6222

Posts: 27293

Member Stats:

Guest Posters: 49

Members: 31916

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen