When setting up a worksheet where we need to separate one section of information from another, and present that separation clearly, we often use cell borders to accomplish the job. Obviously that option is a great way to get the job done, but we tend to use those for everything... so making that visual break … Continue reading MS Excel: Creating Visual Breaks Without Using Cell Borders
Copy and Paste Only a Cell Comment in MS Excel
MS Excel: Copy / Paste Only a Cell Comment When reviewing the contents of a worksheet, do you find that you've got the same comment to make over and over again? (The least of which being "Where the heck did that come from?") I know that when I go through and start getting into the … Continue reading Copy and Paste Only a Cell Comment in MS Excel
Creating Macros in MS Excel
Microsoft Excel is the one of the most popular spreadsheet programs used worldwide. It has a variety of features such as data storage, creating reports and charts, using mathematical functions, performing statistical analysis, ability to connect to databases, making use of pivot tables, V-lookups etc. One such very useful feature within Microsoft Excel is the … Continue reading Creating Macros in MS Excel
Deleting Multiple Comments in Excel
MS Excel: Delete Multiple Comments at Once If you've got an Excel worksheet that contains a lot of comments, it can be a bit of a pain to remove them all when you're done. Think about it. If the worksheet is a large one and you've managed to accumulate quite a few comments, it's going … Continue reading Deleting Multiple Comments in Excel
Applying Options in MS Office
When you’re in the Options dialog box for one of these newest MS Office programs, have you ever noticed this part of a section header? (You’ll notice that not all section headers have one…) Even if you did notice it…did you take the time to investigate? For many people the answers are no… either they … Continue reading Applying Options in MS Office
Resetting the Default View in Excel
MS Excel 2007 & 2010: How Do You Like to View It? We all have one... you know, that preferred view of our MS Excel worksheets. Some people like to see everything in the Normal view. Others prefer the Page Layout view, where Excel shows the physical breaks between each page, as well as the … Continue reading Resetting the Default View in Excel
Shrink to Fit in Excel
MS Excel: Data Too Long for the Cell? Use Shrink to Fit & Let Excel Fix the Problem for You! Ever have data in MS Excel that's just a bit too long for the cell? What happened? Did the column widen to accommodate? Or, maybe you got the infamous ##### to let you know that the number didn't … Continue reading Shrink to Fit in Excel
Using the Clipboard in MS Office
MS Office 2007 & 2010: I Thought That the Clipboard Could Hold More Than One Item? You're right - it can... you were used to accessing something like this via the Edit menu in older versions of MS Office: A clipboard pane where all the items that have been copied or cut, are stacked in … Continue reading Using the Clipboard in MS Office