Add Number to Multiple Cells in Excel

If you’ve already entered a number in a cell, or a group of cells, what’s a quick way to add something to that amount?
For example, I keep track of my To Do list in a workbook, and one of my items is “Daily Admin tasks”. Sometimes, I start the day by answering client emails, posting links to my latest blog post, and doing the accounting for the previous day’s sales.
So, I enter the time spent – 0.75 hours – and move on to the next task.
Continue reading “Add Number to Multiple Cells in Excel”

Excel Tools for Complex Workbooks

This week, I got an email from someone who sets up complex Excel workbooks, and has a few challenges:

  • Some files have so many sheets that it’s tough to find the sheet you need.
  • Files have links to other files, and sometimes the links don’t refresh correctly
  • It’s difficult to track formulas, and see how things are connected.

Are there any tools could help with these challenges? I suggested a few things, some free tools, and some paid tools. If you have other suggestions, please add them in the comments.
Continue reading “Excel Tools for Complex Workbooks”

Excel Roundup 20140616

If you still have a Commodore 64 in your basement, you could run a one-line maze generator, in Basic.
If your mom threw out that C64, years ago, you can do something similar in Microsoft Excel. On Google+, Graeme McRae posted a VBA function that will create a maze, using a random string of / and \ characters.
Here’s one that I created in Excel 2013, with a gold background, and bold font. That should keep your kids (or you) busy for a while!
excelmaze01
Continue reading “Excel Roundup 20140616”

Excel Roundup 20140609

What’s the oldest version of Excel, or other spreadsheet program, that you have lying around your office? In my office, there’s an old Multiplan disc and manual, and before that, I probably used a rock and chisel.

Gough Lui took a trip back in time, and installed Excel for Windows Version 3.0 – nine floppies, all 5.25″ in DD 360kB format. There are lots of screen shots, which might make you nostalgic for the good old days.

multiplandisk01

Continue reading “Excel Roundup 20140609”

Quick Charts and Free Upgrades

After you put data onto a worksheet, you might need to add a chart, for a visual summary of the data. In the screen shot below, there is sales data for 4 regions, and a column chart from that data.

You can quickly see that things are going better in the East region, than in the North. Probably all the snow up there kept people away from the stores!

quickchart01

Continue reading “Quick Charts and Free Upgrades”