Microsoft Office articles
If you have a very large worksheet containing rows and rows of data it would be a lot easier for you if you were able to freeze both the top and bottom rows of your worksheet. Unfortunately, there is no way to do this in […]
Freezing Top and Bottom Rows in MS Excel Read More »
Remember when you first installed MS Office you were asked to provide a Product Key number? That number should have been something that came with the CD that you purchased. Sometimes it is on the outside of the CD case and sometimes you can find
Need to Locate your Microsoft Office Serial Number?? Read More »
We should all know about AutoText entries by now right? Ever want to have a shortcut key to enter a sentence or phrase in your document? Well AutoText sort of has a built in shortcut key. Once you have created your entry, you can key
Insert Text Quickly in Word with a Shortcut Key Read More »
‘Best STL’ is a UK based company specializing in instructor-led Microsoft Office training courses. However, Best STL has also produced a wide range of professional training manuals which are available free to download in PDF format. The manuals are generally available in various levels of
Microsoft Office: Wide range of Professional Training Manuals for FREE Read More »
There have been times when I have had to search for comment marks in a Word document. For instance, a client once sent me her large document that had been copied and pasted from another document and she was getting strange strings of text throughout
Search for Comment Marks in your MS Word Document Read More »
Once you have your ribbon customized perfectly and want everyone else to have the same, it’s a very easy task to share with your colleagues. Follow the steps below to learn how: Right-click your Ribbon and select Customize the Ribbon. Just below the the list
Share your Customization in MS Excel Read More »
Every time I run into this problem I can’t for the life of me remember how to fix it; Create a Word document – end the document with a table – if the table is exactly at the bottom of the document, Word automatically inserts
Removing a Blank Page After a Table in Word Read More »
You may have an occasion when you would like to copy cells from your current workbook to a new one. Fortunately, this is very easy to do. Follow the steps below to learn how: Close all open workbooks except for your current on and the
Copy and Move Cells to New Workbook in MS Excel Read More »
Draw Free-Form with a Pen or Highlighter in OneNote I bet you didn’t know you could draw free-form or write a note in OneNote! You can and more than that, it’s fairly easy to do. Follow the steps below to learn how: Click the Draw
Draw Free Form with a Pen or Highlighter in OneNote Read More »
Don’t you sometimes long for the easy formatting of numbers in Excel to format your numbers in your Word tables? You are not alone! Sometimes there is a need to enter numbers in a table column complete with the dollar sign and have it look
Format Currency in MS Word Read More »
On June 14th, Microsoft announced that Office had come to the iPhone. The Office suite — Word, Excel and PowerPoint — is available in an iOS app in the App Store. ‘Office Mobile for Office 365 subscribers’ allows you to view, edit and create documents.
Office Comes to the iPhone Read More »
Whether you inherit a document from someone else and you simply need to start from scratch, or you do a text dump from the Internet, you will someday need to know how to erase certain things from your document. There isn’t a one trick pony
The Magic Erasers for Word Read More »
Folks define names in their Excel worksheets all the time and they can sometimes end up with so many names that they have difficulty remembering them or finding them! Of course, you can can jump to a named range by clicking on F5 to open
I Know I Put That Name Someplace! Read More »
I write a lot of documentation. For me junk text is necessary for a few reasons. I may not want to display real names or confidential information using prior documents when I write a How-To. Or I may not want people to concentrate on the
Inserting Dummy Text in Word Read More »
