Custom Spreadsheet Solutions
Productivity – powered by Excel

Displaying Numbers just the way you want.

Displaying numbers in a cell is an important part of making your data easily readable. The way a number is displayed in a cell can be different to the data that is stored in the background. You can change the way the data looks by formatting the cell. Use the Number section on the Home […]

Workbook, Worksheets, and Cells: Excel Terminology.

There is some terminology that is important to understand when using an Excel spreadsheet. The workbook is the whole file. You can change the name of the workbook by saving the file with a new name, or editing the name in windows explorer. A workbook can have one or more worksheets. Each worksheet is listed […]

Much more efficient manual entry

As much as I like to automate tasks, and avoid manual entry, sometimes it is unavoidable. But when it is required, it too can be done in an efficient or inefficient way. I see people type into one cell, then use their mouse to click in the next cell to enter the next piece of […]

Text to Columns to the rescue!

I have had two times in the past couple of days when I have needed to use Text to Columns. (Short cuts keys Alt, A, E) It is a niche tool, but so good when it is needed, saving a lot of time compared to doing things manually. So, what did I use it for? […]

Flash Fill: Fill in a flash!

The Flash Fill tool in Excel is a massive time saver and is very easy to use. Use to complete tasks like splitting out first names from a list with first and last names. Yes, you can achieve this with a formula, but for most people that is too complex, and it is quicker and […]

Stop people messing with your cells.

If you share a workbook with others and want to stop them changing the sheet cells you can protect the sheet. By default all cells are protected. If you want to allow them to enter information in some cells, but not others, then you need to unlock the cells to allow them to be changed. […]

Save time, fill across worksheets…

The Fill menu has a number of interesting options. One allows you to copy the same data into multiple worksheets in one go. Select the data to copy.Hold down Ctrl and select the other worksheets that you want to copy to.Go to the Home menu, find the Editing section, select the Fill dropdown. Choose Across […]

Data Types: Get your information here!

Excel includes Data Types that can get information directly from the internet and put it straight into your spreadsheet. You can find the Data Types on the Data Menu. You can choose from twenty different types of information, including Stocks, Geography, Food, and Movies. Type in the thing you are interested in, select which data […]

Increase accuracy of data entry using Data Validation.

Using data validation in Excel means you can put restrictions on what can be entered into the cell, increasing accuracy. There are a lot of different options and settings within the data validation area. Here we have a drop down list of choices that the user can select from. You could also require the data […]