Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
hidden columns and rows in excel
- Thread starter mart10
- Start date
[ol 1]
[li]Select the surrounding columns of what you want to unhide.[/li]
[li]Right-click on a selected column header.[/li]
[li]Select Unhide from the pop-up menu.[/li]
[/ol]
That's one way... or if you want to do it for all columns in entire worksheet in case there are others, you can just click the gray square at top left between 1 and A, then do the same other 2 steps.
for rows, it's the same thing, but rows.
There are at least 2 or 3 other ways, but that's the easiest, I think.
"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57
[li]Select the surrounding columns of what you want to unhide.[/li]
[li]Right-click on a selected column header.[/li]
[li]Select Unhide from the pop-up menu.[/li]
[/ol]
That's one way... or if you want to do it for all columns in entire worksheet in case there are others, you can just click the gray square at top left between 1 and A, then do the same other 2 steps.
for rows, it's the same thing, but rows.
There are at least 2 or 3 other ways, but that's the easiest, I think.
"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57
- Status
