Say you want someone having read-only access to a workbook, but you only want them to see certain data in it; the best way to moderate this is by right-clicking the rows or columns you want to hide, then click "Hide." To reveal the columns again, highlight the columns either side of the hidden one, right-click at the top, then click "Unhide."