Hiding Multiple tabs and Password protecting rows | Excel forum

Hi Fahim

to select more than one sheet at a time hold down the Control key whle you select the Tabs required.

If the tabs are next to each other then left click on the first tab and shift + left click on the last tab. The clicked tabs plus any between them will be hightlighted.

With regards to hiding data you may want to try hiding the rows in question them applying protection to the sheet by going to the Review Ribbon and in the changes group choosing Protect Sheet. Set a password to prevent unauthorised unprotection of the sheet.

By default the sheet is locked for editing and should also prevent the addtion or removal of columns. Do test this however. It may be possible to break the protection of a sheet using a macro or some programming. In other words applying protection may make it hard but may not guarantee the data remains hidden.

Here is a link to a fuller article on the Microsoft website regarding sheet protection in Excel 2007

http://office.microsoft.com/en-us/excel/HP100785801033.aspx?pid=CH101024601033

Do let us know how you get on.

Kind regards,
Andrew