Forum

Notifications
Clear all

How to remove excessive formatting?

2 Posts
2 Users
0 Reactions
89 Views
(@td99)
Posts: 22
Eminent Member
Topic starter
 

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...

 
Posted : 03/10/2021 10:38 am
(@questvba)
Posts: 125
Estimable Member
 

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

 
Posted : 04/10/2021 6:04 am
Share: