If you work with multiple Excel workbooks everyday, then here is a handy tip.
Open all the files you frequently use together.- Go to View ribbon and click on Save Workspace
- Give a name to your workspace
- Now, whenever you need to open all these files together, just double click on workspace file in your explorer.
- You are done!
Workspace saves not just file collection, but also window layouts. That means, if you like to arrange your Excel windows in a specific fashion, you can save this arrangement too.
Bonus tip: Use specific filter criteria all the time? Try custom views.
More tips on using Excel & shortcuts.
Do you use workspace feature?
I find workspace feature to be very useful when I need to work with multiple files, especially in cases like file comparison and consolidation. I can save the file layout as a workspace and re-open it whenever I want to resume the work.
What about you? How do you use workspace feature? Please share your tips & experiences with us using comments.
4 Responses to “Office 2010 Contest Winners are here!!!”
I while ago I wrote a post on selecting a couple of names from a range via an UDF
I could have been handy.... especially because I didn't win.... lol
http://xlns.lamkamp.nl/?p=14
Sweet! I won! Thank you so much, Chandoo! I'm really speechless! I'll look out for an e-mail from you. Again, I really appreciate it, and I can't wait to fire it up!
Sincerely,
Tom "this one" 🙂
Thank You... Thank You... Thank You... 🙂
Hi,
Don't want to ruin your party.. 😉 but I noticed that when you sort the list A2:B11 (step 2), the RAND function re-calculates the numbers so that they are different and in mixed order again. I had to paste the whole area as values first and then sort to get it to work.
Wonder if the same happened to you because in your list at least Greg has a higher value than Tom 🙂