Dear Friends,
I am preparing a data base which comprise multiples columns and rows; here I need to hide the unnecessary Columns and Rows to enter the data base quickly.
When I am trying to hide the same by selecting the respective columns or rows, I am getting a message that “Cannot shift objects of sheet". Hence kindly guide me in this regard to get the appropriate result.
Further, please let me know the easy key board short cuts for hiding and UN hiding the column and Rows to work easily.
Your kind support in this regard would be highly appreciated.
Thanks in advance
I am preparing a data base which comprise multiples columns and rows; here I need to hide the unnecessary Columns and Rows to enter the data base quickly.
When I am trying to hide the same by selecting the respective columns or rows, I am getting a message that “Cannot shift objects of sheet". Hence kindly guide me in this regard to get the appropriate result.
Further, please let me know the easy key board short cuts for hiding and UN hiding the column and Rows to work easily.
Your kind support in this regard would be highly appreciated.
Thanks in advance