Forum Discussion
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
Select all unused rows, then right-click in the selection and select Delete from the context menu.
Do the same for all unused columns.
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.
Select the first unused row.
Then press Ctrl+Shift+Down Arrow.
Delete the selected rows.
Select the first unused column.
Then press Ctrl+Shift+Right Arrow.
Delete the selected columns.
- Perfect. Thank you.
I was not doing this from the first unused place.
