

Neither of us got the enable editing button. Once uploaded neither she or I could edit it - even after entering the password. for example today my colleague encrypted a spreadsheet and marked as always open as read only to upload on teams. To top it off not all staff in the same team have the same permissions 😶🥴😖. Not to mention PCs in the same block in two seperate offices connect to seperate domains 😶🥴😖. Freeze top row via search appears on some machines and not others.

The org I currently work has done some funky things with the application settings. How about guide on a better way to freeze panes and top rows? 😁😁 Quick tip: If you want to select all the sheets, right-click one of the sheets, and choose the Select All Sheets option.īookmarked for future use 😁 - will be handy to direct folks here as opposed to having to explain it. Select the first sheet at the bottom of the document, hold on to the Ctrl key, and select the other sheets to which you want to apply the same header.Add the header and footer as you usually would (see above steps).

