February 2011

Open File As Read Only in Excel

February 25, 2011 Beginner

To discourage users from making any changes to a macro file you can have the file recommend Read-Only when it’s opened. To show this pop-up box when the file opens: Choose File > Save As Select Tools > General Options (on the Save As dialog box) Check the box for Read-only recommended Click OK Name […]

Get the full story …

A Woopra Chat About Excel

February 23, 2011 Formulas

I use the Woopra desktop app to view live visitors to this WordPress blog. Visitors will see a Woopra window lurking about when I’m logged into my (free) Woopra account. One option is to initiate a chat session with me. My first chat happened the other day. The chat notice startled me, but I quickly […]

Get the full story …

My First Excel 2011 Chart

February 21, 2011 Beginner

Right now I’m on the Ski slope and this particular chart served to help me kill two birds with one stone. I needed to show my daughter which ski pass would be most beneficial to her wallet and produce a chart for this article. Charts should speak for themselves, loud and clear. This one compares […]

Get the full story …

Sorting Columns From Left To Right in Excel Causes Problems

February 18, 2011 Features

You may never have the opportunity to Sort columns of data from Left to Right, but beware of some apparent problems. A reader mentioned that when sorting from left to right the column width’s don’t change. I also found that formulas can be affected and for me that’s more problematic. I was asked if Excel […]

Get the full story …

Sorting Columns Left to Right in Excel

February 16, 2011 Features

Once upon a time I had a master worksheet with data in predefined columns that was used for uploading data into a legacy system. Users would submit data in worksheets they developed, but oftentimes their columns didn’t always match that of the master worksheet. So I used a little known option in the Sort feature […]

Get the full story …

Let Excel Convert Hours Between Two Dates and Times

February 14, 2011 Formatting

In a previous post I went on and on about how you can calculate hours between two different dates and times, but Excel does this for you automatically. I’ll use reader comment as my example. A-02.02.2011 10:00 B-05.02.2011 17:00 Please help me to find B-A in hh:mm For clarity I will assume that the date […]

Get the full story …

The Mini Toolbar in Excel

February 11, 2011 Beginner

The Mini Toolbar is nice to have when you need to do basic formatting and the Home tab is not displayed. Introduced in Excel 2007 and available in Excel 2010, the Mini Toolbar appears above the shortcut menu when you right-click a cell, range, chart, shape or other object. Note: There is no Mini Toolbar […]

Get the full story …

F2 in Excel for Mac

February 9, 2011 Beginner

Switching to a Mac has its advantages but Excel shortcuts isn’t one of them. The main gripe I have is that keyboard shortcuts should be the same in every version of Excel, yet the Windows and Mac worlds are light-years apart. The F2 key is a fundamental shortcut I learned early in my Excel life. […]

Get the full story …

Create a Cell Drop-Down List in Excel with Data Validation

February 7, 2011 Intermediate

Data Validation is used to define restrictions on what data can or should be entered into a cell. Here we’ll use a List to restrict what values can be entered into a cell.

Get the full story …

Add Freeze Sheet Panes to the Quick Access Toolbar

February 4, 2011 Beginner

Add a one-click Freeze Panes command to the Quick Access Toolbar in Excel 2010 and 2007. This command icon is conveniently hidden from the Ribbon and is named Freeze Sheet Panes. In a previous post I made the recommendation to add the Freeze Panes command to the Excel Quick Access Toolbar, but recently found out […]

Related Posts Plugin for WordPress, Blogger...
Get the full story …