asked on
I am allowed to view part of my spreadsheet
I have spreadsheet made up of data for January, February and March. I am allowed to looked at March only. There are no frozen panes. I have gone through the entire view commands and nothing changes. I have played around with F1 and all of the function keys and nothing. This spreadsheet is shared between four computers using dropbox.com.
Microsoft OfficeMicrosoft ExcelMicrosoft Applications
Last Comment
John
ASKER
I checked both of your possible solutions and neither of them were the problem. Thanks so your quick response.
Can anyone else see the entire sheet? Is the sheet maximized in your Excel Window?
... Thinkpads_User
... Thinkpads_User
ASKER
No one else can see the entire sheet. I have tried full screen and all it does is show March only.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
1. Is it, hidden? Do you know how to check for these?
1.1 It could be hidden using VBA (in which case, it has to be unlocked from VBA Editor)
2. Can you see the tabs for other months? If you cant see the tabs, then the tabs can be disabled.
Let me know the answer for 1 and 2.
1.1 It could be hidden using VBA (in which case, it has to be unlocked from VBA Editor)
2. Can you see the tabs for other months? If you cant see the tabs, then the tabs can be disabled.
Let me know the answer for 1 and 2.
@wwfashion - Thanks and I was happy to help.
.... Thinkpads_User
.... Thinkpads_User
1. Have people used Group (under Data) to group ranges of cells. There would be a + sign to expose these.
2. Have people pulled a column completely closed. You can determine this if columns appear to be missing.
3. Under View, there is Split as well as Freeze, but you appear to have looked at these.
.... Thinkpads_User