Jul 12 2021 10:45 AM
Hello, I'm desperately trying to delete these unwanted blank pages on my excel worksheet. I don't follow the instructions given. I don't think they pertain to my needs. Does anyone know a more user friendly way? Please help. Thanks in advance!
Jul 12 2021 10:55 AM
Solution
First step:
mark the first free column to the right of the area you actually use.
Press the key combination Ctrl + Shift + Right Arrow key.
So it is from this column to the end of the sheet, everything is marked.
Go to Menu -> Edit -> Delete Cells.
Second step:
mark the first blank line under the area you actually use.
Press the key combination Ctrl + Shift + Down Arrow key.
Now everything is marked from this line to the end line.
Go to Menu -> Edit -> Delete Cells.
Insert or delete rows and columns
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Jul 12 2021 12:37 PM
Jul 13 2021 12:37 AM
Jul 31 2023 05:31 AM
Jul 12 2021 10:55 AM
Solution
First step:
mark the first free column to the right of the area you actually use.
Press the key combination Ctrl + Shift + Right Arrow key.
So it is from this column to the end of the sheet, everything is marked.
Go to Menu -> Edit -> Delete Cells.
Second step:
mark the first blank line under the area you actually use.
Press the key combination Ctrl + Shift + Down Arrow key.
Now everything is marked from this line to the end line.
Go to Menu -> Edit -> Delete Cells.
Insert or delete rows and columns
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.