Hi,
When I use horizontal and vertical scrollbars in an excell worksheet I would like to see only a specified area of that sheet, ex. A1 to AB30. Is it possible?
Thank you,
kras
Hi,
When I use horizontal and vertical scrollbars in an excell worksheet I would like to see only a specified area of that sheet, ex. A1 to AB30. Is it possible?
Thank you,
kras
You can hide columns and rowsOriginally Posted by kras
click on any cell in column AC and press Ctrl+Shift+Right arrow key and press Ctrl+0 to hide columns.
click on A31 and press Ctrl+Shift+Down arrow key and press Ctrl+9 to hide rows.
starguy
Tahir Aziz
PAKISTAN
https://www.facebook.com/businessexcel
__________________
Forum Rules (read before you post)
Links to the world of Excel
Thanks, starguy
You're welcome.Originally Posted by kras
Hi Starguy,
Is there a way to lock the view only on those cells, without the need to hide the rest rows/columbs?
kras
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks