There are times in the workplace when employees 'accidently' hide columns or rows in Excel and they start to panic and say, " Where did my data go? I spent all day entering these numbers and I can't find it. I hope I didn't delete anything! " Well, sometimes the person did delete the data and you can only pray that they saved a backup copy. Some other times, they might have just 'hidden' the data by mistake. Let's take a look at the latter situation.
To begin,
click here to download the file as shown in Figure 1.1.
Figure 1.1
First, check to see if the panes have been frozen. If they are we'll turn if off by going to Windows>Unfreeze Panes. See Figure 1.2.
Figure 1.2
Now, type
A1 into the Name Box and press the Enter key. See Figure 1.3.
Figure 1.3
Now go to Format>Column>Unhide. See Figure 1.4.
Figure 1.4
You should now be able to see Column A (and myself). See Figure 1.5
Figure 1.5
To download the completed file,
click here.
That's it! Keep Excelling!
01-01-2008, 04:49 PM
Linear Mode
Similar Threads