PDA

View Full Version : Unwanted columns



admin
17th March 2012, 12:51 PM
Because the spreadsheet accommodates many user requests, there are a number of columns in the Bets worksheet that you may not need.

Rather than delete the columns I recommend you hide them instead. This should minimise any disruption to the Performance Summary sheet.

To hide a column, unlock the Bets worksheet by selecting Review -> Unprotect Sheet. The password is sport. Click on the column letter (A, B, C, etc.) to highlight a column. Then right click on the column and select Hide.

If you wish to view the column again, select the adjacent column letters to highlight the columns either side of it. Then right click on them and select Unhide.

If you wish to lock the sheet again, select Review -> Protect sheet. I recommend you use the password sport to keep it in line with the rest of the spreadsheet.