To hide or unhide specific rows or columns in Excel, you can take the following steps:
- Select the rows or columns you want to hide.
- Right-click the selection and choose Format Cells.
- Under the Protection tab, uncheck the Locked box.
- Go to the Review tab and click Protect Sheet.
- Check the box next to ‘Select Locked Cells’ and click OK.
- Your rows or columns will be hidden.