Forum Discussion
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 can be done because there are calendars and specific charts and sheets that I can select from, but I want to design one specifically for my tasks. Is there a way to do that?
5 Replies
Evolushunn PeterBartholomew1 Lonnie82 Most templates simply turn off the grid lines and headings from the Page Layout / Sheet Options menu, which effectively hides the cells visually but they still exist in the sheet. You can also lock the sheet with a password, and specify one or more areas that are still editable even when the sheet is locked by the password which essentially confines changes to your selected areas.
Evolushunn wrote: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 can be done because there are calendars and specific charts and sheets that I can select from, but I want to design one specifically for my tasks. Is there a way to do that?
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.
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.
