Ranges are a powerful feature in Excel. I often wonder how I’d get my work done without them. To name a range, you probably select the appropriate cells and choose Name from the Insert menu

Original post:
Office challenge: What’s the quickest way to name a range in Excel?

Ranges are a powerful feature in Excel. I often wonder how I’d get my work done without them. To name a range, you probably select the appropriate cells and choose Name from the Insert menu.

Go here to read the rest:
Office challenge: What’s the quickest way to name a range in Excel?

This past week, I started mapping out new flowerbeds on graph paper. Now, graph paper’s cheap, but making changes takes time and sometimes you just have to start over. Unfortunately, I don’t have specialized software aimed at garden design, so I thought about what I do have–I have Excel! With just a little work, I turned an Excel sheet into a modifiable piece of graph paper.

The rest is here:
Turn an Excel sheet into graph paper

This past week, I started mapping out new flowerbeds on graph paper. Now, graph paper’s cheap, but making changes takes time and sometimes you just have to start over

Read the original post:
Turn an Excel sheet into graph paper

My recent post on embedding a Calendar control in an Excel sheet generated a lot of interesting questions. In this post, I’ll answer three of them: How to get a copy of the control How to control the position of the control How to hide the control How to get a copy of the Calendar control The easiest and safest way for Office 2003 users to get this control is to download and install Office 2003 Service Pack 3 . Be sure to install the file in the right folder: C:WindowsSystem32

See the article here:
How to acquire, position, and hide a Calendar control in an Excel sheet

My recent post on embedding a Calendar control in an Excel sheet generated a lot of interesting questions. In this post, I’ll answer three of them: How to get a copy of the control How to control the position of the control How to hide the control How to get a copy of the Calendar control The easiest and safest way for Office 2003 users to get this control is to download and install Office 2003 Service Pack 3 . Be sure to install the file in the right folder: C:WindowsSystem32.

See original here:
How to acquire, position, and hide a Calendar control in an Excel sheet

If an equation or formula attempts to divide a value by 0, Excel displays the #DIV/0! error, but that doesn’t mean the formula you’re using is wrong. Most likely, the logic is sound enough

Continue reading here:
Inhibit Excel’s #DIV/0! error

If an equation or formula attempts to divide a value by 0, Excel displays the #DIV/0! error, but that doesn’t mean the formula you’re using is wrong.

More here:
Inhibit Excel’s #DIV/0! error

Anyone entering dates should receive hazard pay. Even the best designed spreadsheet can confuse a user and frankly, it’s difficult to enter dates manually. Using the Calendar control can help.

Read the original post:
Automate an Excel calendar control

When you open a new workbook, Excel creates a copy of a template file named book.xlt (the .xlt extension denotes a template file). If you normally make the same changes to every new workbook, I recommend that you make those changes as defaults in book.xlt.

See the rest here:
Modify Excel’s default sheet to fit your needs