Scroll area and Hiding unused portions for an entire workbook

[swervchee]

I use all of column A, B, and C, but i only use D1 to H44 other than that. Is it possible to hide everything to the right of Column I and below D44:H44, but leave the scroll area for columns A B C able to scroll to the bottom?

Thank you!

Moi

 

[baitmaster]

No / maybe. You can hide everything to the right of Column I. You can hide part of a row but not all of it. You could use a macro that changes which area of the sheet you could scroll to, depending on which cell your cursor is in. I wouldn't recommend it though

If you really wanted to try, it would need a worksheet_selectionChange event, identifying your activecell (/target), and changing the worksheet.scrollarea setting

 

[swervchee]

hmm....

I'm not entirely sure how to hide cells, but If I could hide everything to the right of Column I and everything in columns D-H below row 44, that would be good enough .

Thanks!

 

[baitmaster]

Ok, try this

- Click your cursor on the column heading "J", to select column J
- Hold Shift + Ctrl + [right arrow], to increase the selection to all columns to the right of (and including) column J
- Right click on the highlighted region, and select "hide"

Repeat for Row 45 and down

 

[swervchee]

Is it possible to hide only row 45 and down for columns D-H?

 

[baitmaster]

No, you can hide only entire rows and entire columns, hence my original post. Why don't you want that particular section to be visible?

 

[swervchee]

this is a spreadsheet used by old cranky guys who don't know or want to deal with excel. The less they can click on, the better lol. i can lock them out though, so its okay. was just hoping to hide them completely.

I do appreciate your help though!