Hi my friends.
I have a problem I have sheets 1 to 211
I need a simple way of FREEZING TOP COLUMNS
Thanks in advance
Hi my friends.
I have a problem I have sheets 1 to 211
I need a simple way of FREEZING TOP COLUMNS
Thanks in advance
You can group all the sheets together, and then whatever you do on one sheet will be reflected on all the other grouped sheets. You must remember to UNGROUP the sheets when you have finished.
So, select the first sheet tab (1), then while holding the CTRL key down, select the last sheet tab (211). That will have grouped the sheets. Then on the sheet which is visible you can click in the cell below the row which you want to fix and use View | Freeze Panes. Then right-click on a sheet tab and select Ungroup.
Hope this helps.
Pete
@Pete:Wouldn't that be the Shift key? I think you'd use the CTRL key to select individual sheets.the CTRL key
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
It happens only for the first sheet but the rest sheets nothing will happen
Yes, Trevor is right. It should have been the SHIFT key, rather than the CTRL key.
Pete
See in my workbook I did for the sheet 2 to sheet 4. I use yellow colour to show the results I need I tried to use shift and control but only happens for the first sheet anyone can you help me please
Select the first sheet. Then press and hold the Shift key and select the last sheet.
Now select the row beneath the rows you want to freeze. Follow Pete's instructions from here.
Don't forget to deselect the sheets or YOU WILL CORRUPT THEM if you start to enter data.
Maybe I went wrong somewhere else.
Anyone please assist me there up is attached file
See attached
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
i didn't see any changes.
i don't know whta is the problem
It works on Sheets 2-4. so not sure why not the others. It does NOT appear to work for me when I select a group.
Last edited by JohnTopley; 01-12-2023 at 04:22 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks