Tip Details Add a Related Tip

Rate as: Positive Negative

Hiding columns and rows in Excel

If you want to hide columns and rows from display in Excel, there is a nice keyboard shortcut for this. To hide a column, put the cursor in the column to be hidden in the spreadsheet or select multiple columns and then press Ctrl + 0. If you want to show the hidden columns again, press Ctrl + Shift + 0. To hide rows it's a similar thing, put the cursor in the row of the spreadsheet to be hidden or select multiple rows and then press Ctrl + 9. Again, pressing Ctrl + Shift + 9 will bring back the rows that are hidden in the spreadsheet.
Rating: no ratings, 0 total Votes
Categories: Excel Microsoft office spreadsheet
Added: on Jul 31, 2007 at 11:57 am
Added By: an anonymous user

Comments on this Tip

Add a Comment
There are no comments for this tip
Your Comment:
(how to format)
Rate This Tip:

Verify Humanity:
Sorry, we know it's annoying, but please enter the characters shown in the image to the left so that we know you're an actual person and not an evil spammer. Thanks.
       

Related Tips

Creating a screenshot of cells in Excel 2007

Categories: Excel Microsoft office
no ratings, 0 comments
– Tip added by an anonymous user on Jul 09, 2007 at 5:48 pm

Disable the Word 2007 Splash Screen

100% positive, 0 comments
– Tip added by wordbird on Feb 09, 2008 at 4:29 pm

Change the default Save As directories in Microsoft Office

50% positive, 0 comments
– Tip added by an anonymous user on Jan 31, 2008 at 2:00 pm

Share Spreadsheets Online

100% positive, 0 comments
– Tip added by an anonymous user on Sep 04, 2007 at 2:42 pm

Selecting parts of words in MS Word

no ratings, 0 comments
– Tip added by an anonymous user on Jun 16, 2008 at 4:45 pm

Open Office 2007 documents in older versions of office

no ratings, 0 comments
– Tip added by an anonymous user on Dec 07, 2007 at 1:58 pm

Microsoft Tips and Tricks

100% positive, 4 comments - last added on Jul 09, 2007 at 9:22 am
– Tip added by an anonymous user on Jun 30, 2007 at 10:53 am

Cleaning liquid paper stains

Categories: stains laundry office
100% positive, 0 comments
– Tip added by cookie on Apr 08, 2008 at 11:11 am

Removing Permanent Marker from a White Board

Categories: business office
100% positive, 0 comments
– Tip added by an anonymous user on Oct 23, 2007 at 6:41 am

Speeding Office 2008 on a Mac

100% positive, 1 comment - last added on Jun 26, 2008 at 3:20 pm
– Tip added by an anonymous user on Jun 26, 2008 at 11:26 am

Displaying links in Google spreadsheets

Categories: spreadsheet google
100% positive, 0 comments
– Tip added by an anonymous user on Jun 11, 2008 at 1:51 pm

Test to see if your email is being monitored

100% positive, 0 comments
– Tip added by snoopy on Oct 10, 2007 at 7:49 am

Opening the Vista and Office boxes

Categories: Vista office
100% positive, 2 comments - last added on Aug 20, 2007 at 1:24 pm
– Tip added by an anonymous user on Aug 20, 2007 at 10:37 am

Get Work Done Faster on Microsoft Word, Excel , and etc.

no ratings, 0 comments
– Tip added by nixonlee on Jun 25, 2008 at 6:50 pm

Fix the Mac Office 2008 security bug

no ratings, 0 comments
– Tip added by an anonymous user on Jan 26, 2008 at 8:45 am

Working in multiple time zones in Outlook

Categories: outlook calendar office
no ratings, 1 comment - last added on Nov 19, 2007 at 12:51 am
– Tip added by an anonymous user on Nov 12, 2007 at 2:03 pm

Changing projector bulbs

Categories: office projectors safety
no ratings, 0 comments
– Tip added by michael-damon on Oct 08, 2007 at 8:13 am

Quick zooming in Microsoft Paint

Categories: Microsoft graphics paint
no ratings, 0 comments
– Tip added by an anonymous user on Sep 24, 2007 at 12:32 pm

Copying content from Office documents in Vista

Categories: windows Vista office
no ratings, 0 comments
– Tip added by an anonymous user on Jul 09, 2007 at 7:34 am