will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.
Trouble Unhiding Excel Row and Columns
It's easy to hide rows and columns in an Excel worksheet, and you or your boss or co-worker might do that when setting up an Excel file.
However, if you hide Row 1 or Column A in an Excel worksheet, you might have trouble unhiding them. This short Excel tutorial video shows you a quick way to see those hidden rows and columns again.
___________
April 5th, 2010 at 1:38 am
Nice tip Deb, I never knew that. I would have pressed F5 to bring up the Go To dialog and entered A1. Then choose Unhide from the Format menu. Your way is quicker and easier.
April 5th, 2010 at 9:15 am
Great idea and short cut. I have found this to be the case more than once that someone has hid the column couldn't figure out what happen to it and added another column reworked all the formulas in the ajointing fields etc. Not knowing that it was still there.
April 5th, 2010 at 9:37 am
Hi Deb, This is a nice tip. I stopped hiding because I didn't know how to get it back. Now I know.
April 5th, 2010 at 11:32 am
Thanks Tim, Fred and Peggy! Glad you like the tip.
April 7th, 2010 at 4:20 am
Just so your readers are aware... even if you had not posted selection trick in this blog item, they could still quite easily have selected Columns A and B by simply typing A:B in the Name Box (the empty field to the left of the Formual Bar)... that would have selected the hidden Column A along with the visible Column B. Similarly, to select the hidden Row 1 and the visible Row 2, they could just type 1:2 in the Name Box. Then, after doing either of these two steps, they could right click the selection and select the Unhide option.
April 19th, 2010 at 6:00 pm
[...] the answer on how to un-hide rows and columns in Excel, there’s even a [...]