Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagRe: How to clear formatting in all un-used cells in ExcelPerfect. Thank you. I was not doing this from the first unused place.Re: How to clear formatting in all un-used cells in Excel HansVogelaar Thank you. How do you select all unused rows? When I select the end of the document (CTRL-End), it takes me to the last row of my used cells. How to clear formatting in all un-used cells in Excel Example: Someone highlighted the row, added formatting, now rows K - end of time have lines in them. Same for columns. When I find the end of the