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?
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
- 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"
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.