Here’s how to enter a field that will update the date automatically every time you open a Word document or Excel spreadsheet. Continue reading
Ever wonder how to make individual cells locked so you don’t mistakenly edit formulas in Excel? Read this tip to find out the easy way how! Continue reading
MS Excel: A Locked Cell is Not a Cell Protected From Changes
If you’ve ever found yourself nosing around the Protection tab in the Format Cells dialog box then you’ve probably found that the Locked check-box was selected and possibly thought that your worksheet was safe from changes made by others…
There are certain things that we’d all like to have when we begin a new Excel workbook… such as number of worksheets, font, font size, etc…
For many people, this seems like an elusive process, since there are so many places to investigate looking for the old Default button.
Fortunately for all of us, a few
Richard from San Antonio asks:
I create a large number of tabs in Excel 2007 spreadsheets, each with a distinct title. Is there a way to search for a specific tab within the spreadsheet? Some of the spreadsheets might have 100 or more tabs.
Thanks for the question
MS Word: Using a Spreadsheet Within a Document
On more than one occasion, I’ve found that within a document I’ve needed to present data that really should be set up in Excel.
Don’t get me wrong, Word’s tables are great, but when it comes to calculations and numeric data displays, Excel wins hands down.
If you’re anything like me, you believe that there’s only one option when using the keyboard to paste in MS Excel – Ctrl+V.
While that obviously will paste your copied or cut information as it always has, you do have another option if you’re only looking to paste in one location.
MS Excel: Finding a Long Lost Friend… the Format Cells Dialog Box
Let’s be honest, there are times when faced with the Ribbon and all its tabs, groups and buttons, that we miss our old friend the Format Cells dialog box.
It was our “one-stop”
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 between data sections requires a bit of finesse with those borders.
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
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 ability to make use of “macros”.
What is a Macro?
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
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…
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
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?
Did the column widen to accommodate? Or, maybe you got the infamous
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 a list… Continue reading