ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   lock multiple rows and colums ? (https://www.excelbanter.com/excel-discussion-misc-queries/115362-lock-multiple-rows-colums.html)

Boswell

lock multiple rows and colums ?
 
When working in Excel; Is it possible to lock multiple locfations, on a .wks?
--
Boswell

Franz Verga

lock multiple rows and colums ?
 
Boswell wrote:
When working in Excel; Is it possible to lock multiple locfations, on
a .wks?



Hi Boswell,

If you mean to lock multiple rows and colums while scrolling, you can use
Freeze Panes, from menu Window.

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy




All times are GMT +1. The time now is 02:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com