Ask Your Question
0

how can I define a scroll area?

asked 2018-01-17 12:31:12 +0200

ursiaeschu gravatar image

My calc-list sheet extends from A1 to AF403. I would like to reduce the scroll area to the sheet.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-01-17 14:15:50 +0200

Lupp gravatar image

updated 2018-01-17 14:16:20 +0200

I don't actually understand "to the sheet", and assume you want to address the used area.
-1- Goto cell AG404 and hit Shift+Ctrl+RightArrow.
-2- Rightclick on one of the selected column labels.
-3- Slect 'Hide' from the context menu.
-4- Do respectively for the rows below number 403 using Shift+Ctrl+DownArrow and the label of a selected row.

edit flag offensive delete link more

Comments

Hi Lupp. thanks a lot. It worked.

ursiaeschu gravatar imageursiaeschu ( 2018-01-18 13:21:18 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-01-17 12:31:12 +0200

Seen: 110 times

Last updated: Jan 17 '18