Mar 24 2019 08:17 AM
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?
Mar 24 2019 09:30 AM
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.
May 19 2019 02:30 PM
@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?
May 19 2019 02:38 PM
@Peter Bartholomew Thank you Pete. I appreciate your help
@Peter Bartholomew 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.
May 19 2019 02:57 PM - edited May 19 2019 03:01 PM
@Evolushunn @Peter Bartholomew @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.