Smart questions
Smart answers
Smart people
Join Tek-Tips Forums
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Hiding unwanted cells in ExcelHelpful Member!(2) 

LewisReeder (IS/IT--Management) (OP)
6 Mar 08 13:40
Hi All,

I was wondering how to hide the majority of cells in excel. I currently have a spreadsheet where I only need to see up the "K" column and down to row 51. I would like to hide every other cell except this section of the spreadsheet. I know how to use the hide option, but it requires highlighting every single cell I want to hide. Is there an easier method?

Thanks,
Lew
SkipVought (Programmer)
6 Mar 08 13:43



Hi,

You cannot hide CELLS.

You can hide ROWS or COLUMNS.

Select ALL CELLS

Turn on the AutoFilter

In the subject column, select NonBlanks

Skip,

glassesI'll be dressed to the nines this week, as I go to have my prostatectomy...
Because, if I'm gonna BE impotent, I want to LOOK impotent!tongue

LewisReeder (IS/IT--Management) (OP)
6 Mar 08 13:51
Skip,

Im sorry, I was not clear. I need to hide every row/column that I am not using. Ideally, I do not even want to know that a column exists after the "K" column and the same for rows after 51. Is there a way to hide or remove them completely. I know I have seen it done, just not sure how to go about it. Thanks.

Lew
Helpful Member!  BlueHorizon (Instructor)
6 Mar 08 14:11
Hi,

Yes, you can accomplish this.  Hide the columns and rows you don't want to see then protect the wookbook for structure:
Select Column L and use the Ctrl + Shift + right arrow combination to select all columns to IV.  Right click and Hide.
Then select row 52 and use the Ctrl + Shift + down arrow combination to select all remaining rows.  Rich click and Hide.
Tools menu/Protection/Protect Workbook.  In the popup, leave Structure selected, add a password if desired, and click OK.
Close and re-open.  This ought to doit!

Hope this helps!

Best,
Blue Horizon 2thumbsup

Helpful Member!  AnotherHiggins (TechnicalUser)
6 Mar 08 14:11
Select Column L by clicking on the column header itself, up in the gray box above the cells.

Press [Ctrl]+{Shift]+Right Arrow.

Right Click anywhere in the selected cells.

Select Hide.

Repeat for row 52, replace right arrow with Down Arrow to select all subsequent rows.

_____
-John

    The plural of anecdote is not data

Help us help you. Please read FAQ 181-2886 before posting.

BlueHorizon (Instructor)
6 Mar 08 14:16
Hi,
You can do the following to hide unwanted rows and columns and then protect the workbook for structure:
Click on Column L, use the Ctrl + Shift + right arrow combination to select all remaining columns, right click and hide.
Click on row 52, use the Ctrl + Shift + down arrow combination to select all remaining rows, right click and hide.
Tools menu, Protection, Protect Workbook, leave Structure selected, add a password if desired, click OK.
Close and re-open.  That oughta do it!
Hope this helps!

Best,
Blue Horizon 2thumbsup

AnotherHiggins (TechnicalUser)
6 Mar 08 14:21
Blue,

You just posted almost the same thing. You haven't gone and lost your short term memory, have you? wink

_____
-John

    The plural of anecdote is not data

Help us help you. Please read FAQ 181-2886 before posting.

LewisReeder (IS/IT--Management) (OP)
6 Mar 08 14:30
Thanks guys. It worked.

Learn something new everyday,
Lew
BlueHorizon (Instructor)
6 Mar 08 16:18
Close, anotherhiggins, but not yet smile  My screen didn't refresh so I thought it didn't get posted...
that's my story and I'm sticking to it!

Best,
Blue Horizon 2thumbsup

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close