#1
|
|||
|
|||
Pinning a worksheet to screen
Wow, this is something that I just learned and for the life of me, I can not pull it back out of the lessons! It is driving me crazy. Here it go's. I want to take a sample work sheet and pin it to the screen so that when I am going through the tutorials it will not hide under the windows. In other words when I am working between the windows it keeps disappearing and I have to stop the tutorial and find it. Last night, it was part of a lesson and I must have been so burnt out that I have done forgot how to do it. I have been looking back through the tutorials for about 2 hours so I would not have to post such a DUMB question, BUT, here I am 2 hours wasted and Im still stuck!! Could someone PLEASE help me out. My last post was the one I answered (sorta) myself but, I do not think it will happen this time. I want to be able to PIN the worksheet to the "working" screen so that I can use the tutorial and the sample worksheet will stay "on top". I hope that I have asked this question in a way that is understandable. PLEASE HELP!! |
#2
|
||||
|
||||
I'm not sure, but it sounds to me like you're saying you want a way to designate the Excel window "always on top". I've seen some help-related windows with that option—they're always-on-top by default but you can turn that feature off (and I always do). But if there's a way to turn it on for just any window, it probably is a function of Windows, not of Excel. If anyone here knows how to do that, I'd be interested myself, though I probably won't use it much.
|
#3
|
||||
|
||||
Perhaps use the " show windows side by side" option?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#4
|
|||
|
|||
It actually is a option. You use pins like you use pins in the "recents" option. When you open 2010 Excel and lets say you have opened a few blank templates and a couple of samples, then you close them and close Excel. You can then open Excel, go to the "recent" option and in that block you have a few saved "worksheets". To the right of each one you will see an icon of a push pin by each doc. If there is one that you use a lot, you can click the push pin and it will go from a "unstuck" push pin to a "stuck" push pin. It will also move that doc. to the top. There IS a way to "pin" a worksheet to the screen so that no matter what you do on that screen , the doc. that you "pinned" will remain on top of the screen that you are working in so you do not have to keep hunting for it and especially during the tutorial, you can work together with it without "pulling your hair out trying to keep up with it"!! Once I have found it again, I will post it up here for you. I am "PO'd" because I just went over it last night.
|
#5
|
||||
|
||||
The pins in Excel 2010's File,Recent action allow you to keep certain recently-used workbooks at the top of the Recent-Workbooks list. This means the workbooks you use a lot won't fall off the end of that list, during some week when you were doing a lot of work on something else; later on it'll still be there.
But that doesn't help you keep the Excel window on top of all the others in your screen. If that feature exists, it may be called "pinning" but it's not the same as the "pinning" that's done with recently-used workbooks. |
#6
|
|||
|
|||
That's correct. That's what I just said. I was explaining to you about the "pins". You seemed unfamiliar with them until now. I actually thought that I was explaining the "pins" to someone else. Anyways, as soon as I figure the option out that I am looking for, I will post it for those interested in using it. It sounds like something that you would not be interested in. Thanks for your help!
|
#7
|
||||
|
||||
I doubt anyone else contributing to this thread was unfamiliar with workbook pinning. You may have thought you were explaining the pinning function, but what you described in your first post is something entirely different - what you described is what anyone else might think of as being the 'keep on top' function that you can use with programs like the Windows Task Manager. You can't do that with Excel.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
New Monitor: Print Preview Screen On Left Side of Screen, Not Centered | tatihulot | Word | 1 | 09-11-2013 02:47 AM |
How to summarise different worksheet to a summary worksheet | samkiewhock | Excel | 1 | 09-06-2012 03:34 AM |
"Auto-populating" data-worksheet to worksheet. | meggenm | Excel | 4 | 02-04-2012 02:04 AM |
Word 2010: "Screen shot" and "Print Screen" and fitting the page boundaries! | Jamal NUMAN | Word | 4 | 06-30-2011 05:48 PM |
Worksheet copying? | markg2 | Excel | 4 | 01-07-2010 10:08 AM |