Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-16-2013, 10:38 AM
howie707 howie707 is offline Pinning a worksheet to screen Windows 7 64bit Pinning a worksheet to screen Office 2010 64bit
Novice
Pinning a worksheet to screen
 
Join Date: Dec 2013
Posts: 8
howie707 is on a distinguished road
Unhappy 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!!
Reply With Quote
  #2  
Old 12-16-2013, 11:49 AM
BobBridges's Avatar
BobBridges BobBridges is offline Pinning a worksheet to screen Windows 7 64bit Pinning a worksheet to screen Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

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.
Reply With Quote
  #3  
Old 12-16-2013, 12:42 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Pinning a worksheet to screen Windows 7 64bit Pinning a worksheet to screen Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #4  
Old 12-16-2013, 01:22 PM
howie707 howie707 is offline Pinning a worksheet to screen Windows 7 64bit Pinning a worksheet to screen Office 2010 64bit
Novice
Pinning a worksheet to screen
 
Join Date: Dec 2013
Posts: 8
howie707 is on a distinguished road
Default

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.
Reply With Quote
  #5  
Old 12-16-2013, 01:55 PM
BobBridges's Avatar
BobBridges BobBridges is offline Pinning a worksheet to screen Windows 7 64bit Pinning a worksheet to screen Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

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.
Reply With Quote
  #6  
Old 12-16-2013, 03:12 PM
howie707 howie707 is offline Pinning a worksheet to screen Windows 7 64bit Pinning a worksheet to screen Office 2010 64bit
Novice
Pinning a worksheet to screen
 
Join Date: Dec 2013
Posts: 8
howie707 is on a distinguished road
Default

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!
Reply With Quote
  #7  
Old 12-16-2013, 03:46 PM
macropod's Avatar
macropod macropod is offline Pinning a worksheet to screen Windows 7 32bit Pinning a worksheet to screen Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by howie707 View Post
I was explaining to you about the "pins". You seemed unfamiliar with them until now.
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]
Reply With Quote
Reply

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
Pinning a worksheet to screen How to summarise different worksheet to a summary worksheet samkiewhock Excel 1 09-06-2012 03:34 AM
Pinning a worksheet to screen "Auto-populating" data-worksheet to worksheet. meggenm Excel 4 02-04-2012 02:04 AM
Pinning a worksheet to screen Word 2010: "Screen shot" and "Print Screen" and fitting the page boundaries! Jamal NUMAN Word 4 06-30-2011 05:48 PM
Pinning a worksheet to screen Worksheet copying? markg2 Excel 4 01-07-2010 10:08 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft