that knows how to fix this issue for me. I will buy you a drink or three if ever we should meet. If not, then just accept my undying thanks for the help. I admit to being a microsoft groupy, have been for years and have grown accustomed to everything they’ve come out with. About three months ago, I received an excel file from a friend that had a giant blue space on the left, and in checking ‘view’ and all sorts of things, even searching the internet, I can’t find a solution to make the file load correctly to the left. At the same time, my other excel files went to whacko mode when I opened them.
They all used to open in excel interface – the same size, with the same borders. Color me crazy, color me stupid, I really don’t care, just tell me how to fix it. When the whacko mode started, every time I open an excel file, it loads in a different size in the excel sheet. When I originally had the problem, the same friend sent a query out to a friend, who opened it in xlsx format and sent it back to him, he sent it back to me, and all was normal. My excel files slid out of whacko mode and all was good. Not now, it started all over again. Screen shots provided:
the 1st screen shot is one that loads in a whacko size – not that it’s special, they all do now in a variety of sizes, but it can be resized to match the excel screen. The 2nd one is the one sent by my friend with the giant blue space on the left that won’t go away and can’t be resized. Seriously fucking irritating since I use excel files all the time – yes it’s to keep track of all the money I wish I had. HELP! Anyone? Everyone?
*****
On more fun and exciting news, my boy the super artist in Oregon turned 40 today. I remember his day of birth well. His dad died three months earlier, my oldest son Dan was from my 1st marriage and about 3 1/2 years old. This boy was 9 lbs, 1 1/2 ozs and born 2 weeks late. SHIT! I was really feeling sorry for myself. I lived in Sandpoint ID and stayed in Spokane WA with a friend the last few weeks. She was more nervous than a new father as she drove me to Sacred Heart Hospital. When we got to the hospital, she left Dan asleep in a blanket in the back seat and took me to admittance – she locked her keys in the car and had to have someone help her jimmy the window to get in – Dan wouldn’t wake up…but hey, he was 3, he didn’t give a damn.
After I gave birth, my uterus didn’t contract like it should and I continued to bleed. I had an ice pack between my legs, one on my stomach, and an iv in my arm that made me keep having contractions – oh fucking joy – and the worst of it was a nurse came in every few minutes and kneaded my dough belly with her fists just like it was bread needing to be kneaded down to rise again. Shit it hurt! She told me it was to make the uterus do what it was supposed to do. Must’ve worked. Have no idea how they do it now – hell that was 40 years ago. I can remember crying in my aloneness but my poor mom worked a shift in a restaurant and then drove the 70 miles to see me. She was an angel sent to give me hope for better days.
I had a lot of worries with that boy. He grew up way too fast with way too many girls around and ended up having his first baby (getting married and joining the service) when he was 17ish. Life went on. Lots more things happened and I worried that he would ever begin to see the light of day. He went on a roller coaster ride from hell where I don’t believe he drew a straight breath for years – include all drugs and alcohol in that. I went out for a jog one day and this poem ran through my head, when I got home, it was mostly still there and I penned. I think he did make it, after all. Damn I love that boy! Forty years came and went in the blink of an eye – and a lot of it’s still tucked in my thoughts, surfacing now and then, sometimes bringing laughter, sometimes bringing tears. WTG Joshie!
Could not be easier! Click on the “Normal” page layout on the menu at the very bottom of the excel page, near the 100%. There are three little windows/options you can choose from.
Looks like you can’t reach the menubar of the spreadsheet, so you can’t grab the spreadsheet to move it.
Try clicking and the (hyphen) keys to bring up the menubar and click Move. Now use your arrow keys to move the spreadsheet down.
Maybe working with maximized windows in Excel will keep this problem away in the future as well.
Mudslide!
Err… Guess I shouldn’t of used greater than, less than symbols.
..Try click the ‘alt’ key and the ‘-‘ key…
Doesnt it just resize and remember the size next time you open it if you double click the header bar of the spreadsheet? Like where it says “Problem.xls” double click that bar and it will resize to full screen. Then close it. In my Excel it remembers the size the next time I go in.
thank you everyone that responded, no, none of it works. Saras, I had already tried ‘normal’ it doesn’t do anything.
I’ve also tried maximizing the excel window – and opening it first, then opening a file, and nothing changes. The one file still will not move or adjust into the big blue space on the left. The other excel files, when opened, all open in different sizes inside the maximized window.
I never open excel and then open a file inside it – the norm is to click on a shortcut and just open the file I want to use, the results are still skewed, each opens in a different size inside the main window. Since this problem came back, I have tried opening excel first – then the file I want, but nothing changes.
I’ve checked macros, views, formatting, etc., and can’t find the answer. There has to be one, probably the problem is I don’t know what question to ask when searching the internet. Like searching ‘blue space in excel file’ brings up a nightmare of things that have nothing to do with the problem or even excel. I went to the forums and started searching, haven’t posted yet.
thanks for all the efforts, if you think of anything else, please ship it my way. If you want me to send you the skewed excel file and see if you have better results with it, send me an email with the request geenenpokerworks.com
Was it my fault again????? Well, thanks for calling me your friend. And I hadn’t even posted about the Patrik Antonius hand. So, since I know nothing about excel other than filling in spaces, let me say that I suspect that the reason Antonius played the hand the way he did was because of whom he was playing, meaning Sahamies, AKA “Ziigmund”. Sahamies is a high-stakes Internet guy who, even in his stint on High Stakes Poker, showed the proclivity to bet with air. I’m guessing that Antonius put the bluff percentage much higher than normal, knew that unless he was up against a set that he could still suck out, went with some kind of gut read, and took his chances. Even great players look like idiots from time to time, but the fact that he could make a call like that probably stops a lot of people from trying to bluff him or play marginal hands against him.
Try the ALT and HYPHEN combination again.
1. Open the excel spreadsheet.
2. Click on the worksheet to make sure it’s ‘active’
3. Hold down ALT, press HYPHEN
4. The worksheet menu (top left hand) should open and ‘Move’ should be visible. If Move isn’t visible, press M.
5. Now use the arrow keys on your keyboard to move the worksheet around. Goal is to make the top of the worksheet visible.
Hmmmm.. Just found something else.
Take a look and see if the workbook is protected. Click ‘Review’ from the menu bar and click the ‘Unprotect Workbook’ button. Once workbook is unprotected you should be able to use some of the options listed in other comments here.
If you only see a ‘Protect Workbook’ button, then he workbook is not protected.
Paboo, I can’t thank you enough for your efforts – I tried them. That sheet appears to be frozen in hell to the right. I can get to the top of the worksheet by using the scroll on my mouse but simply can’t get past the big blue space on the left, even in trying to resize the sheet. Another friend suggested I reinstall office – I will try that this weekend. Thanks again. *hugs*