Do you want to hide[protect] the data then please follow the steps
Step 1: User left click in "Microsoft Excel - Book1"
Step 2: User mouse drag start in "Microsoft Excel - Book1" to select the rows
Step 3: User mouse drag end in "Microsoft Excel - Book1" to finish the row selection
Step 4: User right click on any of the selected row number in "Microsoft Excel - Book1" to get the row selection menu
Step 5: User left click on "Hide (menu item)" to hide the rows along with data
Step 6: User right click in "Microsoft Excel - Book1" to unhide the hidden rows
Step 7: User left click on "Unhide (menu item)" to get the data back
Step 8: Now User can see the rows along with the data
Step 9: User right click in "Microsoft Excel - Book1" to see the column selection pop-up menu
Step 10: User left click on "Hide (menu item)" to hide the columns along with the data
Step 11: User right click in "Microsoft Excel - Book1" to get the pop-up
Step 12: User left click on "Unhide (menu item)" to get the data back
Step 13: See the unhidden columns along with data now
1 comment:
Thanks
Post a Comment