E-Mail:

Excel

Copy Excel Column Widths Along With Column Data

When you copy data between two different spreadsheets, the column widths are not copied. Unless you use the Paste Special command, this can become a real chore when you invest your time in resizing column widths for your data only to have to do it all over when the data is copied into another spreadsheet.
To [...]

How To Edit A Shared Workbook In Excel 2007

A shared workbook can be edited by multiple users at the same time. This way you do not need to keep multiple copies of the same Excel spreadsheet if input from more than one user is required.
To edit a shared workbook, you must first locate and open it from its network location. Then click the [...]

Print Comments In Excel 2002

Normally when you print a spreadsheet, any comments that exist are not printed. However, there may be cases where you want to be able to see your comments in the printed version of your spreadsheet. If so, you can configure Excel to print your comments.
To accomplish this in Excel 2002:

On the Reviewing toolbar, click the [...]

Useful Shortcuts For Excel

Keyboard shortcuts are a great way of performing little tasks more easily. Instead of having to reach for your mouse, you can press two or three keystrokes. You can use many different keystrokes when working in Excel. Below are some keystrokes used for performing common tasks.

CTRL+SHIFT+O — Selects all cells that contain comments

CTRL+P — [...]

PearBudget

Like many of you, I need to setup a budget. Here in the United States, the economy is suffering and times are tough financially for many people. With so much uncertainty out there today, it’s more important than ever to keep a strict eye on where your money is going. You may have setup a [...]

Blist

If you’re addicted to data in its purest form, then you probably love creating and maintaining databases, but for a lot of us, working on databases isn’t exactly at the top of our list of things that we love to do. One of the problems for many people is that they’re not really using the [...]

42 queries / 0.315 seconds.