Excel - Adjust Vertical & Horizontal Scroll Bars
Spi25rit
-
Raymond PENTIER Posted messages 58551 Registration date Status Contributeur Last intervention -
Raymond PENTIER Posted messages 58551 Registration date Status Contributeur Last intervention -
Hello,
I have a tiny scrollbar on my Excel file (used and shared with a collaborator on Drive)
I’m looking for a way to make it more normal, meaning adjusted to the number of non-empty cells.
The trick with Excel 2003 (Select the row just after the end of your table and do a "Ctrl+Shift+down arrow" to select the empty rows down to the end of the existing rows in Excel.
Then do "Alt, E, S" right after (shortcut for delete). Go back to cell A1 and "Ctrl+S" (save).) unfortunately doesn’t work anymore.
Configuration: Windows / Firefox 92.0
I have a tiny scrollbar on my Excel file (used and shared with a collaborator on Drive)
I’m looking for a way to make it more normal, meaning adjusted to the number of non-empty cells.
The trick with Excel 2003 (Select the row just after the end of your table and do a "Ctrl+Shift+down arrow" to select the empty rows down to the end of the existing rows in Excel.
Then do "Alt, E, S" right after (shortcut for delete). Go back to cell A1 and "Ctrl+S" (save).) unfortunately doesn’t work anymore.
Configuration: Windows / Firefox 92.0
2 réponses
Hello.
Make a copy of the file, replace the confidential data, and make it available to us.
--
It's great, retirement! Especially in the Caribbean...
Raymond (INSA, AFPA)
Make a copy of the file, replace the confidential data, and make it available to us.
1) Go to https://www.cjoint.com/
2) Click on [Browse] to select your file (15 MB max)
3) Scroll down to click on the blue button [Create Cjoint link]
4) After a few seconds, the second page will display, with the link in bold; right-click on it and choose "Copy link"
5) Go back to your discussion on CCM, and in your message, do "Paste".
=>See the guide https://www.commentcamarche.net/faq/29493-utiliser-cjoint-pour-heberger-des-fichiers
There are also:
1) https://mon-partage.fr/
2) https://www.transfernow.net/
--
It's great, retirement! Especially in the Caribbean...
Raymond (INSA, AFPA)
I've already tried but it doesn't work.
Any other ideas?
Thank you @Raymond PENTIER