January 30, 2012

Hide/Unhide Microsoft Excel 2007 Rows/Columns to Protect your data

Hi Friends,
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













































































Featured Post

Java Introdcution

Please send your review and feedback to psrdotcom@gmail.com