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
Many of us support Excel users and those users generate a lot of our calls! What problems or questions do you get the most calls for? If you don’t see it on the poll list, please add a comment below
Continued here:
Office poll: What’s your most common support call on Excel?
Many of us support Excel users and those users generate a lot of our calls! What problems or questions do you get the most calls for? If you don’t see it on the poll list, please add a comment below
Excerpt from:
Office poll: What’s your most common support call on Excel?
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
Excel has a built-in command that lets you replace formulas with literal values. It’s a simple process, but it requires several steps: Select the range of formulas. Press [Ctrl]+C to copy the selected cells to the Clipboard
Originally posted here:
Bypass Excel’s Paste Special command when pasting literal values
Most of us need little to no help to enter a simple SUM() or AVERAGE() function. We use them often and their arguments are simple. When entering an unfamiliar function, we usually need a little more help.
Continue reading here:
Quickly display all you need to know about Excel functions while entering a function
No matter what kind of formatting you apply to an Excel sheet, you can’t easily control the number of rows on each page, when printing. Occasionally, you might end up with just a few rows printing on the last page.
Read the original here:
Eliminate a mostly blank page from the end of an Excel report
No matter what kind of formatting you apply to an Excel sheet, you can’t easily control the number of rows on each page, when printing. Occasionally, you might end up with just a few rows printing on the last page.
Excerpt from:
Eliminate a mostly blank page from the end of an Excel report
You probably know that you can use Excel’s AutoFill handle to fill a range with the elements of a series. For instance, to fill a range with the days of the week, simply enter Monday into a cell.
