Apr 18 2021 04:26 PM
RE: MS Excel WEB APP
Can someone tell me the secret to freezing at the same time, together, simultaneously the first row and first column in an MS Excel Web App spreadsheet.
At this time I can only lock one at a time.
I find it hard to believe that you cannot lock both (rows and columns) at the same time on Excel Web App version. Does this mean that no one builds large spreadsheet +50 rows long and +20 columns wide?
I am getting a run around from Microsoft to get an answer to a simple and reasonable setting.
Apr 19 2021 12:36 AM - edited Apr 19 2021 12:37 AM
@RHA1705 To freeze both the first row and first column, select cell B2. On the view tab, select "Freeze Panes".
This freezes the rows above and columns towards the left from the active cell.
Apr 19 2021 01:05 AM
May 27 2021 05:14 PM
Oct 05 2021 03:21 PM
Jan 28 2022 06:28 AM
May 08 2022 03:39 AM
Mar 05 2023 06:00 AM