If you have a workbook that everyone views a little bit differently, you can automate it, so that everyone just has to click their own button. Even if you are the only one who uses it, but you use it differently for different purposes, this solution would work, too.
Q. I have workbooks with a lot of worksheets. I don’t need the horizontal scroll bar. I’d rather see more worksheets. Can I get rid of it?
If you’ve recently implemented or are thinking about implementing SharePoint in your new Office 365 environment here are a few things that I think are definite improvements.
How is the new Excel Sumlfs different from SumIf, and how do you dissect a formula to troubleshoot?
Here are step-by-step procedures for three deceptively tricky functions in MS Word.
Q. Do I need to create a separate SharePoint area for each team? Or can I have one SharePoint site grant access to each area?
Q. Is document co-authoring enabled by default?
Q. Can you limit who is able to restore during versioning?
Say Yes to Archive! When the Archive prompt comes up, just say Yes! You probably don’t realize it, but when Outlook archives an email, it just goes to a separate file structure which is still accessible from the Navigation Pane. This process keeps your Inbox and regular folders clean, neat and current, while still allowing you to easily access your older ones.
In Excel, when you have a 0-first digit zip code, it usually shows up as only the last four digits. So, take a Massachusetts zip code like 02201. If you just type that into an Excel cell it comes up 2201. You could type an apostrophe in front of it, but then it would appear left justified like all other text. There are several alternatives.