Forum Discussion
Evolushunn
Mar 24, 2019Copper Contributor
How do I delete unused rows and columns in Excel?
I am trying to create a single one page document in Excel without all the extra unused columns and rows. I want to use this one page form to document specific data for a given day. I know that it c...
PeterBartholomew1
Mar 24, 2019Silver Contributor
If you select a column, then Ctrl+Shift+RightArrow to select columns to the right.
Finally, right-click the heading and select 'Hide' from the dropdown menu.
If anyone has a slicker method, I would be interested to know.
Removing the grid by unchecking it on the View ribbon tab also improves the visual appearance.
Lonnie82
May 19, 2019Copper Contributor
PeterBartholomew1 Thank you Pete. I appreciate your help
PeterBartholomew1 wrote:If you select a column, then Ctrl+Shift+RightArrow to select columns to the right.
Finally, right-click the heading and select 'Hide' from the dropdown menu.
If anyone has a slicker method, I would be interested to know.
Removing the grid by unchecking it on the View ribbon tab also improves the visual appearance.