picassosdog
New Member
- Joined
- Apr 4, 2014
- Messages
- 3
Hi, just a quick question relating to the scroll bars capturing all the cells.
In the situation where I format a row or a column with a command that captures the whole row or column (e.g. highlighting a column with a certain colour) or a mistake entry of a value at the end of a row. This can result in the scroll bars now extending to cover the whole excel file, when I only want them to cover the data I am looking at (e.g. row 1 - 500, as opposed to every single row). I am unable to delete the unwanted rows as it goes beyond the processing power of the computer. Is there any way of overcoming this issue, without copying and pasting the data into a new tab or deleting excess rows?
Many thanks.
In the situation where I format a row or a column with a command that captures the whole row or column (e.g. highlighting a column with a certain colour) or a mistake entry of a value at the end of a row. This can result in the scroll bars now extending to cover the whole excel file, when I only want them to cover the data I am looking at (e.g. row 1 - 500, as opposed to every single row). I am unable to delete the unwanted rows as it goes beyond the processing power of the computer. Is there any way of overcoming this issue, without copying and pasting the data into a new tab or deleting excess rows?
Many thanks.
