Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Showonly | Search instead for
Did you mean:
- Home
- Microsoft Excel
- Excel
- How do I delete unused rows and columns in Excel?
Discussion Options
- Subscribe to RSS Feed
- Mark Discussion as New
- Mark Discussion as Read
- Pin this Discussion for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 24 201908: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?
Labels:
5 Replies
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 24 201909: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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 19 201902:30 PM
@Evolushunnwrote: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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 19 201902:38 PM
@Peter BartholomewThank you Pete. I appreciate your help
@Peter Bartholomewwrote: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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 19 201902:57 PM - edited May 19 201903:01 PM
@Evolushunn@Peter Bartholomew@Lonnie82Most 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.
Skip to primary navigation