How to Hide Cells in Excel

How to Hide Cells in Excelの実践ガイドについてポイントを解説します。初心者でも安心のガイドをチェックしてください。

You’ve got a row of numbers that are embarrassingly wrong, but you can’t delete them because your audit trail would scream. Right-click the row number—the gray box on the far left—and select “Hide.” Poof. It’s gone. The same trick works on columns: grab the letter at the top, right-click, and vanish. Congratulations. You’ve just made a spreadsheet witness protection program.

Here’s the kicker: Excel loves to remind you it’s there. You’ll see a double line where the hidden row or column used to be, like a ghostly scar. It’s Excel’s way of saying, “I know what you did.” But if you want to be truly sneaky, you can select the rows around the hidden ones, right-click, and choose “Unhide.” Out walks the skeleton from the closet. Or, you know, that embarrassing column of leftover pizza expenses.

What About the Entire Sheet?

Sometimes a whole worksheet needs to get the Lamont Cranston treatment—the Shadow knows. Right-click the sheet tab at the bottom (it says “Sheet1” or “PayrollMistakes”). Choose “Hide,” and the tab vanishes like it never existed. Surprising fact: you can hide up to 255 sheets in a single workbook before Excel throws up its hands. That’s enough space to hide every bad idea you’ve ever had since 2003.

To bring a hidden sheet back to life, right-click any visible sheet tab and select “Unhide.” A dialog box appears listing your fugitive sheets. Click one, hit OK, and—boom—it’s back, blinking in the fluorescent office light. Just don’t let your boss see you do this. They’ll assume you’re doing something shady, like hiding the true number of vacation days you’ve taken.